[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-362) Save with native ID on DB2 fails with duplicate row exception if data inserted behind hibernate

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

The following comment has been added to this issue:

     Author: Brian Bonner
    Created: Thu, 25 Sep 2003 12:06 PM
       Body:
Forgot to include the log output:


Buildfile: D:\data\eclipseworkspace\TEST\build.xml

runtestcase:
        [java] CA 0       main               INFO  net.sf.hibernate.cfg.Env=
ironment  - Hibernate 2.0.3
        [java] CA 20      main               INFO  net.sf.hibernate.cfg.Env=
ironment  - loaded properties from resource hibernate.properties: {hibernat=
e.connection.username=3Duser, hibernate.connection.password=3Ddemo, hiberna=
te.cglib.use_reflection_optimizer=3Dtrue, hibernate.dialect=3Dnet.sf.hibern=
ate.dialect.DB2Dialect, hibernate.connection.url=3Djdbc:db2:pbbtest, hibern=
ate.connection.driver_class=3DCOM.ibm.db2.jdbc.app.DB2Driver}
        [java] CA 20      main               INFO  net.sf.hibernate.cfg.Env=
ironment  - using CGLIB reflection optimizer
        [java] CA 40      main               INFO  net.sf.hibernate.cfg.Env=
ironment  - JVM proxy support: true
        [java] CA 50      main               INFO  net.sf.hibernate.cfg.Con=
figuration  - Mapping resource: com/paraware/domain/Parent.hbm.xml
        [java] CA 100     main               DEBUG net.sf.hibernate.util.DT=
DEntityResolver  - trying to locate http://hibernate.sourceforge.net/hibern=
ate-mapping-2.0.dtd in classpath under net/sf/hibernate/
        [java] CA 100     main               DEBUG net.sf.hibernate.util.DT=
DEntityResolver  - found http://hibernate.sourceforge.net/hibernate-mapping=
-2.0.dtd in classpath
        [java] CA 241     main               INFO  net.sf.hibernate.cfg.Bin=
der  - Mapping class: com.paraware.domain.Parent -> parents
        [java] CA 331     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: keyId -> key_id, type: integer
        [java] CA 351     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: userID -> LogonID, type: string
        [java] CA 351     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: userName -> Name, type: string
        [java] CA 361     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: password -> password, type: string
        [java] CA 361     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: emailAddress -> emailAddress, type: string
        [java] CA 361     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: lastLogon -> lastLogon, type: timestamp
        [java] CA 391     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: children, type: java.util.Set
        [java] CA 391     main               INFO  net.sf.hibernate.cfg.Con=
figuration  - Mapping resource: com/paraware/domain/Child.hbm.xml
        [java] CA 391     main               DEBUG net.sf.hibernate.util.DT=
DEntityResolver  - trying to locate http://hibernate.sourceforge.net/hibern=
ate-mapping-2.0.dtd in classpath under net/sf/hibernate/
        [java] CA 391     main               DEBUG net.sf.hibernate.util.DT=
DEntityResolver  - found http://hibernate.sourceforge.net/hibernate-mapping=
-2.0.dtd in classpath
        [java] CA 431     main               INFO  net.sf.hibernate.cfg.Bin=
der  - Mapping class: com.paraware.domain.Child -> children
        [java] CA 431     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: mouseId -> mouse_id, type: integer
        [java] CA 431     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: name -> name, type: string
        [java] CA 441     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped property: parent -> key_id, type: com.paraware.domain.Parent
        [java] CA 441     main               INFO  net.sf.hibernate.cfg.Con=
figuration  - processing one-to-many association mappings
        [java] CA 451     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Second pass for collection: com.paraware.domain.Parent.children
        [java] CA 451     main               INFO  net.sf.hibernate.cfg.Bin=
der  - Mapping collection: com.paraware.domain.Parent.children -> children
        [java] CA 471     main               DEBUG net.sf.hibernate.cfg.Bin=
der  - Mapped collection key: key_id, one-to-many: com.paraware.domain.Chil=
d
        [java] CA 471     main               INFO  net.sf.hibernate.cfg.Con=
figuration  - processing foreign key constraints
        [java] CA 471     main               DEBUG net.sf.hibernate.cfg.Con=
figuration  - resolving reference to class: com.paraware.domain.Parent
        [java] CA 841     main               INFO  net.sf.hibernate.impl.Se=
