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

[Jeroen F. <je...@su...>]

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!