Re: help | ikvmc | CLR | SS2012 | .NET 4.0

On 14 March 2014 16:03, Akshat Sharma <[email protected]> wrote:

> Fellow Developers,
>
> I have a situation in hand and was hoping if you could help me here.
>
> Background :
> I have a piece of code in Java, my aim was to convert the resultant jar
> into a dll and then use this dll in CLR integration for SQL Server 2012.
>
> Process followed :
> Java - its a single class with imports as
> import java.io.UnsupportedEncodingException;
> import javax.crypto.spec.IvParameterSpec;
> import javax.crypto.spec.SecretKeySpec;
> import org.apache.commons.codec.binary.Base64; <commons-code-1.6.jar>
>
> I first converted the dependent jar into a dll
> then the main jar into a dll
>
> ikvmc -out:commons-codec-1.6.dll commons-codec-1.6.jar
> ikvmc -out:cipher.dll cipher.jar -r:commons-codec-1.6.dll
>
> I made a small project in c# and tried to use this dll, it worked like a
> charm.
>
> The problem :
> The real objective was to make this dll available in SQL Server 2012.
> Now, when I try to create an assembly in SQL Server 2012 using this jar,
> which is placed in the bin folder of ikvmc so at runtime all dependent
> dll's are available.
>
> CREATE ASSEMBLY cipher from 'd:...\ikvm\bin\cipher.dll' WITH
> PERMISSION_SET = SAFE
>
> "Msg 6213, Level 16, State 1, Line 1
> CREATE ASSEMBLY failed because method "getAttribute" on type
> "java.text.AttributedString" in safe assembly "IKVM.OpenJDK.Text" has a
> synchronized attribute. Explicit synchronization is not allowed in safe
> assemblies."
>
> so I went with unsafe
> CREATE ASSEMBLY cipher from 'd:...\ikvm\bin\cipher.dll' WITH
> PERMISSION_SET = UNSAFE
>
> "Msg 10301, Level 16, State 1, Line 1
> Assembly 'cipher' references assembly 'system.drawing, version=2.0.0.0,
> culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in
> the current database. SQL Server attempted to locate and automatically load
> the referenced assembly from the same location where referring assembly
> came from, but that operation has failed (reason: 2(The system cannot find
> the file specified.)). Please load the referenced assembly into the current
> database and retry your request."
>
> So I thought it is looking for version 2 of this specific dll and not able
> to find it, so I searched around and felt that placing the version two of
> System.Drawing and System.Windows.Forms in the bin might help, which,
> didn't.
>
> "Warning: The Microsoft .NET Framework assembly 'system.drawing,
> version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a,
> processorarchitecture=msil.' you are registering is not fully tested in the
> SQL Server hosted environment and is not supported. In the future, if you
> upgrade or service this assembly or the .NET Framework, your CLR
> integration routine may stop working. Please refer SQL Server Books Online
> for more details.
> Msg 6586, Level 16, State 1, Line 1
> *Assembly 'System.Drawing' could not be installed because existing policy
> would keep it from being used.*"
>
> What I could deduce was that CLR Integration for SQL Server 2012 requires
> that all dependency should be dotnet 4 at least and as this dll is not, it
> fails.
>
> What do I need to do to get this running ?
>
> Any help will be much appreciated !!!
>
> P.S : My dotnet framework knowledge is below par so don't mind any
> senseless comment I might have made out there.
>
> --
> Kind Regards,
> Akshat
>



-- 
Kind Regards,
Akshat

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech

_______________________________________________
Ikvm-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ikvm-developers