ssionFactoryImpl  - building session factory
        [java] CA 841     main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - instantiating session factory with properties: {java.ru=
ntime.name=3DJava(TM) 2 Runtime Environment, Standard Edition, hibernate.co=
nnection.password=3Ddemo, sun.boot.library.path=3DD:\j2sdk1.4.2\jre\bin, ja=
va.vm.version=3D1.4.2-b28, hibernate.connection.username=3Duser, java.vm.ve=
ndor=3DSun Microsystems Inc., java.vendor.url=3Dhttp://java.sun.com/, path.=
separator=3D;, java.vm.name=3DJava HotSpot(TM) Client VM, file.encoding.pkg=
=3Dsun.io, user.country=3DUS, sun.os.patch.level=3DService Pack 4, java.vm.=
specification.name=3DJava Virtual Machine Specification, user.dir=3DD:\data=
\eclipseworkspace\TEST, java.runtime.version=3D1.4.2-b28, java.awt.graphics=
env=3Dsun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=3DD:\j2sdk1.4.2\=
jre\lib\endorsed, os.arch=3Dx86, java.io.tmpdir=3DC:\DOCUME~1\BBONNE~1.MIC\=
LOCALS~1\Temp\, line.separator=3D
        [java] , java.vm.specification.vendor=3DSun Microsystems Inc., user=
.variant=3D, os.name=3DWindows 2000, sun.java2d.fontpath=3D, java.library.p=
ath=3DD:\j2sdk1.4.2\jre\bin;.;C:\WINNT\system32;C:\WINNT;d:\j2sdk1.4.2\bin;=
c:\winnt\system32;d:\sqllib\bin;"d:\program files\ibm\mqseries\bin";d:\cygw=
in\bin;d:\dev\java\apache-ant-1.5.3-1\bin, java.specification.name=3DJava P=
latform API Specification, java.class.version=3D48.0, java.util.prefs.Prefe=
rencesFactory=3Djava.util.prefs.WindowsPreferencesFactory, os.version=3D5.0=
, user.home=3DC:\Documents and Settings\bbonner.MICKEY, user.timezone=3D, j=
ava.awt.printerjob=3Dsun.awt.windows.WPrinterJob, file.encoding=3DCp1252, j=
ava.specification.version=3D1.4, hibernate.connection.driver_class=3DCOM.ib=
m.db2.jdbc.app.DB2Driver, user.name=3Dbbonner, java.class.path=3DD:\data\ec=
lipseworkspace\TEST\bin;D:\data\eclipseworkspace\TEST\lib\c3p0.jar;D:\data\=
eclipseworkspace\TEST\lib\cglib.jar;D:\data\eclipseworkspace\TEST\lib\commo=
ns-beanutils-1.6.1.jar;D:\data\eclipseworkspace\TEST\lib\commons-collection=
s-2.1.jar;D:\data\eclipseworkspace\TEST\lib\commons-dbcp.jar;D:\data\eclips=
eworkspace\TEST\lib\commons-lang-1.0.1.jar;D:\data\eclipseworkspace\TEST\li=
b\commons-logging-1.0.2.jar;D:\data\eclipseworkspace\TEST\lib\commons-loggi=
ng-api-1.0.2.jar;D:\data\eclipseworkspace\TEST\lib\db2java.jar;D:\data\ecli=
pseworkspace\TEST\lib\dom4j.jar;D:\data\eclipseworkspace\TEST\lib\hibernate=
2.jar;D:\data\eclipseworkspace\TEST\lib\log4j-1.2.8.jar;D:\data\eclipsework=
space\TEST\lib\odmg.jar, java.vm.specification.version=3D1.0, sun.arch.data=
.model=3D32, java.home=3DD:\j2sdk1.4.2\jre, hibernate.connection.url=3Djdbc=
:db2:pbbtest, hibernate.dialect=3Dnet.sf.hibernate.dialect.DB2Dialect, java=
.specification.vendor=3DSun Microsystems Inc., user.language=3Den, awt.tool=
kit=3Dsun.awt.windows.WToolkit, java.vm.info=3Dmixed mode, hibernate.cglib.=
use_reflection_optimizer=3Dtrue, java.version=3D1.4.2, java.ext.dirs=3DD:\j=
2sdk1.4.2\jre\lib\ext, sun.boot.class.path=3DD:\j2sdk1.4.2\jre\lib\rt.jar;D=
:\j2sdk1.4.2\jre\lib\i18n.jar;D:\j2sdk1.4.2\jre\lib\sunrsasign.jar;D:\j2sdk=
1.4.2\jre\lib\jsse.jar;D:\j2sdk1.4.2\jre\lib\jce.jar;D:\j2sdk1.4.2\jre\lib\=
charsets.jar;D:\j2sdk1.4.2\jre\classes, java.vendor=3DSun Microsystems Inc.=
, file.separator=3D\, java.vendor.url.bug=3Dhttp://java.sun.com/cgi-bin/bug=
report.cgi, sun.cpu.endian=3Dlittle, sun.io.unicode.encoding=3DUnicodeLittl=
e, sun.cpu.isalist=3Dpentium i486 i386}
        [java] CA 982     main               INFO  net.sf.hibernate.dialect=
