on 2014 Mar 20 11:55 AM
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
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.