Server log [error -131]

Classic Servoy
1

on the “server log” panel i get this repetitive error:

com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -131: Syntax error near ‘,’ on line 1

com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -131: Syntax error near ',' on line 1
	at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636)
	at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996)
	at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
	at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
	at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
	at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1510)
	at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1495)
	at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:70)
	at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source)
	at $Proxy1.executeQuery(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:179)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:179)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:179)
	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source)
	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
	at sun.rmi.transport.Transport$1.run(Transport.java:148)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
	at java.lang.Thread.run(Thread.java:554)

according to the ASAError messages manual the -131 error code:
<<Probable cause The database server cannot understand the statement you are trying to execute. If you used a keyword (such as DATE) for a column name, try enclosing the keyword in quotation marks (DATE).>>
is there any way to get by which method this error could be generated? (well, other than walking through all the solution, off course ;) )

2

start servoy developer with stacktrace support:

java -DSTACKTRACE=TRUE -jar servoy_developer.jar

then you will see the sql that is send through it.
You could also send the solution to me who does this.

3

jcompagner:
start servoy developer with stacktrace support:

java -DSTACKTRACE=TRUE -jar servoy_developer.jar

then you will see the sql that is send through it.
You could also send the solution to me who does this.

Amazing!
Thanks Johan, this is a great tip.

I’ll give a try, in case… ;)

Armando