db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: Problem to use java classes in Derby
Date Thu, 18 Apr 2013 10:05:38 GMT
philippe02 <justalongway@yahoo.fr> writes:

> Hi Rick
> Thanks for your message.
> Here is my function
> CREATE function CopyUserdata(
> ID int ,
> MACHINE int ,
> JOB varchar(50) ,
> RECEIVED varchar(50) ,
> FIELD varchar(50) ,
> VALUE varchar(255) ,
> STANDARD int)
> returns int
> LANGUAGE JAVA
> PARAMETER STYLE JAVA
> NO SQL
> EXTERNAL NAME 'sendTOSQLserver.RecordToUserdata';
> My Java code
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.Statement;
> public class sendTOSQLSERVER {

Hi Philippe,

It looks like the Java class name doesn't match the name used in the
EXTERNAL NAME clause of the CREATE FUNCTION statement (sendTOSQLSERVER
vs sendTOSQLserver). It might work better if they match. Note that case
differences are significant in Java class names.

Hope this helps,

-- 
Knut Anders

Mime
View raw message