philippe02 <[email protected]> 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
