Hibernate Community • View topic - Custom SQL for CUD ignored

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Custom SQL for CUD ignored

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

ernst_pluess

Post subject: Custom SQL for CUD ignored

Posted: Wed Sep 22, 2004 4:12 pm

Expert

Joined: Thu Jan 29, 2004 2:31 am
Posts: 362
Location: Switzerland, Bern

Hi

I've a simple parent child layout where class A has many B's, which works fine.
No I want to write my own CUD SQLs for B, but from the logs you can see, that they are ignored. Even putting just to see that this is ignored for the sql insert doesn't cause any exceptions.

Did I miss something?
TIA
Ernst

Hibernate version:
3.0 alpha

Mapping documents:

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
   <class name="li.pluess.hibernate.A">
      <id name="id" access="field" unsaved-value="0">
         <generator class="identity"></generator>
      </id>
      <set name="b" cascade="all" inverse="true">
         <key column="a_id"></key>
         <one-to-many class="li.pluess.hibernate.B"/>
      </set>
   </class>
</hibernate-mapping>

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
   <class name="li.pluess.hibernate.B">
      <id name="id" access="field" unsaved-value="0">
         <generator class="identity"></generator>
      </id>
       <many-to-one name="a" column="a_id" not-null="true"/>
       <sql-insert>just to see that this is ignored</sql-insert>
       <!-- <sql-insert>INSERT into B (a_id) values (?) /* my sql */</sql-insert> -->
       <sql-update>UPDATE b set a_id=? where id=?; /* my sql */</sql-update>
       <sql-delete>DELETE from B where id=? /* my sql */</sql-delete>
   </class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

Code:

      Session s = HibernateUtil.getSession();
      HibernateUtil.beginTransaction();
      
      A a = new A();
      B b = new B();
      a.getB().add(b);
      b.setA(a);
      
      s.save(a);
      
      HibernateUtil.commitTransaction();
      HibernateUtil.closeSession();

Full stack trace of any exception that occurs:
no exceptions are thrown

Name and version of the database you are using:
Mysql 3.24

The generated SQL (show_sql=true):
Hibernate: insert into A values ( )
Hibernate: insert into B (a_id) values (?)

