specs for my configuration are below. this same code has worked on previous versions of sqlserver. however i am getting an error when i try to insert a record into sql server 2005. note that a select does execute properly on this same table, so it's not a connectivity issue.

i am simply trying to save an empty row so that an identifier will be generated. however i get an error when the code is executed. "unsupported conversion from 108 to BIGINT." note that i am not sure what 108 is. also note that there is another post from someone with a similar issue (also 108), so i think 108 means something to hibernate or the database - it has nothing to do with my data.

i appreciate your time.
chris


Hibernate version: 3.0

Mapping documents:
<class name="com.ci.db.member.SyncTimes" table="dataForceKP.sync_times" >
<id name="id" type="long" unsaved-value="null">
<column name="sync_id" sql-type="int" not-null="true" />
<generator class="native" />
</id>
<property name="sfSyncStartDate" type="java.util.Date">
<column name="sf_sync_start_date" sql-type="datetime" not-null="false" />
</property>
<property name="sfSyncEndDate" type="java.util.Date">
<column name="sf_sync_end_date" sql-type="datetime" not-null="false" />
</property>
<property name="crmSyncStartDate" type="java.util.Date">
<column name="crm_sync_start_date" sql-type="datetime" not-null="false" />
</property>
<property name="crmSyncEndDate" type="java.util.Date">
<column name="crm_sync_end_date" sql-type="datetime" not-null="false" />
</property>
</class>



Code between sessionFactory.openSession() and session.close():
SyncTimes newSyncTimes = new SyncTimes();
Object obj = hibSession.save(newSyncTimes);

Full stack trace of any exception that occurs:
Hibernate: insert into dataForceKP.sync_times (sf_sync_start_date, sf_sync_end_date, crm_sync_start_
date, crm_sync_end_date) values (?, ?, ?, ?)
10750 [main] WARN ate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
10750 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
10750 [main] ERROR ate.util.JDBCExceptionReporter - Unsupported conversion from 108 to BIGINT

Name and version of the database you are using:
MS SQLServer 2005

one additional note. i was using the microsoft beta 2 driver when i was getting this error. i grabbed the jturbo driver and my initial tests look very good - no errors yet. so it may just be a beta driver thing...
thanks
chris

You can also try this driver for SQLServer : http://jtds.sourceforge.net/
as it is under LGPL and free to use.