Re: How to call external JAVA program from SQL SELECT statement? - Matthew Pocock - com.mysql.lists.java

6 messages in com.mysql.lists.javaRe: How to call external JAVA program...

From	Sent On	Attachments
Stepan RYBAR	24 Jun 2003 01:01
Nick Stuart	24 Jun 2003 05:31
Matthew Pocock	24 Jun 2003 08:25
Mark Matthews	24 Jun 2003 08:40
Shankar Unni	24 Jun 2003 09:01
Stepan RYBAR	24 Jun 2003 22:45

Subject:	Re: How to call external JAVA program from SQL SELECT statement?
From:	Matthew Pocock (matt...@yahoo.co.uk)
Date:	06/24/2003 08:25:56 AM
List:	com.mysql.lists.java

Nick Stuart wrote:

I don't think this will ever be a feature of MySQL for several reasons. One, its not in the JDBC spec, and its another is that MySQL is written in C/C++ so doesn't know anything about java. Calling java commands from select statements would require bascially a re-write.

However, not to plug another database or anything but the McKoi DB can currently do this, or something like this. I dont have the site here but just google it.

If I'm wrong here, anyone feel free to jump in and yell at me! -Nick

Also, you may be able to do this with oracle, which you can download for free for linux.

On Tue, 2003-06-24 at 04:01, Stepan RYBAR wrote:

Hallo!

Can I ask You, if it is possible to call Java program from SQL SELECT statement? Something like:

SELECT id, name FROM parcels WHERE id IN (Intersects('parcels', 'POLYGON((0 0,1 0,1 1,1 0))'))

Where Intersects is my own java program (Intersects.class) with function declaration e.g.:

String tokenisedIds Intersects(String tableName, String geometryInWKT)

If it is possible now, please send me any how-to with example, or at least any documentation. Or will it be possible in any near future version of MySQL? Also the same using C++ is acceptable.

Thank You

Stepan

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Stepan RYBAR e-mail: xryb...@seznam.cz mobil: +420607636256 Modra 6, Stodulky 1979, Praha, 155 00 IC: 71078592 AC: 22123199

----------------------------------------