Re: [Fwd: call Java procedure from Mysql]

Hmm... I wonder if they are any prizes for slow replies... Ho hum.

The reason why it did not work was because the syntax is wrong. He  
forgot to specify an argument lit. If there are no parameters, it  
needs at least the () parentheses.

I should update the wiki with the precise grammar the patch requires.

Regards,
Antony


On 15 Jul, 2008, at 14:29, Eric Herman wrote:
> -------- Original Message --------
> Subject: call Java procedure from Mysql
> Date: Wed, 4 Jun 2008 14:23:47 +0530
> From: Anushree Jindal <[email protected]>
> To: [email protected]
>
> Hi,
>
> I have a java procedure which i want to call from mysql 5.0.51b and   
> JDK
> 1.6.06.
> Also downloaded the mysql Connector/J i.e 5.1.6
> I have created a procedure like this
>
> CREATE PROCEDURE PROC
> LANGUAGE JAVA
> EXTERNAL NAME 'com.stardeveloper.example.Jdbcexample3'
> PARAMETER STYLE JAVA;
>
> But this is showing syntax error near LANGUAGE JAVA and the rest
>
> If any body know thw answer please revert me back with the solution
>
> Thanks,
>
> Anushree
>
>
> -- 
> Eric Herman, Software Developer
> MySQL AB, www.mysql.com
> VoIP Ext: 6594   US: +1 408 213 6540  Europe: +46 18 174 400
> Mobile: +31 62 07 19 662   Netherlands: 062 07 19 662


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]