.Dialect  - Using dialect: net.sf.hibernate.dialect.DB2Dialect
        [java] CA 1002    main               INFO  net.sf.hibernate.connect=
ion.DriverManagerConnectionProvider  - Hibernate connection pool size: 20
        [java] CA 1122    main               INFO  net.sf.hibernate.connect=
ion.DriverManagerConnectionProvider  - using driver: COM.ibm.db2.jdbc.app.D=
B2Driver at URL: jdbc:db2:pbbtest
        [java] CA 1122    main               INFO  net.sf.hibernate.connect=
ion.DriverManagerConnectionProvider  - connection properties: {user=3Duser,=
 password=3Ddemo}
        [java] CA 1122    main               INFO  net.sf.hibernate.impl.Se=
ssionFactoryImpl  - Use outer join fetching: true
        [java] CA 1122    main               DEBUG net.sf.hibernate.connect=
ion.DriverManagerConnectionProvider  - total checked-out connections: 0
        [java] CA 1162    main               DEBUG net.sf.hibernate.connect=
ion.DriverManagerConnectionProvider  - opening new JDBC connection
        [java] CA 1192    main               DEBUG net.sf.hibernate.connect=
ion.DriverManagerConnectionProvider  - created connection to: jdbc:db2:pbbt=
est, Isolation Level: 2
        [java] CA 1212    main               DEBUG net.sf.hibernate.connect=
ion.DriverManagerConnectionProvider  - returning connection to pool, pool s=
ize: 1
        [java] CA 1212    main               INFO  net.sf.hibernate.impl.Se=
ssionFactoryImpl  - Use scrollable result sets: true
        [java] CA 1673    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryObjectFactory  - initializing class SessionFactoryObjectFactory
        [java] CA 1673    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryObjectFactory  - registered: 402881b9f7d9b05400f7d9b059230000 (=
unnamed)
        [java] CA 1673    main               INFO  net.sf.hibernate.impl.Se=
ssionFactoryObjectFactory  - no JDNI name configured
        [java] CA 1673    main               INFO  net.sf.hibernate.impl.Se=
ssionFactoryImpl  - Query language substitutions: {}
        [java] CA 1703    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - instantiated session factory
        [java] CA 1743    main               DEBUG net.sf.hibernate.impl.Se=
ssionImpl  - opened session
        [java] CA 1753    main               DEBUG net.sf.hibernate.transac=
tion.JDBCTransaction  - begin
        [java] CA 1753    main               DEBUG net.sf.hibernate.connect=
ion.DriverManagerConnectionProvider  - total checked-out connections: 0
        [java] CA 1753    main               DEBUG net.sf.hibernate.connect=
ion.DriverManagerConnectionProvider  - using pooled JDBC connection, pool s=
ize: 0
        [java] CA 1753    main               DEBUG net.sf.hibernate.impl.Se=
