error message using timestamp with MS-SQL 2000

ogross · **Joined:** Thu Mar 25, 2004 9:13 am **Posts:** 20

Hi there, I am using a timestamp as follows (Hibernate 2.1):

Code:

<property name="creationTimeStamp" type="timestamp" column="NET_CREATION_DATE"/>

The is a TIMESTAMP in my SQL2000 server, and the property is mapped to:

Code:

public java.sql.Timestamp getCreationTimeStamp() {
        ...
    }

    public void setCreationTimeStamp(java.sql.Timestamp timestamp) {
        ...
    }

Yet I am getting the following error message:

Code:

java.sql.SQLException: Disallowed implicit conversion from data type datetime to  data type timestamp, table 'snap.dbo.SSN_NETWORKS', column 'NET_CREATION_DATE'.  Use the CONVERT function to run this query.

What am I missing here?

TIA Oren

michael · **Posted:** Mon Apr 19, 2004 4:13 pm

Probably use another driver, try the jdts driver.

ogross · **Joined:** Thu Mar 25, 2004 9:13 am **Posts:** 20

It is the JTDS driver...

Code:

hibernate.connection.driver_class=net.sourceforge.jtds.jdbc.Driver

ogross · **Joined:** Thu Mar 25, 2004 9:13 am **Posts:** 20

I also tried sprinta2000 by inet...

Code:

hibernate.connection.url=jdbc:inetdae:localhost:1433?database=dbname 
hibernate.connection.driver_class=com.inet.tds.TdsDriver

I am getting the following error:

Code:

Disallowed implicit conversion from data type varchar to data type tim
estamp, table 'snap.dbo.SSN_NETWORKS', column 'NET_CREATION_DATE'. Use the CONVERT function to run this query

.

To make it clear, when I use jTDS, I use 0.7.1 as follows:

Code:

hibernate.connection.url=jdbc:jtds:sqlserver://localhost/dbname
hibernate.connection.driver_class=net.sourceforge.jtds.jdbc.Driver

alin_sinpalean · **Posted:** Wed Apr 21, 2004 3:25 am

The TIMESTAMP of SQL Server is not the same as the Java Timestamp. It's a read-only binary column automatically updated by SQL Server when the row is altered (it's used for replication and optimistic concurrency among others).

So just declare your column as DATETIME instead and it should work.

Alin.