-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 
  Previous topic | Next topic 
Author Message
wk5657
 Post subject: Unexpected results
PostPosted: Mon Aug 16, 2004 3:50 pm 
Newbie

Joined: Sun Aug 01, 2004 8:23 pm
Posts: 11
I am using hilo generator. After the first insert into the table, I have a ID of 1, After the second insert, I have a ID of 32769. The hibernate_unique_key table has (as I did expect) has 2 as the next_hi column value. Am I wrong to expect the table to have 2 as the id column? If not what is wrong with my definitions (is there something odd, for example, about using MySQL with an int column definition for both the table and the unique key next_hi column) Thanks in advance. I have tried to use the conventions for posting.


Wayne




Hibernate version:2.14

Mapping documents:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<hibernate-configuration>


<session-factory>
<!-- properties -->
<property name="connection.username">wk5657</property>
<property name="connection.url">jdbc:mysql://localhost:3306/ers</property>
<property name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
<property name="connection.password">scotter1</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>

<!-- mapping files -->
<mapping resource="Permission.hbm.xml" ></mapping>

</session-factory>

</hibernate-configuration>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="edu.ucop.ers.access.Permission" table="permission">
<id name="permissionId" column="permission_id" type="java.lang.Integer">
<generator class="hilo" />
</id>
<property name="permissionName" column="permission_name" type="string" length="100" not-null="true"/>
<property name="permissionCode" column="permission_code" type="string" length="100" not-null="true"/>
</class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():
public void save(PersistentObjectIntf persistent, Session session) {
try {
if (init==false)initialize();
session.save(persistent);
session.flush();
} catch (HibernateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

// TODO Auto-generated method stub

}

Full stack trace of any exception that occurs:

Name and version of the database you are using:
MySQL v4.1.3b-Beta-nt
Debug level Hibernate log excerpt:

AFTER first Complete execution:

11:35:48,362 INFO Environment:462 - Hibernate 2.1.3
11:35:48,362 INFO Environment:491 - hibernate.properties not found
11:35:48,377 INFO Environment:519 - using CGLIB reflection optimizer
11:35:48,393 INFO Configuration:872 - configuring from resource: /hibernate.cfg.xml
11:35:48,393 INFO Configuration:844 - Configuration resource: /hibernate.cfg.xml
11:35:48,831 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... on-2.0.dtd in classpath under net/sf/hibernate/
11:35:48,831 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... on-2.0.dtd in classpath
11:35:48,893 DEBUG Configuration:830 - connection.username=wk5657
11:35:48,893 DEBUG Configuration:830 - connection.url=jdbc:mysql://localhost:3306/ers
11:35:48,893 DEBUG Configuration:830 - dialect=net.sf.hibernate.dialect.MySQLDialect
11:35:48,893 DEBUG Configuration:830 - connection.password=scotter1
11:35:48,909 DEBUG Configuration:830 - connection.driver_class=com.mysql.jdbc.Driver
11:35:48,909 DEBUG Configuration:989 - null<-org.dom4j.tree.DefaultAttribute@baa466 [Attribute: name resource value "Permission.hbm.xml"]
11:35:48,909 INFO Configuration:328 - Mapping resource: Permission.hbm.xml
11:35:48,940 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
11:35:48,940 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
11:35:49,065 INFO Binder:229 - Mapping class: edu.ucop.ers.access.Permission -> permission
11:35:49,159 DEBUG Binder:475 - Mapped property: permissionId -> permission_id, type: integer
11:35:49,174 DEBUG Binder:475 - Mapped property: permissionName -> permission_name, type: string
11:35:49,174 DEBUG Binder:475 - Mapped property: permissionCode -> permission_code, type: string
11:35:49,174 INFO Configuration:1030 - Configured SessionFactory: null
11:35:49,190 DEBUG Configuration:1031 - properties: {hibernate.connection.password=scotter1, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_03\bin, java.vm.version=1.4.2_03-b02, hibernate.connection.username=wk5657, 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=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\eclipse\workspace\ERSStart, java.runtime.version=1.4.2_03-b02, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\wkidd\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=C:\Program Files\Java\j2re1.4.2_03\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\Program Files\Rational\common, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, connection.password=scotter1, user.home=C:\Documents and Settings\wkidd, user.timezone=GMT-08:00, connection.username=wk5657, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=com.mysql.jdbc.Driver, user.name=wkidd, java.class.path=/c:/eclipse/plugins/org.eclipse.jdt.junit_3.0.0/junitsupport.jar;/c:/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\classes;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-beanutils.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-collections.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-digester.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-fileupload.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-lang.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-logging.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-validator.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jakarta-oro.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\struts-legacy.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\struts.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\mysql-connector-java-3.0.14-production-bin.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ant-1.5.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ant-optional-1.5.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\c3p0-0.8.4.5.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\cglib-full-2.0.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-collections-2.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-dbcp-1.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-lang-1.0.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-logging-1.0.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-pool-1.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\concurrent-1.3.2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\connector.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\dom4j-1.4.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ehcache-0.7.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\hibernate2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jaas.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-cache.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-common.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-jmx.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-system.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jcs-1.0-dev.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jgroups-2.2.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jta.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\junit-3.8.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\log4j-1.2.8.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\odmg-3.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\oscache-2.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\proxool-0.8.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xalan-2.4.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xerces-2.4.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xml-apis.jar, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_03, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.connection.url=jdbc:mysql://localhost:3306/ers, user.language=en, 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_03, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_03\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_03\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_03\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_03\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_03\classes;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\activation.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\javax.servlet.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jboss-j2ee.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jboss-jaas.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jsse.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jts.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\mail.jar, java.vendor=Sun Microsystems Inc., connection.driver_class=com.mysql.jdbc.Driver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, connection.url=jdbc:mysql://localhost:3306/ers, dialect=net.sf.hibernate.dialect.MySQLDialect, sun.cpu.isalist=pentium i486 i386}
11:35:49,221 INFO Configuration:613 - processing one-to-many association mappings
11:35:49,237 INFO Configuration:622 - processing one-to-one association property references
11:35:49,237 INFO Configuration:647 - processing foreign key constraints
11:35:49,268 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
11:35:49,284 INFO SettingsFactory:62 - Use outer join fetching: false
11:35:49,284 INFO DriverManagerConnectionProvider:42 - Using Hibernate built-in connection pool (not for production use!)
11:35:49,284 INFO DriverManagerConnectionProvider:43 - Hibernate connection pool size: 20
11:35:49,299 INFO DriverManagerConnectionProvider:77 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/ers
11:35:49,299 INFO DriverManagerConnectionProvider:78 - connection properties: {user=wk5657, password=scotter1}
11:35:49,299 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
11:35:49,299 DEBUG DriverManagerConnectionProvider:84 - total checked-out connections: 0
11:35:49,299 DEBUG DriverManagerConnectionProvider:100 - opening new JDBC connection
11:35:49,471 DEBUG DriverManagerConnectionProvider:106 - created connection to: jdbc:mysql://localhost:3306/ers, Isolation Level: 4
11:35:49,471 DEBUG DriverManagerConnectionProvider:120 - returning connection to pool, pool size: 1
11:35:49,471 INFO SettingsFactory:102 - Use scrollable result sets: true
11:35:49,471 INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): true
11:35:49,471 INFO SettingsFactory:108 - Optimize cache for minimal puts: false
11:35:49,471 INFO SettingsFactory:117 - Query language substitutions: {}
11:35:49,471 INFO SettingsFactory:128 - cache provider: net.sf.ehcache.hibernate.Provider
11:35:49,471 INFO Configuration:1093 - instantiating and configuring caches
11:35:49,627 INFO SessionFactoryImpl:119 - building session factory
11:35:49,627 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {hibernate.connection.password=scotter1, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_03\bin, java.vm.version=1.4.2_03-b02, hibernate.connection.username=wk5657, 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=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\eclipse\workspace\ERSStart, java.runtime.version=1.4.2_03-b02, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\wkidd\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=C:\Program Files\Java\j2re1.4.2_03\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\Program Files\Rational\common, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, connection.password=scotter1, user.home=C:\Documents and Settings\wkidd, user.timezone=GMT-08:00, connection.username=wk5657, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=com.mysql.jdbc.Driver, user.name=wkidd, java.class.path=/c:/eclipse/plugins/org.eclipse.jdt.junit_3.0.0/junitsupport.jar;/c:/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\classes;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-beanutils.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-collections.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-digester.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-fileupload.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-lang.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-logging.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-validator.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jakarta-oro.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\struts-legacy.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\struts.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\mysql-connector-java-3.0.14-production-bin.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ant-1.5.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ant-optional-1.5.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\c3p0-0.8.4.5.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\cglib-full-2.0.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-collections-2.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-dbcp-1.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-lang-1.0.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-logging-1.0.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-pool-1.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\concurrent-1.3.2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\connector.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\dom4j-1.4.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ehcache-0.7.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\hibernate2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jaas.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-cache.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-common.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-jmx.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-system.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jcs-1.0-dev.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jgroups-2.2.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jta.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\junit-3.8.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\log4j-1.2.8.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\odmg-3.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\oscache-2.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\proxool-0.8.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xalan-2.4.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xerces-2.4.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xml-apis.jar, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_03, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.connection.url=jdbc:mysql://localhost:3306/ers, user.language=en, 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_03, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_03\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_03\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_03\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_03\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_03\classes;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\activation.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\javax.servlet.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jboss-j2ee.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jboss-jaas.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jsse.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jts.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\mail.jar, java.vendor=Sun Microsystems Inc., connection.driver_class=com.mysql.jdbc.Driver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, connection.url=jdbc:mysql://localhost:3306/ers, dialect=net.sf.hibernate.dialect.MySQLDialect, sun.cpu.isalist=pentium i486 i386}
11:35:49,971 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
11:35:49,971 DEBUG SessionFactoryObjectFactory:76 - registered: 00b02cf7fe69192700fe691929d30000 (unnamed)
11:35:49,971 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
11:35:49,971 DEBUG SessionFactoryImpl:196 - instantiated session factory
11:35:50,034 DEBUG SessionImpl:542 - opened session
11:35:50,034 DEBUG DriverManagerConnectionProvider:84 - total checked-out connections: 0
11:35:50,034 DEBUG DriverManagerConnectionProvider:90 - using pooled JDBC connection, pool size: 0
11:35:50,049 DEBUG DriverManagerConnectionProvider:120 - returning connection to pool, pool size: 1
11:35:50,081 DEBUG TableHiLoGenerator:62 - new hi value: 0
11:35:50,081 DEBUG SessionImpl:771 - generated identifier: 1
11:35:50,081 DEBUG SessionImpl:818 - saving [edu.ucop.ers.access.Permission#1]
11:35:50,081 DEBUG SessionImpl:2235 - flushing session
11:35:50,096 DEBUG SessionImpl:2428 - Flushing entities and processing referenced collections
11:35:50,096 DEBUG SessionImpl:2771 - Processing unreferenced collections
11:35:50,096 DEBUG SessionImpl:2785 - Scheduling collection removes/(re)creates/updates
11:35:50,096 DEBUG SessionImpl:2259 - Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
11:35:50,096 DEBUG SessionImpl:2264 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
11:35:50,096 DEBUG Printer:75 - listing entities:
11:35:50,096 DEBUG Printer:82 - edu.ucop.ers.access.Permission{permissionName=READ_ONLY, permissionCode=READ, permissionId=1}
11:35:50,096 DEBUG SessionImpl:2348 - executing flush
11:35:50,096 DEBUG EntityPersister:453 - Inserting entity: [edu.ucop.ers.access.Permission#1]
11:35:50,096 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
11:35:50,112 DEBUG DriverManagerConnectionProvider:84 - total checked-out connections: 0
11:35:50,112 DEBUG DriverManagerConnectionProvider:90 - using pooled JDBC connection, pool size: 0
11:35:50,112 DEBUG SQL:237 - insert into permission (permission_name, permission_code, permission_id) values (?, ?, ?)
11:35:50,112 DEBUG BatcherImpl:241 - preparing statement
11:35:50,112 DEBUG EntityPersister:388 - Dehydrating entity: [edu.ucop.ers.access.Permission#1]
11:35:50,112 DEBUG BatcherImpl:28 - Adding to batch
11:35:50,112 DEBUG BatcherImpl:50 - Executing batch size: 1
11:35:50,112 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
11:35:50,112 DEBUG BatcherImpl:261 - closing statement
11:35:50,112 DEBUG SessionImpl:2815 - post flush
11:35:50,143 DEBUG SessionImpl:2235 - flushing session
11:35:50,143 DEBUG SessionImpl:2428 - Flushing entities and processing referenced collections
11:35:50,143 DEBUG SessionImpl:2771 - Processing unreferenced collections
11:35:50,143 DEBUG SessionImpl:2785 - Scheduling collection removes/(re)creates/updates
11:35:50,143 DEBUG SessionImpl:2259 - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
11:35:50,143 DEBUG SessionImpl:2264 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
11:35:50,143 DEBUG Printer:75 - listing entities:
11:35:50,143 DEBUG Printer:82 - edu.ucop.ers.access.Permission{permissionName=READ_ONLY, permissionCode=READ, permissionId=1}
11:35:50,143 DEBUG SessionImpl:1807 - Dont need to execute flush
11:35:50,159 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
11:35:50,159 DEBUG SQL:237 - select this.permission_id as permissi1_0_, this.permission_name as permissi2_0_, this.permission_code as permissi3_0_ from permission this where this.permission_code=?
11:35:50,159 DEBUG BatcherImpl:241 - preparing statement
11:35:50,159 DEBUG Loader:197 - processing result set
11:35:50,159 DEBUG Loader:405 - result row: 1
11:35:50,159 DEBUG Loader:226 - done processing result set (1 rows)
11:35:50,159 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
11:35:50,159 DEBUG BatcherImpl:261 - closing statement
11:35:50,159 DEBUG Loader:239 - total objects hydrated: 0
11:35:50,159 DEBUG SessionImpl:3107 - initializing non-lazy collections
11:36:16,081 DEBUG SessionImpl:1151 - deleting a persistent instance
11:36:16,081 DEBUG SessionImpl:1171 - deleting [edu.ucop.ers.access.Permission#1]
11:36:16,081 DEBUG SessionImpl:2235 - flushing session
11:36:16,081 DEBUG SessionImpl:2428 - Flushing entities and processing referenced collections
11:36:16,081 DEBUG SessionImpl:2771 - Processing unreferenced collections
11:36:16,159 DEBUG SessionImpl:2785 - Scheduling collection removes/(re)creates/updates
11:36:16,159 DEBUG SessionImpl:2259 - Flushed: 0 insertions, 0 updates, 1 deletions to 1 objects
11:36:16,159 DEBUG SessionImpl:2264 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
11:36:16,159 DEBUG Printer:75 - listing entities:
11:36:16,159 DEBUG Printer:82 - edu.ucop.ers.access.Permission{permissionName=READ_ONLY, permissionCode=READ, permissionId=1}
11:36:16,159 DEBUG SessionImpl:2348 - executing flush
11:36:16,159 DEBUG EntityPersister:568 - Deleting entity: [edu.ucop.ers.access.Permission#1]
11:36:16,159 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
11:36:16,159 DEBUG SQL:237 - delete from permission where permission_id=?
11:36:16,159 DEBUG BatcherImpl:241 - preparing statement
11:36:16,159 DEBUG BatcherImpl:28 - Adding to batch
11:36:16,159 DEBUG BatcherImpl:50 - Executing batch size: 1
11:36:16,159 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
11:36:16,159 DEBUG BatcherImpl:261 - closing statement
11:36:16,159 DEBUG SessionImpl:2815 - post flush
11:36:16,175 DEBUG SessionImpl:560 - closing session
11:36:16,175 DEBUG SessionImpl:3327 - disconnecting session
11:36:16,175 DEBUG DriverManagerConnectionProvider:120 - returning connection to pool, pool size: 1
11:36:16,175 DEBUG SessionImpl:572 - transaction completion

AFTER 2nd complete execution:

11:38:04,004 INFO Environment:462 - Hibernate 2.1.3
11:38:04,020 INFO Environment:491 - hibernate.properties not found
11:38:04,020 INFO Environment:519 - using CGLIB reflection optimizer
11:38:04,035 INFO Configuration:872 - configuring from resource: /hibernate.cfg.xml
11:38:04,035 INFO Configuration:844 - Configuration resource: /hibernate.cfg.xml
11:38:04,332 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... on-2.0.dtd in classpath under net/sf/hibernate/
11:38:04,348 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... on-2.0.dtd in classpath
11:38:04,379 DEBUG Configuration:830 - connection.username=wk5657
11:38:04,379 DEBUG Configuration:830 - connection.url=jdbc:mysql://localhost:3306/ers
11:38:04,379 DEBUG Configuration:830 - dialect=net.sf.hibernate.dialect.MySQLDialect
11:38:04,379 DEBUG Configuration:830 - connection.password=scotter1
11:38:04,379 DEBUG Configuration:830 - connection.driver_class=com.mysql.jdbc.Driver
11:38:04,395 DEBUG Configuration:989 - null<-org.dom4j.tree.DefaultAttribute@b2a2d8 [Attribute: name resource value "Permission.hbm.xml"]
11:38:04,395 INFO Configuration:328 - Mapping resource: Permission.hbm.xml
11:38:04,395 DEBUG DTDEntityResolver:20 - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
11:38:04,395 DEBUG DTDEntityResolver:29 - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
11:38:04,504 INFO Binder:229 - Mapping class: edu.ucop.ers.access.Permission -> permission
11:38:04,567 DEBUG Binder:475 - Mapped property: permissionId -> permission_id, type: integer
11:38:04,582 DEBUG Binder:475 - Mapped property: permissionName -> permission_name, type: string
11:38:04,582 DEBUG Binder:475 - Mapped property: permissionCode -> permission_code, type: string
11:38:04,582 INFO Configuration:1030 - Configured SessionFactory: null
11:38:04,582 DEBUG Configuration:1031 - properties: {hibernate.connection.password=scotter1, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_03\bin, java.vm.version=1.4.2_03-b02, hibernate.connection.username=wk5657, 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=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\eclipse\workspace\ERSStart, java.runtime.version=1.4.2_03-b02, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\wkidd\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=C:\Program Files\Java\j2re1.4.2_03\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\Program Files\Rational\common, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, connection.password=scotter1, user.home=C:\Documents and Settings\wkidd, user.timezone=GMT-08:00, connection.username=wk5657, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=com.mysql.jdbc.Driver, user.name=wkidd, java.class.path=/c:/eclipse/plugins/org.eclipse.jdt.junit_3.0.0/junitsupport.jar;/c:/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\classes;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-beanutils.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-collections.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-digester.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-fileupload.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-lang.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-logging.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-validator.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jakarta-oro.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\struts-legacy.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\struts.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\mysql-connector-java-3.0.14-production-bin.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ant-1.5.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ant-optional-1.5.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\c3p0-0.8.4.5.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\cglib-full-2.0.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-collections-2.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-dbcp-1.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-lang-1.0.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-logging-1.0.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-pool-1.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\concurrent-1.3.2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\connector.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\dom4j-1.4.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ehcache-0.7.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\hibernate2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jaas.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-cache.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-common.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-jmx.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-system.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jcs-1.0-dev.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jgroups-2.2.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jta.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\junit-3.8.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\log4j-1.2.8.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\odmg-3.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\oscache-2.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\proxool-0.8.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xalan-2.4.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xerces-2.4.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xml-apis.jar, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_03, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.connection.url=jdbc:mysql://localhost:3306/ers, user.language=en, 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_03, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_03\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_03\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_03\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_03\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_03\classes;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\activation.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\javax.servlet.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jboss-j2ee.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jboss-jaas.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jsse.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jts.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\mail.jar, java.vendor=Sun Microsystems Inc., connection.driver_class=com.mysql.jdbc.Driver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, connection.url=jdbc:mysql://localhost:3306/ers, dialect=net.sf.hibernate.dialect.MySQLDialect, sun.cpu.isalist=pentium i486 i386}
11:38:04,582 INFO Configuration:613 - processing one-to-many association mappings
11:38:04,582 INFO Configuration:622 - processing one-to-one association property references
11:38:04,582 INFO Configuration:647 - processing foreign key constraints
11:38:04,614 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
11:38:04,614 INFO SettingsFactory:62 - Use outer join fetching: false
11:38:04,614 INFO DriverManagerConnectionProvider:42 - Using Hibernate built-in connection pool (not for production use!)
11:38:04,614 INFO DriverManagerConnectionProvider:43 - Hibernate connection pool size: 20
11:38:04,645 INFO DriverManagerConnectionProvider:77 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/ers
11:38:04,645 INFO DriverManagerConnectionProvider:78 - connection properties: {user=wk5657, password=scotter1}
11:38:04,660 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
11:38:04,660 DEBUG DriverManagerConnectionProvider:84 - total checked-out connections: 0
11:38:04,660 DEBUG DriverManagerConnectionProvider:100 - opening new JDBC connection
11:38:04,801 DEBUG DriverManagerConnectionProvider:106 - created connection to: jdbc:mysql://localhost:3306/ers, Isolation Level: 4
11:38:04,801 DEBUG DriverManagerConnectionProvider:120 - returning connection to pool, pool size: 1
11:38:04,801 INFO SettingsFactory:102 - Use scrollable result sets: true
11:38:04,801 INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): true
11:38:04,801 INFO SettingsFactory:108 - Optimize cache for minimal puts: false
11:38:04,801 INFO SettingsFactory:117 - Query language substitutions: {}
11:38:04,801 INFO SettingsFactory:128 - cache provider: net.sf.ehcache.hibernate.Provider
11:38:04,817 INFO Configuration:1093 - instantiating and configuring caches
11:38:04,910 INFO SessionFactoryImpl:119 - building session factory
11:38:04,910 DEBUG SessionFactoryImpl:125 - instantiating session factory with properties: {hibernate.connection.password=scotter1, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\Program Files\Java\j2re1.4.2_03\bin, java.vm.version=1.4.2_03-b02, hibernate.connection.username=wk5657, 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=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\eclipse\workspace\ERSStart, java.runtime.version=1.4.2_03-b02, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\wkidd\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=C:\Program Files\Java\j2re1.4.2_03\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\Program Files\Rational\common, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, connection.password=scotter1, user.home=C:\Documents and Settings\wkidd, user.timezone=GMT-08:00, connection.username=wk5657, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=com.mysql.jdbc.Driver, user.name=wkidd, java.class.path=/c:/eclipse/plugins/org.eclipse.jdt.junit_3.0.0/junitsupport.jar;/c:/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\classes;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-beanutils.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-collections.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-digester.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-fileupload.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-lang.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-logging.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-validator.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jakarta-oro.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\struts-legacy.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\struts.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\mysql-connector-java-3.0.14-production-bin.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ant-1.5.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ant-optional-1.5.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\c3p0-0.8.4.5.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\cglib-full-2.0.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-collections-2.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-dbcp-1.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-lang-1.0.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-logging-1.0.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\commons-pool-1.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\concurrent-1.3.2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\connector.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\dom4j-1.4.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\ehcache-0.7.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\hibernate2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jaas.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-cache.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-common.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-jmx.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jboss-system.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jcs-1.0-dev.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jgroups-2.2.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\jta.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\junit-3.8.1.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\log4j-1.2.8.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\odmg-3.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\oscache-2.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\proxool-0.8.3.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xalan-2.4.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xerces-2.4.0.jar;C:\eclipse\workspace\ERSStart\WebRoot\WEB-INF\lib\xml-apis.jar, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\j2re1.4.2_03, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.connection.url=jdbc:mysql://localhost:3306/ers, user.language=en, 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_03, java.ext.dirs=C:\Program Files\Java\j2re1.4.2_03\lib\ext, sun.boot.class.path=C:\Program Files\Java\j2re1.4.2_03\lib\rt.jar;C:\Program Files\Java\j2re1.4.2_03\lib\i18n.jar;C:\Program Files\Java\j2re1.4.2_03\lib\sunrsasign.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jsse.jar;C:\Program Files\Java\j2re1.4.2_03\lib\jce.jar;C:\Program Files\Java\j2re1.4.2_03\lib\charsets.jar;C:\Program Files\Java\j2re1.4.2_03\classes;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\activation.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\javax.servlet.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jboss-j2ee.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jboss-jaas.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jsse.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\jts.jar;C:\MyEclipse30\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.7.200\data\libraryset\1.3\mail.jar, java.vendor=Sun Microsystems Inc., connection.driver_class=com.mysql.jdbc.Driver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, connection.url=jdbc:mysql://localhost:3306/ers, dialect=net.sf.hibernate.dialect.MySQLDialect, sun.cpu.isalist=pentium i486 i386}
11:38:05,176 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
11:38:05,176 DEBUG SessionFactoryObjectFactory:76 - registered: 00b02cf7fe691b3800fe691b39f80000 (unnamed)
11:38:05,176 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
11:38:05,176 DEBUG SessionFactoryImpl:196 - instantiated session factory
11:38:05,223 DEBUG SessionImpl:542 - opened session
11:38:05,223 DEBUG DriverManagerConnectionProvider:84 - total checked-out connections: 0
11:38:05,239 DEBUG DriverManagerConnectionProvider:90 - using pooled JDBC connection, pool size: 0
11:38:05,239 DEBUG DriverManagerConnectionProvider:120 - returning connection to pool, pool size: 1
11:38:05,239 DEBUG TableHiLoGenerator:62 - new hi value: 1
11:38:05,239 DEBUG SessionImpl:771 - generated identifier: 32769
11:38:05,254 DEBUG SessionImpl:818 - saving [edu.ucop.ers.access.Permission#32769]
11:38:05,254 DEBUG SessionImpl:2235 - flushing session
11:38:05,254 DEBUG SessionImpl:2428 - Flushing entities and processing referenced collections
11:38:05,254 DEBUG SessionImpl:2771 - Processing unreferenced collections
11:38:05,254 DEBUG SessionImpl:2785 - Scheduling collection removes/(re)creates/updates
11:38:05,254 DEBUG SessionImpl:2259 - Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
11:38:05,254 DEBUG SessionImpl:2264 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
11:38:05,270 DEBUG Printer:75 - listing entities:
11:38:05,270 DEBUG Printer:82 - edu.ucop.ers.access.Permission{permissionName=READ_ONLY, permissionCode=READ, permissionId=32769}
11:38:05,270 DEBUG SessionImpl:2348 - executing flush
11:38:05,270 DEBUG EntityPersister:453 - Inserting entity: [edu.ucop.ers.access.Permission#32769]
11:38:05,270 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
11:38:05,270 DEBUG DriverManagerConnectionProvider:84 - total checked-out connections: 0
11:38:05,270 DEBUG DriverManagerConnectionProvider:90 - using pooled JDBC connection, pool size: 0
11:38:05,270 DEBUG SQL:237 - insert into permission (permission_name, permission_code, permission_id) values (?, ?, ?)
11:38:05,270 DEBUG BatcherImpl:241 - preparing statement
11:38:05,270 DEBUG EntityPersister:388 - Dehydrating entity: [edu.ucop.ers.access.Permission#32769]
11:38:05,270 DEBUG BatcherImpl:28 - Adding to batch
11:38:05,270 DEBUG BatcherImpl:50 - Executing batch size: 1
11:38:05,270 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
11:38:05,270 DEBUG BatcherImpl:261 - closing statement
11:38:05,270 DEBUG SessionImpl:2815 - post flush
11:38:05,285 DEBUG SessionImpl:2235 - flushing session
11:38:05,285 DEBUG SessionImpl:2428 - Flushing entities and processing referenced collections
11:38:05,285 DEBUG SessionImpl:2771 - Processing unreferenced collections
11:38:05,285 DEBUG SessionImpl:2785 - Scheduling collection removes/(re)creates/updates
11:38:05,301 DEBUG SessionImpl:2259 - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
11:38:05,301 DEBUG SessionImpl:2264 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
11:38:05,301 DEBUG Printer:75 - listing entities:
11:38:05,301 DEBUG Printer:82 - edu.ucop.ers.access.Permission{permissionName=READ_ONLY, permissionCode=READ, permissionId=32769}
11:38:05,301 DEBUG SessionImpl:1807 - Dont need to execute flush
11:38:05,301 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
11:38:05,301 DEBUG SQL:237 - select this.permission_id as permissi1_0_, this.permission_name as permissi2_0_, this.permission_code as permissi3_0_ from permission this where this.permission_code=?
11:38:05,301 DEBUG BatcherImpl:241 - preparing statement
11:38:05,301 DEBUG Loader:197 - processing result set
11:38:05,301 DEBUG Loader:405 - result row: 32769
11:38:05,301 DEBUG Loader:226 - done processing result set (1 rows)
11:38:05,301 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
11:38:05,301 DEBUG BatcherImpl:261 - closing statement
11:38:05,301 DEBUG Loader:239 - total objects hydrated: 0
11:38:05,301 DEBUG SessionImpl:3107 - initializing non-lazy collections
11:38:05,301 DEBUG SessionImpl:1151 - deleting a persistent instance
11:38:05,301 DEBUG SessionImpl:1171 - deleting [edu.ucop.ers.access.Permission#32769]
11:38:05,301 DEBUG SessionImpl:2235 - flushing session
11:38:05,301 DEBUG SessionImpl:2428 - Flushing entities and processing referenced collections
11:38:05,301 DEBUG SessionImpl:2771 - Processing unreferenced collections
11:38:05,301 DEBUG SessionImpl:2785 - Scheduling collection removes/(re)creates/updates
11:38:05,317 DEBUG SessionImpl:2259 - Flushed: 0 insertions, 0 updates, 1 deletions to 1 objects
11:38:05,317 DEBUG SessionImpl:2264 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
11:38:05,317 DEBUG Printer:75 - listing entities:
11:38:05,317 DEBUG Printer:82 - edu.ucop.ers.access.Permission{permissionName=READ_ONLY, permissionCode=READ, permissionId=32769}
11:38:05,317 DEBUG SessionImpl:2348 - executing flush
11:38:05,317 DEBUG EntityPersister:568 - Deleting entity: [edu.ucop.ers.access.Permission#32769]
11:38:05,317 DEBUG BatcherImpl:196 - about to open: 0 open PreparedStatements, 0 open ResultSets
11:38:05,317 DEBUG SQL:237 - delete from permission where permission_id=?
11:38:05,317 DEBUG BatcherImpl:241 - preparing statement
11:38:05,317 DEBUG BatcherImpl:28 - Adding to batch
11:38:05,332 DEBUG BatcherImpl:50 - Executing batch size: 1
11:38:05,332 DEBUG BatcherImpl:203 - done closing: 0 open PreparedStatements, 0 open ResultSets
11:38:05,332 DEBUG BatcherImpl:261 - closing statement
11:38:05,332 DEBUG SessionImpl:2815 - post flush
11:38:05,332 DEBUG SessionImpl:560 - closing session
11:38:05,332 DEBUG SessionImpl:3327 - disconnecting session
11:38:05,332 DEBUG DriverManagerConnectionProvider:120 - returning connection to pool, pool size: 1
11:38:05,332 DEBUG SessionImpl:572 - transaction completion
Top
 Profile  
 
emmanuel
 Post subject:
PostPosted: Mon Aug 16, 2004 6:26 pm 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
This is expected.
The hilo algorithm means reserve a range in memory.
The defaut value is the max value for short

so The first time you get 1
The second call (rebuild of SF or so) you'll get maxlo + 1
Use the parameters of generator for more tuning (check the doc)

_________________
Emmanuel

Top
 Profile  
 
wk5657
 Post subject:
PostPosted: Mon Aug 16, 2004 8:19 pm 
Newbie

Joined: Sun Aug 01, 2004 8:23 pm
Posts: 11
Thank you for the response. During a long web application, I expect the session factory to last a long time, but during a junit test, it may only last through the creation of a single row. What do you suggest as a compromise. Also, what is the cost of making the number much smaller (I presume we are talking about the max_lo parameter). Thanks again.

Wayne
Top
 Profile  
 
emmanuel
 Post subject:
PostPosted: Wed Aug 18, 2004 3:38 am 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
I probably would use 100, it make the application hit the DB 1 out of 100 to get the next id

_________________
Emmanuel

Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.