ssionImpl  - saving [com.paraware.domain.Parent#<null>]
        [java] CA 1783    main               DEBUG net.sf.hibernate.engine.=
Cascades  - processing cascades for: com.paraware.domain.Parent
        [java] CA 1783    main               DEBUG net.sf.hibernate.engine.=
Cascades  - done processing cascades for: com.paraware.domain.Parent
        [java] CA 1783    main               DEBUG net.sf.hibernate.persist=
er.EntityPersister  - Inserting entity: com.paraware.domain.Parent (native =
id)
        [java] CA 1783    main               DEBUG net.sf.hibernate.impl.Ba=
tcherImpl  - about to open: 0 open PreparedStatements, 0 open ResultSets
        [java] CA 1803    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - prepared statement get: insert into parents (LogonID, N=
ame, password, emailAddress, lastLogon, key_id) values (?, ?, ?, ?, ?, defa=
ult)
        [java] CA 1803    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - preparing statement
        [java] CA 1803    main               DEBUG net.sf.hibernate.persist=
er.EntityPersister  - Dehydrating entity: com.paraware.domain.Parent#null
        [java] CA 1833    main               DEBUG net.sf.hibernate.type.St=
ringType  - binding 'bnnn' to parameter: 1
        [java] CA 1833    main               DEBUG net.sf.hibernate.type.St=
ringType  - binding 'Vivi' to parameter: 2
        [java] CA 1833    main               DEBUG net.sf.hibernate.type.St=
ringType  - binding 'abcff' to parameter: 3
        [java] CA 1833    main               DEBUG net.sf.hibernate.type.St=
ringType  - binding 'vi...@co...' to parameter: 4
        [java] CA 1923    main               DEBUG net.sf.hibernate.type.Ti=
mestampType  - binding '25 September 2003 12:58:55' to parameter: 5
        [java] CA 1943    main               DEBUG net.sf.hibernate.impl.Ba=
tcherImpl  - done closing: 0 open PreparedStatements, 0 open ResultSets
        [java] CA 1943    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - closing statement
        [java] CA 1943    main               DEBUG net.sf.hibernate.impl.Ba=
tcherImpl  - about to open: 0 open PreparedStatements, 0 open ResultSets
        [java] CA 1943    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - prepared statement get: values IDENTITY_VAL_LOCAL()
        [java] CA 1963    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - preparing statement
        [java] CA 1973    main               DEBUG net.sf.hibernate.persist=
er.EntityPersister  - Natively generated identity: 2
        [java] CA 1973    main               DEBUG net.sf.hibernate.impl.Ba=
tcherImpl  - done closing: 0 open PreparedStatements, 0 open ResultSets
        [java] CA 1973    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - closing statement
        [java] CA 1993    main               DEBUG net.sf.hibernate.engine.=
Cascades  - processing cascades for: com.paraware.domain.Parent
        [java] CA 1993    main               DEBUG net.sf.hibernate.engine.=
Cascades  - done processing cascades for: com.paraware.domain.Parent
        [java] CA 1993    main               DEBUG net.sf.hibernate.transac=
tion.JDBCTransaction  - commit
        [java] CA 1993    main               DEBUG net.sf.hibernate.impl.Se=
ssionImpl  - flushing session
        [java] CA 2013    main               DEBUG net.sf.hibernate.engine.=
Cascades  - processing cascades for: com.paraware.domain.Parent
        [java] CA 2013    main               DEBUG net.sf.hibernate.engine.=
Cascades  - cascading to collection: com.paraware.domain.Parent.children
        [java] CA 2013    main               DEBUG net.sf.hibernate.engine.=
Cascades  - cascading to saveOrUpdate()
        [java] CA 2013    main               DEBUG net.sf.hibernate.engine.=
Cascades  - unsaved-value: 0
        [java] CA 2033    main               DEBUG net.sf.hibernate.impl.Se=
ssionImpl  - saveOrUpdate() unsaved instance with id: 0
        [java] CA 2033    main               DEBUG net.sf.hibernate.impl.Se=
ssionImpl  - saving [com.paraware.domain.Child#<null>]
        [java] CA 2033    main               DEBUG net.sf.hibernate.persist=
er.EntityPersister  - Inserting entity: com.paraware.domain.Child (native i=
d)
        [java] CA 2033    main               DEBUG net.sf.hibernate.impl.Ba=
tcherImpl  - about to open: 0 open PreparedStatements, 0 open ResultSets
        [java] CA 2063    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - prepared statement get: insert into children (name, key=
_id, mouse_id) values (?, ?, default)
        [java] CA 2063    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - preparing statement
        [java] CA 2063    main               DEBUG net.sf.hibernate.persist=
er.EntityPersister  - Dehydrating entity: com.paraware.domain.Child#null
        [java] CA 2063    main               DEBUG net.sf.hibernate.type.St=
ringType  - binding 'Mouse' to parameter: 1
        [java] CA 2083    main               DEBUG net.sf.hibernate.type.In=
tegerType  - binding '2' to parameter: 2
        [java] CA 2093    main               DEBUG net.sf.hibernate.util.JD=
BCExceptionReporter  - SQL Exception
        [java] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL=
0803N  One or more values in the INSERT statement, UPDATE statement, or for=
eign key update caused by a DELETE statement are not valid because the prim=
ary key, unique constraint or unique index identified by "1" constrains tab=
le "USER.CHILDREN" from having duplicate rows for those columns.  SQLSTATE=
=3D23505
        [java]=20
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx=
ception(SQLExceptionGenerator.java:269)
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx=
ception(SQLExceptionGenerator.java:206)
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_retur=
n_code(SQLExceptionGenerator.java:457)
        [java] =09at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2=
PreparedStatement.java:1429)
        [java] =09at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdat=
e(DB2PreparedStatement.java:1021)
        [java] =09at net.sf.hibernate.persister.EntityPersister.insert(Enti=
tyPersister.java:504)
        [java] =09at net.sf.hibernate.persister.EntityPersister.insert(Enti=
tyPersister.java:444)
        [java] =09at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.j=
ava:717)
        [java] =09at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.jav=
