JCONNECT_VERSION

I am having a huge problem after importing 65000 rows into a table. Somehow Sybase cant seem to sort on a varchar (15) column. Something about asking for a wide table support. I have been googling and the sites I have seen tells you can set the jconnect_version …but i can find how. Anyone have this similar problem.
We are in the process of installing it today. It’s our first client and our first order…so we are under a lot of stres of delivering what we have promised…but this is putting a sudden death to our project.
Any help is really appreciated

java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0PC: The number and size of parameters in your query 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. JZ006: Caught IOException: java.io.IOException: JZ0PC: The number and size of parameters in your query 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.

Nasty thing to happen just before going live.

googled around abit: Have you tried adding “JCONNECT_VERSION=6” to the connection URL for the Server?

So, something like:

jdbc:sybase:Tds:host.at.some.domain:5000/db_name?JCONNECT_VERSION=6

That might help. Otherwise, my best quess is trying different drivers…

Paul

pbakker:
Nasty thing to happen just before going live.

googled around abit: Have you tried adding “JCONNECT_VERSION=6” to the connection URL for the Server?

So, something like:

jdbc:sybase:Tds:host.at.some.domain:5000/db_name?JCONNECT_VERSION=6

That might help. Otherwise, my best quess is trying different drivers…

Paul

It seems to be working…At first adding JCONNECT_VERSION=6 didn’t do the trick…I also removed an unnecessary query that loaded about 65000 dossier into a foundset…I think that caused the problem…eitherway Its solved…thankx