cancel
Showing results for 
Search instead for 
Did you mean: 

Calling external java function

Former Member
0 Kudos
2,334

Hi! -- SQL Anywhere Network Server Version 12.0.1.3994

We are getting the following error when calling a java function frpm a procedure.

ALTER PROCEDURE "LogMessageOnce"( in @SERVER char(80),in @PORT integer,in @TYPE char(1),in @GRP char(4),in @MESSAGE char(250) ) no result set external name 'se.davision.common.Log.messageDebug (Ljava/lang/String;ILjava/lang/String;Ljava/lang/String;Ljava/lang/String;)V' language java

java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Table 'ExtEnvMethodArgs' not found

at sybase.jdbc.sqlanywhere.IIStatement.nativeExecuteUpdate(Native Method)

at sybase.jdbc.sqlanywhere.IIStatement.executeUpdate(IStatement.java:551)

at sybase.jdbc.sqlanywhere.IStatement.executeUpdate(IStatement.java:300)

at ianywhere.sa.jvm.SAJvm.getMethodArgs(SAJvm.java:655)

at ianywhere.sa.jvm.SAJvm.executeMethod(SAJvm.java:1391)

at ianywhere.sa.jvm.SAJvm.run(SAJvm.java:317)

The java method we call take a couple of arguments and try to send a message via a socket. If I access the method (procedure calling the methhod) from ISQL, it works, and if I restart the database it also works, for some time. After that I keep getting this exceptions in the dbconsole. We do NOT do anything with the database inside the method, just taking the parametses and send them out o a socket.

If I add a system.out as first line in the java method, I can't see it so I think the error happens then the database try to figure out how to call the method.

Any ideas appreciated. Regards Janne

Accepted Solutions (0)

Answers (0)