a:605)
        [java] =09at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(Session=
Impl.java:1202)
        [java] =09at net.sf.hibernate.engine.Cascades$3.cascade(Cascades.ja=
va:88)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:258)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:298)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:341)
        [java] =09at net.sf.hibernate.impl.SessionImpl.preFlushEntities(Ses=
sionImpl.java:2285)
        [java] =09at net.sf.hibernate.impl.SessionImpl.flushEverything(Sess=
ionImpl.java:2015)
        [java] =09at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.ja=
va:2004)
        [java] =09at net.sf.hibernate.transaction.JDBCTransaction.commit(JD=
BCTransaction.java:57)
        [java] =09at com.paraware.TestHibernate.main(TestHibernate.java:42)
        [java] CA 2193    main               WARN  net.sf.hibernate.util.JD=
BCExceptionReporter  - SQL Error: -803, SQLState: 23505
        [java] CA 2193    main               ERROR net.sf.hibernate.util.JD=
BCExceptionReporter  - [IBM][CLI Driver][DB2/NT] SQL0803N  One or more valu=
es in the INSERT statement, UPDATE statement, or foreign key update caused =
by a DELETE statement are not valid because the primary key, unique constra=
int or unique index identified by "1" constrains table "USER.CHILDREN" from=
 having duplicate rows for those columns.  SQLSTATE=3D23505
        [java]=20
        [java] CA 2213    main               DEBUG net.sf.hibernate.impl.Ba=
tcherImpl  - done closing: 0 open PreparedStatements, 0 open ResultSets
        [java] CA 2213    main               DEBUG net.sf.hibernate.impl.Se=
ssionFactoryImpl  - closing statement
        [java] CA 2223    main               ERROR net.sf.hibernate.util.JD=
BCExceptionReporter  - Could not insert
        [java] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL=
0803N  One or more values in the INSERT statement, UPDATE statement, or for=
eign key update caused by a DELETE statement are not valid because the prim=
ary key, unique constraint or unique index identified by "1" constrains tab=
le "USER.CHILDREN" from having duplicate rows for those columns.  SQLSTATE=
=3D23505
        [java]=20
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx=
ception(SQLExceptionGenerator.java:269)
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx=
ception(SQLExceptionGenerator.java:206)
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_retur=
n_code(SQLExceptionGenerator.java:457)
        [java] =09at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2=
PreparedStatement.java:1429)
        [java] =09at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdat=
e(DB2PreparedStatement.java:1021)
        [java] =09at net.sf.hibernate.persister.EntityPersister.insert(Enti=
tyPersister.java:504)
        [java] =09at net.sf.hibernate.persister.EntityPersister.insert(Enti=
tyPersister.java:444)
        [java] =09at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.j=
ava:717)
        [java] =09at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.jav=
a:605)
        [java] =09at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(Session=
Impl.java:1202)
        [java] =09at net.sf.hibernate.engine.Cascades$3.cascade(Cascades.ja=
va:88)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:258)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:298)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:341)
        [java] =09at net.sf.hibernate.impl.SessionImpl.preFlushEntities(Ses=
sionImpl.java:2285)
        [java] =09at net.sf.hibernate.impl.SessionImpl.flushEverything(Sess=
ionImpl.java:2015)
        [java] =09at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.ja=
