[jboss-user] [JNDI/Naming/Network] - Re: SQL query missinterperted in JBOSS. How can I correct it

[badam571]

Hi PeterJ

Here is stacktrace for error:

2008-08-22 12:06:22,427 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Created Connection proxy for invoker=jboss:service=invoker,type=jrmp, targetName=jboss.jca:service=DataSourceBinding,name=aco_code, cacheID=25803197

2008-08-22 12:06:22,427 INFO  [STDOUT] data-source: org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy at 191c263

2008-08-22 12:06:22,427 INFO  [STDOUT] connection: 25803197

2008-08-22 12:06:22,427 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Created Statement proxy for invoker=jboss:service=invoker,type=jrmp, targetName=jboss.jca:service=DataSourceBinding,name=aco_code, cacheID=1031493

2008-08-22 12:06:22,447 DEBUG [com.base.SqlEngine] debug2 ====>com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name ' '.

2008-08-22 12:06:22,447 INFO  [STDOUT] debug2 ====>com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name ' '.
2008-08-22 12:06:22,447 DEBUG [com.base.SqlEngine] debug2 ====>com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name ':'.

2008-08-22 12:06:22,447 INFO  [STDOUT] debug2 ====>com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name ':'.
2008-08-22 12:06:22,447 DEBUG [com.base.SqlEngine] debug2 ====>com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name '00'.

2008-08-22 12:06:22,447 INFO  [STDOUT] debug2 ====>com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name '00'.

2008-08-22 12:06:22,457 DEBUG [org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService] Closed Statement=1031493

2008-08-22 12:06:22,457 INFO  [STDOUT] results: false


You can see that results is equal to: false .. results is the output of: stmt.execute(sqlcommand)

do I need  to paste all the server long here?

Best Regards
badam571


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4172061#4172061

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4172061