Re: ikvm and MS SQL Server 2012

Hello Ovidiu,

Well, it works for me, so I can't help you unfortunately (rebuilding without the circular dependency is not an option).

Regards,
Jeroen

From: Ovidiu MacSiniuc [mailto:[email protected]]
Sent: Monday, February 24, 2014 12:10
To: Jeroen Frijters; [email protected]
Subject: Re: [Ikvm-developers] ikvm and MS SQL Server 2012

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

------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk

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