Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Strange SQLException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Strange SQLException" Watch "Strange SQLException" New topic
Author

Strange SQLException

Martin Lira
Ranch Hand

Joined: May 26, 2004
Posts: 97
Guys,
I am using a connection pool (DataSource built in Websphere studio)to connect to SQLServer.
My JDBC provider is WebSphere embedded ConnectJDBC driver for MS SQL Server
On one select method that returns around 20000 rows it has started giving me this exception.
[IBM][SQLServer JDBC Driver]Unhandled token type: Unknown token: 0x2f

I never used to get this exception before with the same amount of rows being returned (20K should not be a large no i guess)

If I try to use the same DataSource after this error in some other method I get this exception
[IBM][SQLServer JDBC Driver]Request cannot be submitted due to wire contention.

Thanks,
ML
Martin Lira
Ranch Hand

Joined: May 26, 2004
Posts: 97
Looks like gurus have never had this issue....


Thanks
Martin
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30071
    
149

Originally posted by Martin Lira:
Looks like gurus have never had this issue....

We're not ignoring you I've never seen anything like this before either!


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Martin Lira
Ranch Hand

Joined: May 26, 2004
Posts: 97
I found that this error has also occured while using a MS SQL server JDBC driver and not just the IBM embedded driver.

[Microsoft][SQLServer 2000 Driver for JDBC]Unhandled token type: Unknown
token: 0x00
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30071
    
149

Martin,
Hmm. "Unknown token" - Are you dealing with binary or encoded data by any chance?
Mahesh Mamani
Ranch Hand

Joined: Jun 25, 2001
Posts: 110
The link below may give some solution. Pls try it.

http://forums.datadirect.com/forums/thread.jspa?threadID=432&tstart=60
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Strange SQLException
 
Similar Threads
[IBM][SQLServer JDBC Driver]This driver is locked for use
Exception
Problem in making connection
IBM SQLServer JDBC Driver
Unable to get a PooledConnection from the DataSource