JDBC Driver for JDK 1.4

[vishal pradhan]

Hi All,

Currently, I am using JDK 1.4 and Data Direct's sqlserver.jar as a JDBC driver and SQL server 2008 R2 Version
for my web application, but currently we are facing some exception which might be related to jdbc version,
Exception stack trace is like :

java.sql.SQLException: [DataDirect][SQLServer JDBC Driver]Unhandled token type: Unknown token: 0x50
at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
com.ddtek.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
com.ddtek.jdbc.sqlserver.tds.TDSRequest.getRow(Unknown Source)
com.ddtek.jdbc.sqlserver.SQLServerImplResultSet.fetchAtPosition(Unknown Source)
com.ddtek.jdbc.base.BaseImplResultSet.next(Unknown Source)
com.ddtek.jdbc.base.BaseResultSet.next(Unknown Source)
com.models.DailyCreditReportBusinessObject.getDetails(DailyCreditReportBusinessObj

Also, sometimes SQL server maschine 16 CPU's spikes to 100% and stop responding in that case we need to just restart the maschine.

Can anybody tell me about this exception and the best JDBC driver which i can use for jdk 1.4 and from where i can download that?

[Ranjeet Deshmukh]

Hi Vishal,
Yes, you have to upgrade JDK 1.4 to JDK 1.5. The reason is explained here :-

http://msdn.microsoft.com/en-us/library/ms378422.aspx

[Ulf Dittmer]

You shouldn't be using either Java 1.4 or Java 5 at this time. Run, don't walk, to upgrade to something a lot more recent.

[vishal pradhan]

Thank you guys for your immediate response.
Can any body confirm me about java.sql.SQLException: [DataDirect][SQLServer JDBC Driver]Unhandled token type: Unknown token: 0x50 exception, that it is due to old JDBC driver only?