The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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:

×22

question asked: 20 Mar '14, 11:55

question was seen: 832 times

last updated: 20 Mar '14, 12:30