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

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

The following comment has been added to this issue:

     Author: Gavin King
    Created: Thu, 19 Jun 2003 7:08 PM
       Body:
Well, this is certainly not a generic problem with composite-id mappings, since they work perfectly in the test suite.

So it looks like something special in your case.

(1) You would need to give much more information.
(2) What reason do you have for believing that this is a problem with *Hibernate* and not with your code or the JDBC driver?
---------------------------------------------------------------------
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: Unassigned
   Priority: Critical

    Project: Hibernate2

   Assignee: 
   Reporter: Hrituc Ovidiu

    Created: Thu, 19 Jun 2003 10:21 AM
    Updated: Thu, 19 Jun 2003 10:21 AM
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/Administrators.jspa

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