[Hibernate-issues] [Hibernate-JIRA] Assigned: (HB-145) insert for classes with composite-id crashes

[<leg...@at...>]

Message:

   The following issue has been re-assigned.

   Assignee: Gavin King (mailto:ga...@in...)
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-145


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-145
    Summary: insert for classes with composite-id crashes
       Type: Bug

     Status: Assigned
   Priority: Minor

    Project: Hibernate2

   Assignee: Gavin King
   Reporter: Hrituc Ovidiu

    Created: Thu, 19 Jun 2003 10:21 AM
    Updated: Tue, 8 Jul 2003 7:13 PM
Environment: W2k professional, SQL Server 2k, OC4J

Description:
Insert for classes with composite-id crashes when persisting to SQL Server 2000.
The composite id consists of the COD, DATA_FIN combination. I am trying to keep the history of a person in the same table and the current record to be the combination (COD_Value, 01/01/3000)
The current manager's data gets pulled out with a many-to-one relationship with a composite fk (MGR_ID, BOGUS_DT_FIN).
Loading goes ok. 
Insert doesn't, the exceptions look like this:

Hibernate: insert into PERSON (PKID, NAME, DATA_INI, DEPT_ID, MGR_ID, BOGUS_DT_FIN, COD, DATA_FIN) values (?, ?, ?, ?, ?, ?, ?, ?)

Jun 19, 2003 6:02:16 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions

WARNING: SQL Error: 0, SQLState: 07009

Jun 19, 2003 6:02:16 PM net.sf.hibernate.util.JDBCExceptionReporter logExceptions

SEVERE: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).

Jun 19, 2003 6:02:17 PM net.sf.hibernate.JDBCException <init>

SEVERE: Could not synchronize database state with session

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).

	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

	at com.microsoft.jdbc.base.BasePreparedStatement.validateParameterIndex(Unknown Source)

	at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source)

	at com.microsoft.jdbc.base.BasePreparedStatement.setTimestamp(Unknown Source)

	at com.evermind.sql.FilterPreparedStatement.setTimestamp(FilterPreparedStatement.java:394)

	at com.evermind.sql.FilterPreparedStatement.setTimestamp(FilterPreparedStatement.java:394)

	at net.sf.hibernate.type.TimestampType.set(TimestampType.java:27)

	at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:46)

	at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:31)

	at net.sf.hibernate.type.ComponentType.nullSafeSet(ComponentType.java:163)

	at net.sf.hibernate.persister.EntityPersister.dehydrate(EntityPersister.java:369)

	at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:446)

	at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:20)

	at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2064)

	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2036)

	at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:1980)

	at it.saga.library.commonDataTypes.impl.CdtBLGBaseSessionBean.save(CdtBLGBaseSessionBean.java:247)

	at CdtBLGPerson_StatelessSessionBeanWrapper10.save(CdtBLGPerson_StatelessSessionBeanWrapper10.java:133)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

	at java.lang.reflect.Method.invoke(Method.java:324)

	at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:119)

	at com.evermind.server.rmi.RMICallHandler.run(RMICallHandler.java:48)

	at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:797)

	at java.lang.Thread.run(Thread.java:536)




---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira