I read through some of issues about MSSQL 2000. Could someone share the
jdbc jar file that you are able to use, JDBC Version 2 sqljdbc.jar?
I am doing a small test program to insert a simple CURRENCY data into MSSQL
and it works well. However, when tries to do a subsequent select following
a successful insert, it throws this error:
com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS
The following is the trace:
[2009-06-11 01:52:25 SGT] <WorkerThread1> evaluateExpression:
<com.webobjects.jdbcadaptor.JDBCExpression: "INSERT INTO CURRENCY(VNAME,
VDESCRIPTION, DATE_TIME, CURRENT_DATE_TIME, CURRENT_KEY) VALUES (?, ?, ?, ?,
?)" withBindings: 1:"Malaysia"(vName), 2:"This is going to be ...ng
description ....."(vDescription), 3:2009-06-11 01:52:25(dateTime),
4:2009-06-11 01:52:25(currentDateTime), 5:1(currencyKey)>
[2009-06-11 01:52:25 SGT] <WorkerThread1> === Commit Internal Transaction
[2009-06-11 01:52:25 SGT] <WorkerThread1> === Begin Internal Transaction
[2009-06-11 01:52:25 SGT] <WorkerThread1> evaluateExpression:
<com.webobjects.jdbcadaptor.JDBCExpression: "SELECT t0.CURRENT_KEY,
t0.CURRENT_DATE_TIME, t0.DATE_TIME, t0.VDESCRIPTION, t0.VNAME FROM CURRENCY
t0">
Jun 11, 2009 1:52:25 AM com.microsoft.sqlserver.jdbc.TDSReader
throwInvalidTDS
SEVERE: ConnectionID:2 got unexpected value in TDS response at offset:180
[2009-06-11 01:52:25 SGT] <WorkerThread1> === Rollback Internal Transaction
[2009-06-11 01:52:25 SGT] <WorkerThread1> connecting with dictionary:
{plugin = "MSSQLServerPlugIn"; username = "sa"; driver =
"com.microsoft.sqlserver.jdbc.SQLServerDriver"; password = "<password
deleted for log>"; URL =
"jdbc:sqlserver://CHNGXPH:1433;DatabaseName=test;SelectMethod=cursor;"; }
[2009-06-11 01:52:25 SGT] <WorkerThread1> === Begin Internal Transaction
[2009-06-11 01:52:25 SGT] <WorkerThread1> evaluateExpression:
<com.webobjects.jdbcadaptor.JDBCExpression: "SELECT t0.CURRENT_KEY,
t0.CURRENT_DATE_TIME, t0.DATE_TIME, t0.VDESCRIPTION, t0.VNAME FROM CURRENCY
t0">
Jun 11, 2009 1:52:25 AM com.microsoft.sqlserver.jdbc.TDSReader
throwInvalidTDS
SEVERE: ConnectionID:3 got unexpected value in TDS response at offset:180
[2009-06-11 01:52:25 SGT] <WorkerThread1>
<com.webobjects.appserver._private.WOComponentRequestHandler>: Exception
occurred while handling request:
com.webobjects.jdbcadaptor.JDBCAdaptorException: The connection is closed.
[2009-06-11 01:52:25 SGT] <WorkerThread1>
com.webobjects.jdbcadaptor.JDBCAdaptorException: The connection is closed.
at
com.webobjects.jdbcadaptor.JDBCContext.rollbackTransaction(JDBCContext.java:453)
at
com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:306)
at
com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:261)
Cheers
Cheong Hee
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
