dcsimg
Proublem with datetime fields under the MS JDBC for SQL2000
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Vyacheslav_Yakovenko
Posted On:   Thursday, August 1, 2002 06:22 AM

OS: W2K SP2 JVM: SUN's J2SDK 1.4.0_01 Driver: Microsoft SQL Server 2000 Driver for JDBC /2002-07-23/ Servlet container: Resin 2.1.2 I have a proublem with accessing the data stored in the datetime, nvarchar and ntext fields only. When I'm trying to reache them with construction resultset.getDate(), .getString() etc. I tried the getObject() , getTimestamp() - there is no effect. java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 3. at com.microsoft.jdbc.base.BaseExceptions.createException (Unknown Source) at com.mic   More>>
OS: W2K SP2

JVM: SUN's J2SDK 1.4.0_01

Driver: Microsoft SQL Server 2000 Driver for JDBC /2002-07-23/

Servlet container: Resin 2.1.2

I have a proublem with accessing the data stored in the
datetime, nvarchar and ntext fields only. When I'm
trying to reache them with construction
resultset.getDate(), .getString() etc. I tried the
getObject() , getTimestamp() - there is no effect.


			
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver
for JDBC]ResultSet can not re-read row data for column 3.

at com.microsoft.jdbc.base.BaseExceptions.createException
(Unknown Source) at
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source) at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex
(Unknown Source)at
com.microsoft.jdbc.base.BaseResultSet.getString(Unknown
Source) at com.microsoft.jdbc.base.BaseResultSet.getString(Unknown
Source)
   <<Less
About | Sitemap | Contact