Call Java Method in MS SQL

[mexyz]

Hi all,

Is there a way to call a java method in ms sql? I've only tried it in Orale. I want to do the same with MS SQL. Thanks in advance :)

[RamyaSivakanth]

Please explain some more.Your question is not clear.Did u mean database calls via java?

[mexyz]

I mean, calling a java method that resides in ms sql database. I want to put my java classes in the database and be able to invoke the methods in the database and vice versa.

[RamyaSivakanth]

I think u are talking about jdbc...Do u want to perform any database operations from java?

[mexyz]

I am able to connect to database from java through jdbc. How about from database to java? Is there such a thing like that in ms sql? Is there a way to put all my java methods as ms sql database package?
Ohh no.. sorry if I can't get my query clear for you. In Oracle, there is a support in developing, storing and deploying Java applications. I want to know if ms sql has that support also for java. Thank you so much :)

[Tolls]

Nope.
That was easy...

Oracle has a Java engine inside it, MS SQL does not.

[mexyz]

Thanks for the replies.
So, there is also no way to store Java methods or classes to MS SQL database?

[Tolls]

Well, I suppose you could store them in there, but what you'd do with them I don't know.

[FON]

There is a Thread on this forum with full example of
storing java object into Oracle DB:


How to insert java Object in oracle database

So it is serialization story, but what everybody here want to know is
what is purpose of your question
and what are you trying to do with Java and MS SQL?

What kind of methods you plan to store there, why and what is purpose
of calling them in that way.

If you answer this i'm sure many will try to help including me ;)

[Tolls]

Oracle has a built in Java engine, so you can write Java classes/methods and compile them into Oracle itself, allowing you to call them as though they were stored procedures. The OP is asking if you can do the same in MS SQL.

And now wants to know if you can save classes (not serilialized objects) in MS SQL. For what purpose I don't know, since they won't be able to run them...

[RamyaSivakanth]

I don't think MS SQL has that built in java engine.I have to explore more to confirm u.

I think our moderators can confirm.

[Tolls]

No, it doesn't.

[mexyz]

Yes, I want to store Java classes in MS SQL Server and execute them within the database.

@Tolls: "...since they won't be able to run them..." -> MS SQL won't be able to run the classes because it doesn't have Java engine, am I right?

[Tolls]

Yes.
The only db I am aware of that contains a JVM is Oracle.
That is, a JVM which will run Java stuff as though they were stored procedures.
Oracle fluffs about with them and sticks a PL/SQL front end on them.

[r035198x]

SQL Server stored procedures can call COM objects which can call Java. That approach is probably very painful to implement in a portable manner.

The latest versions of SQL Server have the .NET framework runtime. This means you can write stored procedures in any managed .NET language. That is probably a better route to go.

DB2 also supports Java stored procedures.

[Tolls]

db2 does?
Surprises me a bit.

[r035198x]

You can define so called external stored procedures in quite a few languages actually (including some M$ languages).

Postgres also supports Java, Perl,Python,C++ ...

[r035198x]

You can define so called external stored procedures in quite a few languages actually (including some M$ languages).

Postgres also supports Java, Perl,Python,C++ ...

[Tolls]

Ah, that's not quite the same beast.
Oracle stores it all internally, which is what I think this chap is after.
You're not making any external calls at all.

Postgres, for example, isn't running the Java as part of the db.

[FON]

I still want to know WHY are u using this? :)