Our product use SA 10.0.1(3807 Windows; 3805-Linux) , as application
server used jboss 4.0.5. Connection to database used jconn3.jar
manifest info -
Name: com/sybase/jdbcx/
Specification-Title: "jConnect for JDBC 3.0"
Implementation-Title: "com.sybase.jdbcx"
Specification-Version: "6.0"
Specification-Vendor: "Sybase, Inc."
Implementation-Version: "Build (26564)"
Implementation-Vendor: "Sybase, Inc."
When running big SQL query size around 56K we get follows error -
java.sql.SQLException: JZ0PE: The number of columns in your cursor
declaration OR the size of your cursor declaration itself are large
enough that you require widetable support. But either the server does
not offer such support, or it was not requested during the login
sequence. Try setting the JCONNECT_VERSION property to >= 6 if you
wish to request widetable support.
We have set to connection string explicitly JCONNECT_VERSION=6 but
this error appears again. In the same time running this query from
dbisql - query is working properly.
Any idea what is the problem!?

Thanks, Hanan Brener