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

asked 20 Mar '14, 11:55

Janne's gravatar image

Janne
46336
accept rate: 0%

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×23

question asked: 20 Mar '14, 11:55

question was seen: 2,113 times

last updated: 20 Mar '14, 12:30