Re: [Ikvm-developers] ikvm and MS SQL Server 2012

[Ovidiu M. <mso...@ya...>]

Hello Jeroen,


Thank you for your fast response.
Unfortunately, your suggested solution is not working. 

My problem is the mutually dependencies between ikvm assemblies, the SQL Server does not complain about  .NET dependencies. 
My mistake, I should have been more explicit by pasting the error message. Here they are:

When attempting to add the IKVM.Runtime.dll:
Assembly 'ikvm.openjdk.core, version=7.2.4630.5, culture=neutral, publickeytoken=13235d27fcbfff58.' was not found in the SQL catalog.


And the other way around, adding the IKVM.OpenJDK.Core.dll:
Assembly 'ikvm.runtime, version=7.2.4630.5, culture=neutral, publickeytoken=13235d27fcbfff58.' was not found in the SQL catalog.

Many thanks, 
Ovidiu




On Saturday, February 22, 2014 11:34 AM, Jeroen Frijters <je...@su...> wrote:
 
Hi,

I don't recommend it (running unsafe code in your database can affect performance, scalability and security), but I had no problem installing IKVM.Runtime.dll (and its dependencies) in SQL Server 2012.

Here's what I did:
1) ALTER DATABASE ikvm SET TRUSTWORTHY ON
2) copy Accessibility.dll, System.Drawing.dll, System.Runtime.Serialization.Formatters.Soap.dll and System.Windows.Forms.dll from \Windows\Microsoft.NET\Framework\ v4.0.30319 to \ikvm\bin directory.
3) CREATE ASSEMBLY ikvm_runtime from '\ikvm\bin\ikvm.runtime.dll' WITH PERMISSION_SET = unsafe

This imported IKVM.Runtime.dll and all the dependencies into the database.

Regards,
Jeroen


> -----Original Message-----
> From: Ovidiu MacSiniuc [mailto:mso...@ya...]
> Sent: Friday, February 21, 2014 20:48
> To: ikv...@li...
> Subject: [Ikvm-developers] ikvm and MS SQL Server 2012
> 
> Hello everyone,
> 
> I am trying to add MSSQL support for a java application and I need to
> add some user-defined functions to the server. They are already written
> in java7 and cross-compiled with IKVM as an assembly.
> Before adding my assembly the SQL server requires that dependencies must
> be added first one at a time. The problem I face is that the
> IKVM.Runtime.dll and IKVM.OpenJDK.Core.dll mutually depend on each other
> so they cannot be installed in the database independently.
> 
> 
> 
> My question is: has anybody run java code within MS SQLSERVER 2012 ?
> Or, is there a possibility for building IKVM with at least the two above
> mentioned libraries as a single compile unit ?
> 
> 
> Thank you for any suggestion!