va:2004)
        [java] =09at net.sf.hibernate.transaction.JDBCTransaction.commit(JD=
BCTransaction.java:57)
        [java] =09at com.paraware.TestHibernate.main(TestHibernate.java:42)
        [java] CA 2314    main               DEBUG net.sf.hibernate.impl.Se=
ssionImpl  - transaction completion
        [java] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL=
0803N  One or more values in the INSERT statement, UPDATE statement, or for=
eign key update caused by a DELETE statement are not valid because the prim=
ary key, unique constraint or unique index identified by "1" constrains tab=
le "USER.CHILDREN" from having duplicate rows for those columns.  SQLSTATE=
=3D23505
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx=
ception(SQLExceptionGenerator.java:269)
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx=
ception(SQLExceptionGenerator.java:206)
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_retur=
n_code(SQLExceptionGenerator.java:457)
        [java] =09at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2=
PreparedStatement.java:1429)
        [java] =09at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdat=
e(DB2PreparedStatement.java:1021)
        [java] =09at net.sf.hibernate.persister.EntityPersister.insert(Enti=
tyPersister.java:504)
        [java] =09at net.sf.hibernate.persister.EntityPersister.insert(Enti=
tyPersister.java:444)
        [java] =09at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.j=
ava:717)
        [java] =09at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.jav=
a:605)
        [java] =09at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(Session=
Impl.java:1202)
        [java] =09at net.sf.hibernate.engine.Cascades$3.cascade(Cascades.ja=
va:88)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:258)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:298)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:341)
        [java] =09at net.sf.hibernate.impl.SessionImpl.preFlushEntities(Ses=
sionImpl.java:2285)
        [java] =09at net.sf.hibernate.impl.SessionImpl.flushEverything(Sess=
ionImpl.java:2015)
        [java] =09at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.ja=
va:2004)
        [java] =09at net.sf.hibernate.transaction.JDBCTransaction.commit(JD=
BCTransaction.java:57)
        [java] =09at com.paraware.TestHibernate.main(TestHibernate.java:42)
        [java] rethrown as net.sf.hibernate.JDBCException: Could not insert=
: [IBM][CLI Driver][DB2/NT] SQL0803N  One or more values in the INSERT stat=
ement, UPDATE statement, or foreign key update caused by a DELETE statement=
 are not valid because the primary key, unique constraint or unique index i=
dentified by "1" constrains table "USER.CHILDREN" from having duplicate row=
s for those columns.  SQLSTATE=3D23505
        [java] =09at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.j=
ava:720)
        [java] =09at net.sf.hibernate.impl.SessionImpl.save(SessionImpl.jav=
a:605)
        [java] =09at net.sf.hibernate.impl.SessionImpl.saveOrUpdate(Session=
Impl.java:1202)
        [java] =09at net.sf.hibernate.engine.Cascades$3.cascade(Cascades.ja=
va:88)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:258)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:298)
        [java] =09at net.sf.hibernate.engine.Cascades.cascade(Cascades.java=
:341)
        [java] =09at net.sf.hibernate.impl.SessionImpl.preFlushEntities(Ses=
sionImpl.java:2285)
        [java] =09at net.sf.hibernate.impl.SessionImpl.flushEverything(Sess=
ionImpl.java:2015)
        [java] =09at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.ja=
va:2004)
        [java] =09at net.sf.hibernate.transaction.JDBCTransaction.commit(JD=
BCTransaction.java:57)
        [java] =09at com.paraware.TestHibernate.main(TestHibernate.java:42)
        [java] Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][=
DB2/NT] SQL0803N  One or more values in the INSERT statement, UPDATE statem=
ent, or foreign key update caused by a DELETE statement are not valid becau=
se the primary key, unique constraint or unique index identified by "1" con=
strains table "USER.CHILDREN" from having duplicate rows for those columns.=
  SQLSTATE=3D23505
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx=
ception(SQLExceptionGenerator.java:269)
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLEx=
ception(SQLExceptionGenerator.java:206)
        [java] =09at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_retur=
n_code(SQLExceptionGenerator.java:457)
        [java] =09at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2=
PreparedStatement.java:1429)
        [java] =09at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdat=
e(DB2PreparedStatement.java:1021)
        [java] =09at net.sf.hibernate.persister.EntityPersister.insert(Enti=
tyPersister.java:504)
        [java] =09at net.sf.hibernate.persister.EntityPersister.insert(Enti=
tyPersister.java:444)
        [java] =09at net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.j=
ava:717)
        [java] =09... 11 more
        [java] Exception in thread "main"=20
        [java] Java Result: 1
BUILD SUCCESSFUL
Total time: 3 seconds
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?=
key=3DHB-362


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-362
    Summary: Save with native ID on DB2 fails with duplicate row exception =
if data inserted behind hibernate
       Type: Bug

     Status: Unassigned
   Priority: Critical

    Project: Hibernate2
   Versions:
             2.0.3

   Assignee:=20
   Reporter: Brian Bonner

    Created: Thu, 25 Sep 2003 11:53 AM
    Updated: Thu, 25 Sep 2003 11:58 AM
Environment: Win 2K SP4, JDK 1.4.2, Hibernate 2.0.3, DB2 7.2 UDB

Description:
If we restart the database manager (clean state),
then execute the DDL generated by hibernate, and
run the test case:  TestHibernate  records are inserted without problem.  W=
e can rerun the test case numerous times.


If we restart the database manager,
then insert data from a command line (behind hibernate):

insert into parents values(1,'test','test','test','test',current timestamp)=
;
insert into children values (1,'bb','1);
insert into children values (2,'cc','1);

and run the test case, it fails.


hibernate.properties, Mapping, generated DDL, Domain Source, Test Source fo=
llows.

hibernate.connection.driver_class =3D COM.ibm.db2.jdbc.app.DB2Driver
hibernate.dialect =3D net.sf.hibernate.dialect.DB2Dialect
hibernate.connection.url =3D jdbc:db2:sample
hibernate.connection.username =3D xyz
hibernate.connection.password =3D pdq


<?xml version=3D"1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
=09<class name=3D"com.paraware.domain.Parent" table=3D"parents">

=09=09<id name=3D"keyId" type=3D"int" unsaved-value=3D"0">
=09=09=09<column name=3D"key_id" not-null=3D"true"/>
=09=09=09<generator class=3D"native"/>
=09=09</id>
=09=09<property name=3D"userID" column=3D"LogonID" type=3D"string"/>
=09=09<property name=3D"userName" column=3D"Name" type=3D"string"/>
=09=09<property name=3D"password" type=3D"string"/>
=09=09<property name=3D"emailAddress" type=3D"string"/>
=09=09<property name=3D"lastLogon" type=3D"timestamp"/>
=09=09
=09=09<set name=3D"children" table=3D"children" cascade=3D"all" lazy=3D"tru=
e" inverse=3D"true">
=09=09=09<key column=3D"key_id"/>
=09=09=09<one-to-many class=3D"com.paraware.domain.Child"/>
=09=09</set>
=09</class>
</hibernate-mapping>


<?xml version=3D"1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
=09<class name=3D"com.paraware.domain.Child" table=3D"children">
=09=09
=09=09<id name=3D"mouseId" type=3D"int" unsaved-value=3D"0">
=09=09=09<column name=3D"mouse_id" not-null=3D"true"/>
=09=09=09<generator class=3D"native"/>
=09=09</id>
=09=09
=09=09<property name=3D"name" column=3D"name" type=3D"string"/>
=09=09
=09=09<many-to-one name=3D"parent" class=3D"com.paraware.domain.Parent" col=
umn=3D"key_id" />
=09=09
=09</class>
</hibernate-mapping>


drop table parents;
drop table children;
create table parents (
   key_id INTEGER not null generated by default as identity,
   LogonID VARCHAR(255),
   Name VARCHAR(255),
   password VARCHAR(255),
   emailAddress VARCHAR(255),
   lastLogon TIMESTAMP,
   primary key (key_id)
);
create table children (
   mouse_id INTEGER not null generated by default as identity,
   name VARCHAR(255),
   key_id INTEGER,
   primary key (mouse_id)
);
alter table children add constraint FK62EA5DFFBC5E42FB foreign key (key_id)=
 references parents;



package com.paraware.domain;
import java.util.Date;
import java.util.Set;
// ...
public class Parent {
  private int keyId;
  private String userID;
  private String userName;
  private String password;
  private String emailAddress;
  private Date lastLogon;
  private Set children;
  public int getKeyId() {
    return keyId;
  }
  public void setKeyId(int keyId) {
    this.keyId =3D keyId;
  }
  public String getUserID() {
    return userID;
  }
  public void setUserID(String newUserID) {
    userID =3D newUserID;
  }
  public String getUserName() {
    return userName;
  }
  public void setUserName(String newUserName) {
    userName =3D newUserName;
  }
  public String getPassword() {
    return password;
  }
  public void setPassword(String newPassword) {
    password =3D newPassword;
  }
  public String getEmailAddress() {
    return emailAddress;
  }
  public void setEmailAddress(String newEmailAddress) {
    emailAddress =3D newEmailAddress;
  }
  public Date getLastLogon() {
    return lastLogon;
  }
  public void setLastLogon(Date newLastLogon) {
    lastLogon =3D newLastLogon;
  }
  public Set getChildren() {
    return children;
  }
  public void setChildren(Set mouses) {
    this.children =3D mouses;
  }
  /* (non-Javadoc)
   * @see java.lang.Object#equals(java.lang.Object)
   */
  public boolean equals(Object obj) {
    if (this =3D=3D obj)
      return true;
    if ((obj =3D=3D null) || (obj.getClass() !=3D this.getClass()))
      return false;
    // Must be the Parent
    Parent other =3D (Parent) obj;
    return userID =3D=3D other.userID
      || userID !=3D null
      && userID.equals(other.userID)
      && userName =3D=3D other.userName
      || userName !=3D null
      && userName.equals(other.userName);
  }
  /* (non-Javadoc)
   * @see java.lang.Object#hashCode()
   */
  public int hashCode() {
    int result =3D 17;
    result =3D userID =3D=3D null ? result : 37 * result + userID.hashCode(=
);
    result =3D userName =3D=3D null ? result : 37 * result + userName.hashC=
ode();
    return result;
  }
}



package com.paraware.domain;
public class Child {
  private int mouseId;
  private String name;
  private Parent parent;
  public int getMouseId() {
    return mouseId;
  }
  public void setMouseId(int id) {
    this.mouseId =3D id;
  }
  public String getName() {
    return name;
  }
  public void setName(String newName) {
    name =3D newName;
  }
  public Parent getParent() {
    return parent;
  }
  public void setParent(Parent newUser) {
    parent =3D newUser;
  }
  /* (non-Javadoc)
   * @see java.lang.Object#equals(java.lang.Object)
   */
  public boolean equals(Object obj) {
    if (this =3D=3D obj)
      return true;
    if ((obj =3D=3D null) || (obj.getClass() !=3D this.getClass()))
      return false;
    // Must be the Child
    Child other =3D (Child) obj;
    return name =3D=3D other.name || name !=3D null && name.equals(other.na=
me);
  }
  /* (non-Javadoc)
   * @see java.lang.Object#hashCode()
   */
  public int hashCode() {
    int result =3D 17;
    result =3D name =3D=3D null ? result : 37 * result + name.hashCode();
    return result;
  }
}


package com.paraware;
import java.sql.SQLException;
import java.util.Date;
import java.util.HashSet;
import java.util.Set;
import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.cfg.Configuration;
import com.paraware.domain.Child;
import com.paraware.domain.Parent;
public class TestHibernate {
  public static void main(String args[]) throws HibernateException, SQLExce=
ption {
    SessionFactory sessionFactory;
    Transaction transaction;
    Configuration cfg =3D new Configuration();
    cfg.addClass(Parent.class);
    cfg.addClass(Child.class);
    sessionFactory =3D cfg.buildSessionFactory();
    Session session =3D sessionFactory.openSession();
    transaction =3D session.beginTransaction();
    Parent newUser =3D new Parent();
    newUser.setUserID("bnnn");
    newUser.setUserName("Vivi");
    newUser.setPassword("abcff");
    newUser.setEmailAddress("vi...@co...");
    newUser.setLastLogon(new Date());
    session.save(newUser);
    Child ms1 =3D new Child();
    ms1.setName("Mickey");
    Child ms2 =3D new Child();
    ms2.setName("Mouse");
    Set mouseSet =3D new HashSet();
    mouseSet.add(ms1);
    mouseSet.add(ms2);
    //set up association
    newUser.setChildren(mouseSet);
    //save foreign keys
    ms1.setParent(newUser);
    ms2.setParent(newUser);
    transaction.commit();
    // close our session and release resources
    session.flush();
    session.close();
  }
}


---------------------------------------------------------------------
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