Debug level Hibernate log excerpt:
22:09:46,665 INFO Environment:411 - Hibernate 3.0 alpha
22:09:46,675 INFO Environment:424 - hibernate.properties not found
22:09:46,685 INFO Environment:457 - using CGLIB reflection optimizer
22:09:46,695 INFO Environment:486 - using JDK 1.4 java.sql.Timestamp handling
22:09:46,985 INFO Configuration:1019 - configuring from resource: /hibernate.cfg.xml
22:09:46,985 INFO Configuration:990 - Configuration resource: /hibernate.cfg.xml
22:09:47,947 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath under org/hibernate/
22:09:47,957 DEBUG DTDEntityResolver:50 - found http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath
22:09:48,107 DEBUG Configuration:976 - show_sql=true
22:09:48,107 DEBUG Configuration:976 - dialect=org.hibernate.dialect.MySQLDialect
22:09:48,107 DEBUG Configuration:976 - hibernate.connection.driver_class=com.mysql.jdbc.Driver
22:09:48,117 DEBUG Configuration:976 - hibernate.connection.url=jdbc:mysql://localhost/sql_handmade
22:09:48,137 DEBUG Configuration:1136 - null<-org.dom4j.tree.DefaultAttribute@148bd3 [Attribute: name resource value "li/pluess/hibernate/A.hbm.xml"]
22:09:48,137 INFO Configuration:416 - Mapping resource: li/pluess/hibernate/A.hbm.xml
22:09:48,207 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
22:09:48,217 DEBUG DTDEntityResolver:50 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
22:09:48,538 INFO Binder:413 - Mapping class: li.pluess.hibernate.A -> A
22:09:48,598 DEBUG Binder:803 - Mapped property: id -> id
22:09:48,668 DEBUG Binder:803 - Mapped property: b
22:09:48,678 DEBUG Configuration:1136 - null<-org.dom4j.tree.DefaultAttribute@123b25c [Attribute: name resource value "li/pluess/hibernate/B.hbm.xml"]
22:09:48,678 INFO Configuration:416 - Mapping resource: li/pluess/hibernate/B.hbm.xml
22:09:48,688 DEBUG DTDEntityResolver:42 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
22:09:48,688 DEBUG DTDEntityResolver:50 - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
22:09:48,798 INFO Binder:413 - Mapping class: li.pluess.hibernate.B -> B
22:09:48,808 DEBUG Binder:803 - Mapped property: id -> id
22:09:48,998 DEBUG Binder:803 - Mapped property: a -> a_id
22:09:48,998 INFO Configuration:1166 - Configured SessionFactory: null
22:09:48,998 DEBUG Configuration:1167 - properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\j2sdk1.4.2_04\jre\bin, java.vm.version=1.4.2_04-b05, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=DE, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade, java.runtime.version=1.4.2_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\j2sdk1.4.2_04\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOKUME~1\Ernst\LOKALE~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, sun.java2d.fontpath=, java.library.path=C:\j2sdk1.4.2_04\bin;.;C:\WINNT\system32;C:\WINNT;C:\j2sdk1.4.2_04\bin;C:\Programme\Tcl\bin;C:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Programme\Microsoft SQL Server\80\Tools\Binn\;C:\Programme\ActiveState Komodo 2.5\;C:\Programme\vim\vim61;C:\Programme\jakarta-ant-1.5.1\bin;C:\Programme\mysql\bin;C:\Programme\Microsoft.NET\SDK\v1.1\Bin;C:\Programme\SSH Communications Security\SSH Secure Shell;C:\Programme\PHP;C:\Programme\Apache Software Foundation\Maven 1.0-rc2\bin;C:\Programme\castor-0.9.5.3, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.0, user.home=C:\Dokumente und Einstellungen\Ernst, user.timezone=Europe/Berlin, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=com.mysql.jdbc.Driver, show_sql=true, user.name=Ernst, java.class.path=/c:/Programme/eclipse301/plugins/org.eclipse.jdt.junit_3.0.1/junitsupport.jar;/c:/Programme/eclipse301/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\config;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\bin;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-antlr-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-junit-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-launcher-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-swing-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\antlr-2.7.4.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\c3p0-0.8.4.5.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\cglib-full-2.0.2.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\cleanimports.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\commons-collections-2.1.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\commons-logging-1.0.4.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\concurrent-1.3.2.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\connector.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\dom4j-1.4.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ehcache-0.9.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\hibernate3.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jaas.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jboss-cache.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jboss-common.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jboss-jmx.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jboss-system.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jdbc2_0-stdext.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jgroups-2.2.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jta.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\junit-3.8.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\log4j-1.2.8.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\oscache-2.0.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\proxool-0.8.3.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\swarmcache-1.0rc2.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\xalan-2.4.0.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\xerces-2.4.0.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\xml-apis.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\mysql-connector-java-3.0.15-ga-bin.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\j2sdk1.4.2_04\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:mysql://localhost/sql_handmade, hibernate.dialect=org.hibernate.dialect.MySQLDialect, user.language=de, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.4.2_04, java.ext.dirs=C:\j2sdk1.4.2_04\jre\lib\ext, sun.boot.class.path=C:\j2sdk1.4.2_04\jre\lib\rt.jar;C:\j2sdk1.4.2_04\jre\lib\i18n.jar;C:\j2sdk1.4.2_04\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2_04\jre\lib\jsse.jar;C:\j2sdk1.4.2_04\jre\lib\jce.jar;C:\j2sdk1.4.2_04\jre\lib\charsets.jar;C:\j2sdk1.4.2_04\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, dialect=org.hibernate.dialect.MySQLDialect, sun.cpu.isalist=pentium i486 i386}
22:09:49,008 DEBUG Configuration:907 - Preparing to build session factory with filters : {}
22:09:49,018 INFO Configuration:735 - processing one-to-many association mappings
22:09:49,018 DEBUG Binder:1795 - Second pass for collection: li.pluess.hibernate.A.b
22:09:49,018 INFO Binder:1463 - Mapping collection: li.pluess.hibernate.A.b -> B
22:09:49,028 DEBUG Binder:1809 - Mapped collection key: a_id, one-to-many: li.pluess.hibernate.B
22:09:49,028 INFO Configuration:744 - processing one-to-one association property references
22:09:49,028 INFO Configuration:769 - processing foreign key constraints
22:09:49,028 DEBUG Configuration:787 - resolving reference to class: li.pluess.hibernate.A
22:09:49,129 INFO Dialect:86 - Using dialect: org.hibernate.dialect.MySQLDialect
22:09:49,139 INFO SettingsFactory:77 - Generate SQL with comments: disabled
22:09:49,149 INFO SettingsFactory:81 - Query language substitutions: {}
22:09:49,159 INFO DriverManagerConnectionProvider:43 - Using Hibernate built-in connection pool (not for production use!)
22:09:49,169 INFO DriverManagerConnectionProvider:44 - Hibernate connection pool size: 20
22:09:49,169 INFO DriverManagerConnectionProvider:47 - autocommit mode: false
22:09:49,199 INFO DriverManagerConnectionProvider:82 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/sql_handmade
22:09:49,219 INFO DriverManagerConnectionProvider:85 - connection properties: {}
22:09:49,219 DEBUG DriverManagerConnectionProvider:95 - total checked-out connections: 0
22:09:49,229 DEBUG DriverManagerConnectionProvider:111 - opening new JDBC connection
22:09:49,659 DEBUG DriverManagerConnectionProvider:117 - created connection to: jdbc:mysql://localhost/sql_handmade, Isolation Level: 2
22:09:49,669 DEBUG DriverManagerConnectionProvider:131 - returning connection to pool, pool size: 1
22:09:49,679 INFO SettingsFactory:130 - Scrollable result sets: enabled
22:09:49,679 INFO SettingsFactory:134 - JDBC3 getGeneratedKeys(): enabled
22:09:49,689 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
22:09:49,709 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
22:09:49,709 INFO SettingsFactory:210 - Cache provider: org.hibernate.cache.EhCacheProvider
22:09:49,729 INFO SettingsFactory:151 - Second-level cache: enabled
22:09:49,729 INFO SettingsFactory:153 - Optimize cache for minimal puts: disabled
22:09:49,739 INFO SettingsFactory:161 - Query cache: disabled
22:09:49,739 INFO SettingsFactory:168 - Echoing all SQL to stdout
22:09:49,739 INFO SettingsFactory:172 - Statistics: disabled
22:09:49,739 INFO SettingsFactory:176 - Deleted entity synthetic identifier rollback: disabled
22:09:50,060 INFO SessionFactoryImpl:133 - building session factory
22:09:50,060 DEBUG SessionFactoryImpl:142 - Session factory constructed with filter configurations : {}
22:09:50,060 DEBUG SessionFactoryImpl:145 - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\j2sdk1.4.2_04\jre\bin, java.vm.version=1.4.2_04-b05, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=DE, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade, java.runtime.version=1.4.2_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\j2sdk1.4.2_04\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOKUME~1\Ernst\LOKALE~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, sun.java2d.fontpath=, java.library.path=C:\j2sdk1.4.2_04\bin;.;C:\WINNT\system32;C:\WINNT;C:\j2sdk1.4.2_04\bin;C:\Programme\Tcl\bin;C:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Programme\Microsoft SQL Server\80\Tools\Binn\;C:\Programme\ActiveState Komodo 2.5\;C:\Programme\vim\vim61;C:\Programme\jakarta-ant-1.5.1\bin;C:\Programme\mysql\bin;C:\Programme\Microsoft.NET\SDK\v1.1\Bin;C:\Programme\SSH Communications Security\SSH Secure Shell;C:\Programme\PHP;C:\Programme\Apache Software Foundation\Maven 1.0-rc2\bin;C:\Programme\castor-0.9.5.3, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.0, user.home=C:\Dokumente und Einstellungen\Ernst, user.timezone=Europe/Berlin, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=com.mysql.jdbc.Driver, show_sql=true, user.name=Ernst, java.class.path=/c:/Programme/eclipse301/plugins/org.eclipse.jdt.junit_3.0.1/junitsupport.jar;/c:/Programme/eclipse301/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\config;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\bin;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-antlr-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-junit-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-launcher-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ant-swing-1.6.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\antlr-2.7.4.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\c3p0-0.8.4.5.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\cglib-full-2.0.2.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\cleanimports.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\commons-collections-2.1.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\commons-logging-1.0.4.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\concurrent-1.3.2.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\connector.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\dom4j-1.4.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\ehcache-0.9.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\hibernate3.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jaas.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jboss-cache.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jboss-common.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jboss-jmx.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jboss-system.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jdbc2_0-stdext.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jgroups-2.2.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\jta.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\junit-3.8.1.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\log4j-1.2.8.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\oscache-2.0.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\proxool-0.8.3.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\swarmcache-1.0rc2.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\xalan-2.4.0.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\xerces-2.4.0.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\xml-apis.jar;C:\Dokumente und Einstellungen\Ernst\Eigene Dateien\Source\Java\sql_handmade\lib\mysql-connector-java-3.0.15-ga-bin.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\j2sdk1.4.2_04\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:mysql://localhost/sql_handmade, hibernate.dialect=org.hibernate.dialect.MySQLDialect, user.language=de, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.4.2_04, java.ext.dirs=C:\j2sdk1.4.2_04\jre\lib\ext, sun.boot.class.path=C:\j2sdk1.4.2_04\jre\lib\rt.jar;C:\j2sdk1.4.2_04\jre\lib\i18n.jar;C:\j2sdk1.4.2_04\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2_04\jre\lib\jsse.jar;C:\j2sdk1.4.2_04\jre\lib\jce.jar;C:\j2sdk1.4.2_04\jre\lib\charsets.jar;C:\j2sdk1.4.2_04\jre\classes, java.vendor=Sun Microsystems Inc., hibernate.jdbc.batch_size=15, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, hibernate.max_fetch_depth=2, dialect=org.hibernate.dialect.MySQLDialect, sun.cpu.isalist=pentium i486 i386}
22:09:50,571 DEBUG AbstractCollectionPersister:409 - Static SQL for collection: li.pluess.hibernate.A.b
22:09:50,571 DEBUG AbstractCollectionPersister:410 - Row insert: update B set a_id=? where id=?
22:09:50,571 DEBUG AbstractCollectionPersister:412 - Row delete: update B set a_id=null where a_id=? and id=?
22:09:50,571 DEBUG AbstractCollectionPersister:413 - One-shot delete: update B set a_id=null where a_id=?
22:09:50,621 DEBUG BasicEntityPersister:1893 - Static SQL for entity: li.pluess.hibernate.A
22:09:50,621 DEBUG BasicEntityPersister:1895 - Version select: select id from A where id =?
22:09:50,621 DEBUG BasicEntityPersister:1896 - Snapshot select: select a.id from A a where a.id=?
22:09:50,641 DEBUG BasicEntityPersister:1898 - Insert 0: insert into A (id) values (?)
22:09:50,651 DEBUG BasicEntityPersister:1899 - Update 0: update A set where id=?
22:09:50,651 DEBUG BasicEntityPersister:1900 - Delete 0: delete from A where id=?
22:09:50,651 DEBUG BasicEntityPersister:1903 - Identity insert: insert into A values ( )
22:09:50,741 DEBUG EntityLoader:59 - Static select for entity li.pluess.hibernate.A: select a0_.id as id0_ from A a0_ where a0_.id=?
22:09:50,741 DEBUG BasicEntityPersister:1893 - Static SQL for entity: li.pluess.hibernate.B
22:09:50,751 DEBUG BasicEntityPersister:1895 - Version select: select id from B where id =?
22:09:50,751 DEBUG BasicEntityPersister:1896 - Snapshot select: select b.id, b.a_id as a_id1_ from B b where b.id=?
22:09:50,751 DEBUG BasicEntityPersister:1898 - Insert 0: just to see that this is ignored
22:09:50,751 DEBUG BasicEntityPersister:1899 - Update 0: UPDATE b set a_id=? where id=?; /* my sql */
22:09:50,751 DEBUG BasicEntityPersister:1900 - Delete 0: DELETE from B where id=? /* my sql */
22:09:50,761 DEBUG BasicEntityPersister:1903 - Identity insert: insert into B (a_id) values (?)
22:09:50,771 DEBUG EntityLoader:59 - Static select for entity li.pluess.hibernate.B: select b0_.id as id1_, b0_.a_id as a_id1_1_, a1_.id as id0_ from B b0_ left outer join A a1_ on b0_.a_id=a1_.id where b0_.id=?
22:09:50,781 DEBUG OneToManyLoader:77 - Static select for one-to-many li.pluess.hibernate.A.b: select b0_.a_id as a_id__, b0_.id as id__, b0_.id as id0_, b0_.a_id as a_id1_0_ from B b0_ where b0_.a_id=?
22:09:50,821 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
22:09:50,831 DEBUG SessionFactoryObjectFactory:76 - registered: 40288182ff27c39500ff27c399bd0000 (unnamed)
22:09:50,841 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
22:09:50,841 DEBUG SessionFactoryImpl:218 - instantiated session factory
22:09:50,841 INFO SessionFactoryImpl:336 - Checking 0 named queries
Opening new Session for this thread.
22:09:50,941 DEBUG SessionImpl:323 - opened session
Starting new database transaction in this thread.
22:09:50,941 DEBUG JDBCTransaction:37 - begin
22:09:50,951 DEBUG DriverManagerConnectionProvider:95 - total checked-out connections: 0
22:09:50,951 DEBUG DriverManagerConnectionProvider:101 - using pooled JDBC connection, pool size: 0
22:09:50,951 DEBUG JDBCTransaction:41 - current autocommit status:false
22:09:50,971 DEBUG AbstractSaveEventListener:131 - saving [li.pluess.hibernate.A#<null>]
22:09:50,971 DEBUG AbstractSaveEventListener:191 - executing insertions
22:09:50,981 DEBUG Cascades:600 - processing cascades for: li.pluess.hibernate.A
22:09:50,981 DEBUG Cascades:612 - done processing cascades for: li.pluess.hibernate.A
22:09:51,041 DEBUG WrapVisitor:82 - Wrapped collection in role: li.pluess.hibernate.A.b
22:09:51,051 DEBUG BasicEntityPersister:1497 - Inserting entity: li.pluess.hibernate.A (native id)
22:09:51,051 DEBUG AbstractBatcher:218 - about to open: 0 open PreparedStatements, 0 open ResultSets
22:09:51,061 DEBUG SQL:244 - insert into A values ( )
Hibernate: insert into A values ( )
22:09:51,061 DEBUG AbstractBatcher:301 - preparing statement
22:09:51,091 DEBUG BasicEntityPersister:1386 - Dehydrating entity: [li.pluess.hibernate.A#<null>]
22:09:51,101 DEBUG BasicEntityPersister:1922 - Natively generated identity: 26
22:09:51,111 DEBUG AbstractBatcher:225 - done closing: 0 open PreparedStatements, 0 open ResultSets
22:09:51,111 DEBUG AbstractBatcher:321 - closing statement
22:09:51,121 DEBUG Cascades:600 - processing cascades for: li.pluess.hibernate.A
22:09:51,121 DEBUG Cascades:631 - cascading to collection: li.pluess.hibernate.A.b
22:09:51,141 DEBUG Cascades:127 - cascading to saveOrUpdate()
22:09:51,151 DEBUG Cascades:345 - id unsaved-value: 0
22:09:51,151 DEBUG SessionImpl:751 - saveOrUpdate() unsaved instance
22:09:51,161 DEBUG AbstractSaveEventListener:131 - saving [li.pluess.hibernate.B#<null>]
22:09:51,161 DEBUG AbstractSaveEventListener:191 - executing insertions
22:09:51,161 DEBUG BasicEntityPersister:1497 - Inserting entity: li.pluess.hibernate.B (native id)
22:09:51,161 DEBUG AbstractBatcher:218 - about to open: 0 open PreparedStatements, 0 open ResultSets
22:09:51,171 DEBUG SQL:244 - insert into B (a_id) values (?)
Hibernate: insert into B (a_id) values (?)
22:09:51,171 DEBUG AbstractBatcher:301 - preparing statement
22:09:51,171 DEBUG BasicEntityPersister:1386 - Dehydrating entity: [li.pluess.hibernate.B#<null>]
22:09:51,181 DEBUG BasicEntityPersister:1922 - Natively generated identity: 12
22:09:51,181 DEBUG AbstractBatcher:225 - done closing: 0 open PreparedStatements, 0 open ResultSets
22:09:51,191 DEBUG AbstractBatcher:321 - closing statement
22:09:51,191 DEBUG Cascades:612 - done processing cascades for: li.pluess.hibernate.A
Committing database transaction of this thread.
22:09:51,191 DEBUG JDBCTransaction:59 - commit
22:09:51,202 DEBUG AbstractFlushingEventListener:59 - flushing session
22:09:51,202 DEBUG Cascades:600 - processing cascades for: li.pluess.hibernate.A
22:09:51,212 DEBUG Cascades:631 - cascading to collection: li.pluess.hibernate.A.b
22:09:51,212 DEBUG Cascades:127 - cascading to saveOrUpdate()
22:09:51,212 DEBUG SessionImpl:731 - saveOrUpdate() persistent instance
22:09:51,222 DEBUG Cascades:612 - done processing cascades for: li.pluess.hibernate.A
22:09:51,222 DEBUG AbstractFlushingEventListener:159 - Flushing entities and processing referenced collections
22:09:51,232 DEBUG AbstractFlushingEventListener:602 - Collection found: [li.pluess.hibernate.A.b#26], was: [<unreferenced>]
22:09:51,232 DEBUG AbstractFlushingEventListener:442 - Processing unreferenced collections
22:09:51,232 DEBUG AbstractFlushingEventListener:456 - Scheduling collection removes/(re)creates/updates
22:09:51,272 DEBUG AbstractFlushingEventListener:83 - Flushed: 0 insertions, 0 updates, 0 deletions to 2 objects
22:09:51,272 DEBUG AbstractFlushingEventListener:89 - Flushed: 1 (re)creations, 0 updates, 0 removals to 1 collections
22:09:51,282 DEBUG Printer:78 - listing entities:
22:09:51,292 DEBUG Printer:85 - li.pluess.hibernate.B{a=A#26, id=12}
22:09:51,292 DEBUG Printer:85 - li.pluess.hibernate.A{b=[B#12], id=26}
22:09:51,292 DEBUG AbstractFlushingEventListener:504 - executing flush
22:09:51,302 DEBUG AbstractFlushingEventListener:549 - post flush
22:09:51,312 DEBUG SessionImpl:356 - transaction completion
Closing Session of this thread.
22:09:51,312 DEBUG SessionImpl:341 - closing session
22:09:51,312 DEBUG SessionImpl:1664 - disconnecting session
22:09:51,322 DEBUG DriverManagerConnectionProvider:131 - returning connection to pool, pool size: 1
22:09:51,322 DEBUG SessionImpl:356 - transaction completion

Top

gavin

Post subject:

Posted: Wed Sep 22, 2004 8:37 pm

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

Fixed in CVS. (Affected classes with "identity" ids.)

Top

ernst_pluess

Post subject:

Posted: Thu Sep 23, 2004 4:38 am

Expert

Joined: Thu Jan 29, 2004 2:31 am
Posts: 362
Location: Switzerland, Bern

Thanks for the answer gavin.

I tried to get the sources from CVS, since I'm behind a firewall I have to use CVSGrab. Unfortunately this failes repetatly.

Is there an other way of getting the latest sources? I missed a nightly snapshot of h3 as source or binary.

TIA
Ernst

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum