Hi Knut Tanks for your help I tried with all In upper case , all in lower case it doesn't work ...
Regards Philippe Le 18 avr. 2013 à 12:06, "Knut Anders Hatlen-5 [via Apache Database]" <[email protected]> a écrit : > philippe02 <[hidden email]> 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 > > > If you reply to this email, your message will be added to the discussion > below: > http://apache-database.10148.n7.nabble.com/Problem-to-use-java-classes-in-Derby-tp129202p129423.html > To unsubscribe from Problem to use java classes in Derby, click here. > NAML -- View this message in context: http://apache-database.10148.n7.nabble.com/Problem-to-use-java-classes-in-Derby-tp129202p129424.html Sent from the Apache Derby Developers mailing list archive at Nabble.com.
