Re: ikvm and MS SQL Server 2012

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:[email protected]]
> Sent: Friday, February 21, 2014 20:48
> To: [email protected]
> 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!

------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk