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.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Unexplained db2 warning
PostPosted: Fri Jun 25, 2010 8:54 am 
Newbie

Joined: Thu Jun 09, 2005 7:12 am
Posts: 7
In my seemingly innocuous test example, I do a single insert into a DB2 database. All goes well the insert works fine but in the end there's a warning that hibernate reports that I can't figure out for the life of me. The db2 forums aren't too helpful either nor did I find anything here. So here goes:

Code:

com.ibm.db2.jcc.b.SqlWarning: DB2 SQL Warning: SQLCODE=0, SQLSTATE=     , SQLERRMC=1;1208;DB2ADMIN;SMKTST;QDB2/NT;2499;2499;0;1208;0;, DRIVER=3.50.152
   at com.ibm.db2.jcc.b.wc.b(wc.java:163)
   at com.ibm.db2.jcc.b.wc.b(wc.java:232)
   at com.ibm.db2.jcc.b.eb.a(eb.java:3607)
   at com.ibm.db2.jcc.t4.bb.l(bb.java:403)
   at com.ibm.db2.jcc.t4.bb.d(bb.java:141)
   at com.ibm.db2.jcc.t4.b.Dc(b.java:1383)
   at com.ibm.db2.jcc.t4.b.b(b.java:1307)
   at com.ibm.db2.jcc.t4.b.s(b.java:1022)
   at com.ibm.db2.jcc.t4.b.c(b.java:632)
   at com.ibm.db2.jcc.t4.b.b(b.java:618)
   at com.ibm.db2.jcc.t4.b.a(b.java:360)
   at com.ibm.db2.jcc.t4.b.<init>(b.java:298)
   at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:193)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
   at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114)
   at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)
   at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)
   at com.maple.domain.inventory.TestInventoryItem.testHibernate(TestInventoryItem.java:40)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
   at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
   at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
   at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
   at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
   at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
   at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
   at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
   at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
   at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
   at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
   at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
17:52:50,440  WARN main util.JDBCExceptionReporter:77 - SQL Warning: 0, SQLState:     
17:52:50,440  WARN main util.JDBCExceptionReporter:78 - DB2 SQL Warning: SQLCODE=0, SQLSTATE=     , SQLERRMC=1;1208;DB2ADMIN;SMKTST;QDB2/NT;2499;2499;0;1208;0;, DRIVER=3.50.152





Top
 Profile  
 
 Post subject: Re: Unexplained db2 warning
PostPosted: Fri Jun 25, 2010 12:54 pm 
Newbie

Joined: Fri Jun 25, 2010 12:18 pm
Posts: 2
I would recommend modifying your log4j configuration to change the log4j.logger.org.hibernate logger to DEBUG.

This will cause hibernate to log all of the actual SQL statements.

Once you have the actual SQL statement causing the problem, take it to the Db2 forums and ask them for the source of the problem. Then we can figure out how to change the hibernate settings to prevent the incorrect SQL.


Top
 Profile  
 
 Post subject: Re: Unexplained db2 warning
PostPosted: Mon Jun 28, 2010 1:04 am 
Newbie

Joined: Thu Jun 09, 2005 7:12 am
Posts: 7
Debug is turned on. Here is the complete output.

Code:
17:52:42,053  INFO main support.ClassPathXmlApplicationContext:454 - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@13582d: startup date [Fri Jun 25 17:52:42 IST 2010]; root of context hierarchy
17:52:42,709  INFO main cfg.Environment:570 - Hibernate 3.5.2-Final
17:52:42,709  INFO main cfg.Environment:603 - hibernate.properties not found
17:52:42,709  INFO main cfg.Environment:781 - Bytecode provider name : javassist
17:52:42,740  INFO main cfg.Environment:662 - using JDK 1.4 java.sql.Timestamp handling
[snip]
more hibernate logs
[snip]
17:52:42,990 DEBUG main util.DTDEntityResolver:64 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
17:52:42,990 DEBUG main util.DTDEntityResolver:66 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
17:52:43,005 DEBUG main util.DTDEntityResolver:76 - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
17:52:43,146  INFO main cfg.HbmBinder:348 - Mapping class: com.maple.domain.inventory.Sku -> SKU
17:52:43,162 DEBUG main cfg.HbmBinder:1335 - Mapped property: skuNumber -> SKU_ID
17:52:43,177 DEBUG main cfg.HbmBinder:1335 - Mapped property: skuCode -> SKU_CODE
17:52:43,177 DEBUG main util.DTDEntityResolver:64 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
17:52:43,177 DEBUG main util.DTDEntityResolver:66 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
17:52:43,177 DEBUG main util.DTDEntityResolver:76 - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
17:52:43,240  INFO main cfg.HbmBinder:348 - Mapping class: com.maple.domain.inventory.InventoryItem -> INVENTORY_ITEM
17:52:43,240 DEBUG main cfg.HbmBinder:1335 - Mapped property: itemId -> INVENTORY_ID
17:52:43,240 DEBUG main cfg.HbmBinder:1335 - Mapped property: inventoryIn -> INVENTORY_IN
17:52:43,240 DEBUG main cfg.HbmBinder:1335 - Mapped property: inventoryOut -> INVENTORY_OUT
17:52:43,240 DEBUG main cfg.Configuration:1211 - processing extends queue
17:52:43,240 DEBUG main cfg.Configuration:1215 - processing collection mappings
17:52:43,240 DEBUG main cfg.Configuration:1226 - processing native query and ResultSetMapping mappings
17:52:43,240 DEBUG main cfg.Configuration:1234 - processing association property references
17:52:43,240 DEBUG main cfg.Configuration:1256 - processing foreign key constraints
17:52:43,255  INFO main hibernate3.LocalSessionFactoryBean:772 - Building new Hibernate SessionFactory
17:52:43,255 DEBUG main cfg.Configuration:1376 - Preparing to build session factory with filters : {}
17:52:43,255 DEBUG main cfg.Configuration:1211 - processing extends queue
17:52:43,255 DEBUG main cfg.Configuration:1215 - processing collection mappings
17:52:43,255 DEBUG main cfg.Configuration:1226 - processing native query and ResultSetMapping mappings
17:52:43,255 DEBUG main cfg.Configuration:1234 - processing association property references
17:52:43,255 DEBUG main cfg.Configuration:1256 - processing foreign key constraints
17:52:43,427  INFO main connection.ConnectionProviderFactory:95 - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
17:52:48,722  INFO main cfg.SettingsFactory:117 - RDBMS: DB2/NT, version: SQL09013
17:52:48,722  INFO main cfg.SettingsFactory:118 - JDBC driver: IBM DB2 JDBC Universal Driver Architecture, version: 3.50.152
17:52:48,769  INFO main dialect.Dialect:206 - Using dialect: org.hibernate.dialect.DB2Dialect
17:52:48,784  INFO main jdbc.JdbcSupportLoader:79 - Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
17:52:48,784  INFO main transaction.TransactionFactoryFactory:62 - Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
17:52:48,784  INFO main transaction.TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
17:52:48,784  INFO main cfg.SettingsFactory:169 - Automatic flush during beforeCompletion(): disabled
17:52:48,784  INFO main cfg.SettingsFactory:173 - Automatic session close at end of transaction: disabled
17:52:48,784  INFO main cfg.SettingsFactory:188 - Scrollable result sets: enabled
17:52:48,784 DEBUG main cfg.SettingsFactory:192 - Wrap result sets: disabled
17:52:48,784  INFO main cfg.SettingsFactory:196 - JDBC3 getGeneratedKeys(): enabled
17:52:48,800  INFO main cfg.SettingsFactory:204 - Connection release mode: auto
17:52:48,800  INFO main cfg.SettingsFactory:231 - Default batch fetch size: 1
17:52:48,800  INFO main cfg.SettingsFactory:235 - Generate SQL with comments: disabled
17:52:48,800  INFO main cfg.SettingsFactory:239 - Order SQL updates by primary key: disabled
17:52:48,800  INFO main cfg.SettingsFactory:243 - Order SQL inserts for batching: disabled
17:52:48,800  INFO main cfg.SettingsFactory:410 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:52:48,800  INFO main ast.ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
17:52:48,800  INFO main cfg.SettingsFactory:251 - Query language substitutions: {}
17:52:48,800  INFO main cfg.SettingsFactory:256 - JPA-QL strict compliance: disabled
17:52:48,800  INFO main cfg.SettingsFactory:261 - Second-level cache: enabled
17:52:48,800  INFO main cfg.SettingsFactory:265 - Query cache: disabled
17:52:48,800  INFO main cfg.SettingsFactory:395 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
17:52:48,800  INFO main cfg.SettingsFactory:275 - Optimize cache for minimal puts: disabled
17:52:48,800  INFO main cfg.SettingsFactory:284 - Structured second-level cache entries: disabled
17:52:48,815  INFO main cfg.SettingsFactory:313 - Statistics: disabled
17:52:48,815  INFO main cfg.SettingsFactory:317 - Deleted entity synthetic identifier rollback: disabled
17:52:48,815  INFO main cfg.SettingsFactory:332 - Default entity-mode: pojo
17:52:48,815  INFO main cfg.SettingsFactory:336 - Named query checking : enabled
17:52:48,815  INFO main cfg.SettingsFactory:340 - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
17:52:48,878  INFO main impl.SessionFactoryImpl:199 - building session factory
17:52:48,894 DEBUG main impl.SessionFactoryImpl:238 - Session factory constructed with filter configurations : {}
17:52:48,894 DEBUG main impl.SessionFactoryImpl:242 - instantiating session factory with properties: {java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre6\bin, java.vm.version=11.0-b16, 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.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 3, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Devavrat\eclipseworkspaces\maple\Maple, java.runtime.version=1.6.0_11-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, hibernate.current_session_context_class=org.springframework.orm.hibernate3.SpringSessionContext, java.endorsed.dirs=C:\Program Files\Java\jre6\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\722679\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jre6\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jre6\bin\client;C:\Program Files\Java\jre6\bin;%M2%;C:\Program Files\CA\SC\CAWIN\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\Downloaded Program Files;C:\IBMTOOLS\Python22;C:\PROGRA~1\CA\SC\CAM\bin;C:\Program Files\CA\DSM\bin;C:\Program Files\Java\jdk1.5.0_15\bin;C:\Devavrat\software\Ant\apache-ant-1.7.1\bin;C:\Program Files\VisualSVN Server\bin;C:\Program Files\MySQL\MySQL Server 5.1\bin;, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, hibernate.transaction.factory_class=org.springframework.orm.hibernate3.SpringTransactionFactory, os.version=5.1, user.home=C:\Documents and Settings\722679, user.timezone=Asia/Calcutta, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.6, java.class.path=C:\Devavrat\eclipseworkspaces\maple\Maple\bin;C:\eclipse\plugins\org.junit4_4.3.1\junit.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.asm-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.context-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.core-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.expression-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.beans-3.0.2.RELEASE.jar;C:\Devavrat\eclipseworkspaces\maple\Maple\src\main\resources;C:\Devavrat\software\db2\drivers\db2jcc_license_cu.jar;C:\Devavrat\software\db2\drivers\db2jcc.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\antlr-2.7.6.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\commons-collections-3.1.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\dom4j-1.6.1.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\javassist-3.9.0.GA.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\jta-1.1.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\hibernate3.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.orm-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.jdbc-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.transaction-3.0.2.RELEASE.jar;C:\Documents and Settings\722679\.m2\repository\commons-dbcp\commons-dbcp-1.4\commons-dbcp-1.4.jar;C:\Documents and Settings\722679\.m2\repository\commons-pool\commons-pool-1.5.4\commons-pool-1.5.4.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.aop-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.aspects-3.0.2.RELEASE.jar;C:\Documents and Settings\722679\.m2\repository\aopalliance\aopalliance-alpha1.jar;C:\Documents and Settings\722679\.m2\repository\aopalliance\aopalliance.jar;C:\Devavrat\software\slf4j\slf4j-1.5.2\slf4j-api-1.5.2.jar;C:\Devavrat\software\slf4j\slf4j-1.5.2\slf4j-log4j12-1.5.2.jar;C:\dcm4chee-2.14.8-mysql\server\default\lib\log4j.jar;C:\Devavrat\software\slf4j\slf4j-1.5.2\jcl-over-slf4j-1.5.2.jar;/C:/eclipse/configuration/org.eclipse.osgi/bundles/191/1/.cp/;/C:/eclipse/configuration/org.eclipse.osgi/bundles/192/1/.cp/;/C:/eclipse/configuration/org.eclipse.osgi/bundles/190/1/.cp/, user.name=722679, hibernate.bytecode.use_reflection_optimizer=false, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Program Files\Java\jre6, hibernate.dialect=org.hibernate.dialect.DB2Dialect, java.specification.vendor=Sun Microsystems Inc., user.language=en, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_11, java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.connection.provider_class=org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, sun.desktop=windows, sun.cpu.isalist=}
17:52:48,894 DEBUG main factory.DefaultIdentifierGeneratorFactory:89 - Setting dialect [org.hibernate.dialect.DB2Dialect]
17:52:48,894 DEBUG main factory.DefaultIdentifierGeneratorFactory:89 - Setting dialect [org.hibernate.dialect.DB2Dialect]
17:52:49,190 DEBUG main entity.AbstractEntityPersister:2936 - Static SQL for entity: com.maple.domain.inventory.InventoryItem
17:52:49,190 DEBUG main entity.AbstractEntityPersister:2941 -  Version select: select INVENTORY_ID from INVENTORY_ITEM where INVENTORY_ID =?
17:52:49,190 DEBUG main entity.AbstractEntityPersister:2944 -  Snapshot select: select inventoryi_.INVENTORY_ID, inventoryi_.INVENTORY_IN as INVENTORY2_1_, inventoryi_.INVENTORY_OUT as INVENTORY3_1_ from INVENTORY_ITEM inventoryi_ where inventoryi_.INVENTORY_ID=?
17:52:49,190 DEBUG main entity.AbstractEntityPersister:2947 -  Insert 0: insert into INVENTORY_ITEM (INVENTORY_IN, INVENTORY_OUT, INVENTORY_ID) values (?, ?, ?)
17:52:49,190 DEBUG main entity.AbstractEntityPersister:2948 -  Update 0: update INVENTORY_ITEM set INVENTORY_IN=?, INVENTORY_OUT=? where INVENTORY_ID=?
17:52:49,190 DEBUG main entity.AbstractEntityPersister:2949 -  Delete 0: delete from INVENTORY_ITEM where INVENTORY_ID=?
17:52:49,206 DEBUG main entity.AbstractEntityPersister:2936 - Static SQL for entity: com.maple.domain.inventory.Sku
17:52:49,206 DEBUG main entity.AbstractEntityPersister:2941 -  Version select: select SKU_ID from SKU where SKU_ID =?
17:52:49,206 DEBUG main entity.AbstractEntityPersister:2944 -  Snapshot select: select sku_.SKU_ID, sku_.SKU_CODE as SKU2_0_ from SKU sku_ where sku_.SKU_ID=?
17:52:49,206 DEBUG main entity.AbstractEntityPersister:2947 -  Insert 0: insert into SKU (SKU_CODE, SKU_ID) values (?, ?)
17:52:49,206 DEBUG main entity.AbstractEntityPersister:2948 -  Update 0: update SKU set SKU_CODE=? where SKU_ID=?
17:52:49,206 DEBUG main entity.AbstractEntityPersister:2949 -  Delete 0: delete from SKU where SKU_ID=?
[snip]
more hibernate logs
[snip]
17:52:49,253 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.InventoryItem [PESSIMISTIC_FORCE_INCREMENT]: select inventoryi0_.INVENTORY_ID as INVENTORY1_1_0_, inventoryi0_.INVENTORY_IN as INVENTORY2_1_0_, inventoryi0_.INVENTORY_OUT as INVENTORY3_1_0_ from INVENTORY_ITEM inventoryi0_ where inventoryi0_.INVENTORY_ID=? for read only with rs
17:52:49,253 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.InventoryItem [OPTIMISTIC]: select inventoryi0_.INVENTORY_ID as INVENTORY1_1_0_, inventoryi0_.INVENTORY_IN as INVENTORY2_1_0_, inventoryi0_.INVENTORY_OUT as INVENTORY3_1_0_ from INVENTORY_ITEM inventoryi0_ where inventoryi0_.INVENTORY_ID=?
17:52:49,253 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.InventoryItem [OPTIMISTIC_FORCE_INCREMENT]: select inventoryi0_.INVENTORY_ID as INVENTORY1_1_0_, inventoryi0_.INVENTORY_IN as INVENTORY2_1_0_, inventoryi0_.INVENTORY_OUT as INVENTORY3_1_0_ from INVENTORY_ITEM inventoryi0_ where inventoryi0_.INVENTORY_ID=?
17:52:49,268 DEBUG main entity.EntityLoader:56 - Static select for action ACTION_MERGE on entity com.maple.domain.inventory.InventoryItem: select inventoryi0_.INVENTORY_ID as INVENTORY1_1_0_, inventoryi0_.INVENTORY_IN as INVENTORY2_1_0_, inventoryi0_.INVENTORY_OUT as INVENTORY3_1_0_ from INVENTORY_ITEM inventoryi0_ where inventoryi0_.INVENTORY_ID=?
17:52:49,268 DEBUG main entity.EntityLoader:56 - Static select for action ACTION_REFRESH on entity com.maple.domain.inventory.InventoryItem: select inventoryi0_.INVENTORY_ID as INVENTORY1_1_0_, inventoryi0_.INVENTORY_IN as INVENTORY2_1_0_, inventoryi0_.INVENTORY_OUT as INVENTORY3_1_0_ from INVENTORY_ITEM inventoryi0_ where inventoryi0_.INVENTORY_ID=?
17:52:49,268 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [NONE]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=?
17:52:49,268 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [READ]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=?
17:52:49,268 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [UPGRADE]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:49,268 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [UPGRADE_NOWAIT]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:49,284 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [FORCE]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:49,284 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [PESSIMISTIC_READ]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:49,284 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [PESSIMISTIC_WRITE]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:49,284 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [PESSIMISTIC_FORCE_INCREMENT]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:49,284 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [OPTIMISTIC]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=?
17:52:49,284 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [OPTIMISTIC_FORCE_INCREMENT]: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=?
17:52:49,284 DEBUG main entity.EntityLoader:56 - Static select for action ACTION_MERGE on entity com.maple.domain.inventory.Sku: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=?
17:52:49,284 DEBUG main entity.EntityLoader:56 - Static select for action ACTION_REFRESH on entity com.maple.domain.inventory.Sku: select sku0_.SKU_ID as SKU1_0_0_, sku0_.SKU_CODE as SKU2_0_0_ from SKU sku0_ where sku0_.SKU_ID=?
17:52:49,284 DEBUG main impl.SessionFactoryObjectFactory:62 - initializing class SessionFactoryObjectFactory
17:52:49,300 DEBUG main impl.SessionFactoryObjectFactory:99 - registered: 2c998202296f0f5501296f0f6ec40000 (unnamed)
17:52:49,300  INFO main impl.SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured
17:52:49,300 DEBUG main impl.SessionFactoryImpl:378 - instantiated session factory
17:52:49,300 DEBUG main impl.SessionFactoryImpl:550 - Checking 0 named HQL queries
17:52:49,300 DEBUG main impl.SessionFactoryImpl:570 - Checking 0 named SQL queries
17:52:49,362  INFO main support.ClassPathXmlApplicationContext:454 - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@3f96ee: startup date [Fri Jun 25 17:52:49 IST 2010]; root of context hierarchy
[snip]
more hibernate logs
[snip]
17:52:49,487 DEBUG main factory.DefaultIdentifierGeneratorFactory:99 - Registering IdentifierGenerator strategy [enhanced-table] -> [class org.hibernate.id.enhanced.TableGenerator]
17:52:49,503 DEBUG main util.DTDEntityResolver:64 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
17:52:49,503 DEBUG main util.DTDEntityResolver:66 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
17:52:49,503 DEBUG main util.DTDEntityResolver:76 - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
17:52:49,534  INFO main cfg.HbmBinder:348 - Mapping class: com.maple.domain.inventory.Sku -> SKU
17:52:49,534 DEBUG main cfg.HbmBinder:1335 - Mapped property: skuNumber -> SKU_ID
17:52:49,534 DEBUG main cfg.HbmBinder:1335 - Mapped property: skuCode -> SKU_CODE
17:52:49,534 DEBUG main util.DTDEntityResolver:64 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
17:52:49,534 DEBUG main util.DTDEntityResolver:66 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
17:52:49,565 DEBUG main util.DTDEntityResolver:76 - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
17:52:49,596  INFO main cfg.HbmBinder:348 - Mapping class: com.maple.domain.inventory.InventoryItem -> INVENTORY_ITEM
17:52:49,596 DEBUG main cfg.HbmBinder:1335 - Mapped property: itemId -> INVENTORY_ID
17:52:49,596 DEBUG main cfg.HbmBinder:1335 - Mapped property: inventoryIn -> INVENTORY_IN
17:52:49,596 DEBUG main cfg.HbmBinder:1335 - Mapped property: inventoryOut -> INVENTORY_OUT
17:52:49,596 DEBUG main cfg.Configuration:1211 - processing extends queue
17:52:49,596 DEBUG main cfg.Configuration:1215 - processing collection mappings
17:52:49,596 DEBUG main cfg.Configuration:1226 - processing native query and ResultSetMapping mappings
17:52:49,596 DEBUG main cfg.Configuration:1234 - processing association property references
17:52:49,596 DEBUG main cfg.Configuration:1256 - processing foreign key constraints
17:52:49,596  INFO main hibernate3.LocalSessionFactoryBean:772 - Building new Hibernate SessionFactory
17:52:49,612 DEBUG main cfg.Configuration:1376 - Preparing to build session factory with filters : {}
17:52:49,612 DEBUG main cfg.Configuration:1211 - processing extends queue
17:52:49,612 DEBUG main cfg.Configuration:1215 - processing collection mappings
17:52:49,612 DEBUG main cfg.Configuration:1226 - processing native query and ResultSetMapping mappings
17:52:49,612 DEBUG main cfg.Configuration:1234 - processing association property references
17:52:49,612 DEBUG main cfg.Configuration:1256 - processing foreign key constraints
17:52:49,612  INFO main connection.ConnectionProviderFactory:95 - Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
17:52:49,784  INFO main cfg.SettingsFactory:117 - RDBMS: DB2/NT, version: SQL09013
17:52:49,784  INFO main cfg.SettingsFactory:118 - JDBC driver: IBM DB2 JDBC Universal Driver Architecture, version: 3.50.152
17:52:49,784  INFO main dialect.Dialect:206 - Using dialect: org.hibernate.dialect.DB2Dialect
17:52:49,784  INFO main jdbc.JdbcSupportLoader:79 - Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
17:52:49,784  INFO main transaction.TransactionFactoryFactory:62 - Transaction strategy: org.springframework.orm.hibernate3.SpringTransactionFactory
17:52:49,784  INFO main transaction.TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
17:52:49,799  INFO main cfg.SettingsFactory:169 - Automatic flush during beforeCompletion(): disabled
17:52:49,815  INFO main cfg.SettingsFactory:173 - Automatic session close at end of transaction: disabled
17:52:49,815  INFO main cfg.SettingsFactory:188 - Scrollable result sets: enabled
17:52:49,815 DEBUG main cfg.SettingsFactory:192 - Wrap result sets: disabled
17:52:49,815  INFO main cfg.SettingsFactory:196 - JDBC3 getGeneratedKeys(): enabled
17:52:49,815  INFO main cfg.SettingsFactory:204 - Connection release mode: auto
17:52:49,815  INFO main cfg.SettingsFactory:231 - Default batch fetch size: 1
17:52:49,815  INFO main cfg.SettingsFactory:235 - Generate SQL with comments: disabled
17:52:49,815  INFO main cfg.SettingsFactory:239 - Order SQL updates by primary key: disabled
17:52:49,815  INFO main cfg.SettingsFactory:243 - Order SQL inserts for batching: disabled
17:52:49,815  INFO main cfg.SettingsFactory:410 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:52:49,815  INFO main ast.ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
17:52:49,815  INFO main cfg.SettingsFactory:251 - Query language substitutions: {}
17:52:49,815  INFO main cfg.SettingsFactory:256 - JPA-QL strict compliance: disabled
17:52:49,815  INFO main cfg.SettingsFactory:261 - Second-level cache: enabled
17:52:49,815  INFO main cfg.SettingsFactory:265 - Query cache: disabled
17:52:49,815  INFO main cfg.SettingsFactory:395 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
17:52:49,815  INFO main cfg.SettingsFactory:275 - Optimize cache for minimal puts: disabled
17:52:49,815  INFO main cfg.SettingsFactory:284 - Structured second-level cache entries: disabled
17:52:49,815  INFO main cfg.SettingsFactory:313 - Statistics: disabled
17:52:49,815  INFO main cfg.SettingsFactory:317 - Deleted entity synthetic identifier rollback: disabled
17:52:49,815  INFO main cfg.SettingsFactory:332 - Default entity-mode: pojo
17:52:49,815  INFO main cfg.SettingsFactory:336 - Named query checking : enabled
17:52:49,815  INFO main cfg.SettingsFactory:340 - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
17:52:49,831  INFO main impl.SessionFactoryImpl:199 - building session factory
17:52:49,831 DEBUG main impl.SessionFactoryImpl:238 - Session factory constructed with filter configurations : {}
17:52:49,831 DEBUG main impl.SessionFactoryImpl:242 - instantiating session factory with properties: {java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\Program Files\Java\jre6\bin, java.vm.version=11.0-b16, 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.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 3, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Devavrat\eclipseworkspaces\maple\Maple, java.runtime.version=1.6.0_11-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, hibernate.current_session_context_class=org.springframework.orm.hibernate3.SpringSessionContext, java.endorsed.dirs=C:\Program Files\Java\jre6\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\722679\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jre6\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jre6\bin\client;C:\Program Files\Java\jre6\bin;%M2%;C:\Program Files\CA\SC\CAWIN\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\Downloaded Program Files;C:\IBMTOOLS\Python22;C:\PROGRA~1\CA\SC\CAM\bin;C:\Program Files\CA\DSM\bin;C:\Program Files\Java\jdk1.5.0_15\bin;C:\Devavrat\software\Ant\apache-ant-1.7.1\bin;C:\Program Files\VisualSVN Server\bin;C:\Program Files\MySQL\MySQL Server 5.1\bin;, java.specification.name=Java Platform API Specification, java.class.version=50.0, sun.management.compiler=HotSpot Client Compiler, hibernate.transaction.factory_class=org.springframework.orm.hibernate3.SpringTransactionFactory, os.version=5.1, user.home=C:\Documents and Settings\722679, user.timezone=Asia/Calcutta, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.6, java.class.path=C:\Devavrat\eclipseworkspaces\maple\Maple\bin;C:\eclipse\plugins\org.junit4_4.3.1\junit.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.asm-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.context-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.core-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.expression-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.beans-3.0.2.RELEASE.jar;C:\Devavrat\eclipseworkspaces\maple\Maple\src\main\resources;C:\Devavrat\software\db2\drivers\db2jcc_license_cu.jar;C:\Devavrat\software\db2\drivers\db2jcc.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\antlr-2.7.6.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\commons-collections-3.1.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\dom4j-1.6.1.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\javassist-3.9.0.GA.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\jta-1.1.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\hibernate3.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.orm-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.jdbc-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.transaction-3.0.2.RELEASE.jar;C:\Documents and Settings\722679\.m2\repository\commons-dbcp\commons-dbcp-1.4\commons-dbcp-1.4.jar;C:\Documents and Settings\722679\.m2\repository\commons-pool\commons-pool-1.5.4\commons-pool-1.5.4.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.aop-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.aspects-3.0.2.RELEASE.jar;C:\Documents and Settings\722679\.m2\repository\aopalliance\aopalliance-alpha1.jar;C:\Documents and Settings\722679\.m2\repository\aopalliance\aopalliance.jar;C:\Devavrat\software\slf4j\slf4j-1.5.2\slf4j-api-1.5.2.jar;C:\Devavrat\software\slf4j\slf4j-1.5.2\slf4j-log4j12-1.5.2.jar;C:\dcm4chee-2.14.8-mysql\server\default\lib\log4j.jar;C:\Devavrat\software\slf4j\slf4j-1.5.2\jcl-over-slf4j-1.5.2.jar;/C:/eclipse/configuration/org.eclipse.osgi/bundles/191/1/.cp/;/C:/eclipse/configuration/org.eclipse.osgi/bundles/192/1/.cp/;/C:/eclipse/configuration/org.eclipse.osgi/bundles/190/1/.cp/, user.name=722679, hibernate.bytecode.use_reflection_optimizer=false, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Program Files\Java\jre6, hibernate.dialect=org.hibernate.dialect.DB2Dialect, java.specification.vendor=Sun Microsystems Inc., user.language=en, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_11, java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, hibernate.connection.provider_class=org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, sun.desktop=windows, sun.cpu.isalist=}
17:52:49,831 DEBUG main factory.DefaultIdentifierGeneratorFactory:89 - Setting dialect [org.hibernate.dialect.DB2Dialect]
17:52:49,831 DEBUG main factory.DefaultIdentifierGeneratorFactory:89 - Setting dialect [org.hibernate.dialect.DB2Dialect]
17:52:49,831 DEBUG main entity.AbstractEntityPersister:2936 - Static SQL for entity: com.maple.domain.inventory.InventoryItem
17:52:49,831 DEBUG main entity.AbstractEntityPersister:2941 -  Version select: select INVENTORY_ID from INVENTORY_ITEM where INVENTORY_ID =?
17:52:49,831 DEBUG main entity.AbstractEntityPersister:2944 -  Snapshot select: select inventoryi_.INVENTORY_ID, inventoryi_.INVENTORY_IN as INVENTORY2_5_, inventoryi_.INVENTORY_OUT as INVENTORY3_5_ from INVENTORY_ITEM inventoryi_ where inventoryi_.INVENTORY_ID=?
17:52:49,831 DEBUG main entity.AbstractEntityPersister:2947 -  Insert 0: insert into INVENTORY_ITEM (INVENTORY_IN, INVENTORY_OUT, INVENTORY_ID) values (?, ?, ?)
17:52:49,831 DEBUG main entity.AbstractEntityPersister:2948 -  Update 0: update INVENTORY_ITEM set INVENTORY_IN=?, INVENTORY_OUT=? where INVENTORY_ID=?
17:52:49,831 DEBUG main entity.AbstractEntityPersister:2949 -  Delete 0: delete from INVENTORY_ITEM where INVENTORY_ID=?
17:52:49,846 DEBUG main entity.AbstractEntityPersister:2936 - Static SQL for entity: com.maple.domain.inventory.Sku
17:52:49,846 DEBUG main entity.AbstractEntityPersister:2941 -  Version select: select SKU_ID from SKU where SKU_ID =?
17:52:49,846 DEBUG main entity.AbstractEntityPersister:2944 -  Snapshot select: select sku_.SKU_ID, sku_.SKU_CODE as SKU2_4_ from SKU sku_ where sku_.SKU_ID=?
17:52:49,846 DEBUG main entity.AbstractEntityPersister:2947 -  Insert 0: insert into SKU (SKU_CODE, SKU_ID) values (?, ?)
17:52:49,846 DEBUG main entity.AbstractEntityPersister:2948 -  Update 0: update SKU set SKU_CODE=? where SKU_ID=?
17:52:49,846 DEBUG main entity.AbstractEntityPersister:2949 -  Delete 0: delete from SKU where SKU_ID=?
[snip]
more hibernate logs
[snip]
17:52:49,893 DEBUG main entity.EntityLoader:56 - Static select for action ACTION_REFRESH on entity com.maple.domain.inventory.Sku: select sku0_.SKU_ID as SKU1_4_0_, sku0_.SKU_CODE as SKU2_4_0_ from SKU sku0_ where sku0_.SKU_ID=?
17:52:49,893 DEBUG main impl.SessionFactoryObjectFactory:99 - registered: 2c998202296f0f5501296f0f71250001 (unnamed)
17:52:49,893  INFO main impl.SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured
17:52:49,893 DEBUG main impl.SessionFactoryImpl:378 - instantiated session factory
17:52:49,893 DEBUG main impl.SessionFactoryImpl:550 - Checking 0 named HQL queries
17:52:49,893 DEBUG main impl.SessionFactoryImpl:570 - Checking 0 named SQL queries
17:52:49,893 DEBUG main factory.DefaultIdentifierGeneratorFactory:99 - Registering IdentifierGenerator strategy [uuid] -> [class org.hibernate.id.UUIDHexGenerator]
[snip]
more hibernate logs
[snip]
17:52:49,924 DEBUG main factory.DefaultIdentifierGeneratorFactory:99 - Registering IdentifierGenerator strategy [enhanced-sequence] -> [class org.hibernate.id.enhanced.SequenceStyleGenerator]
17:52:49,924 DEBUG main factory.DefaultIdentifierGeneratorFactory:99 - Registering IdentifierGenerator strategy [enhanced-table] -> [class org.hibernate.id.enhanced.TableGenerator]
17:52:49,924  INFO main cfg.Configuration:1518 - configuring from resource: /hibernate.cfg.xml
17:52:49,940  INFO main cfg.Configuration:1495 - Configuration resource: /hibernate.cfg.xml
17:52:49,940 DEBUG main util.DTDEntityResolver:64 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
17:52:49,940 DEBUG main util.DTDEntityResolver:66 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
17:52:49,940 DEBUG main util.DTDEntityResolver:76 - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
17:52:49,971 DEBUG main cfg.Configuration:1479 - connection.driver_class=com.ibm.db2.jcc.DB2Driver
17:52:49,971 DEBUG main cfg.Configuration:1479 - connection.url=jdbc:db2://172.25.2.3:50000/SMKTST
17:52:49,971 DEBUG main cfg.Configuration:1479 - connection.username=db2admin
17:52:49,971 DEBUG main cfg.Configuration:1479 - connection.password=05Sep2008
17:52:49,971 DEBUG main cfg.Configuration:1479 - connection.pool_size=1
17:52:49,971 DEBUG main cfg.Configuration:1479 - default_schema=TEST
17:52:49,971 DEBUG main cfg.Configuration:1479 - current_session_context_class=thread
17:52:49,971 DEBUG main cfg.Configuration:1479 - cache.provider_class=org.hibernate.cache.NoCacheProvider
17:52:49,971 DEBUG main cfg.Configuration:1479 - show_sql=true
17:52:49,971 DEBUG main cfg.Configuration:1678 - null<-org.dom4j.tree.DefaultAttribute@1579a30 [Attribute: name resource value "Sku.hbm.xml"]
17:52:49,971  INFO main cfg.Configuration:655 - Reading mappings from resource : Sku.hbm.xml
17:52:49,971 DEBUG main util.DTDEntityResolver:64 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
17:52:49,971 DEBUG main util.DTDEntityResolver:66 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
17:52:49,971 DEBUG main util.DTDEntityResolver:76 - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
17:52:50,002  INFO main cfg.HbmBinder:348 - Mapping class: com.maple.domain.inventory.Sku -> SKU
17:52:50,002 DEBUG main cfg.HbmBinder:1335 - Mapped property: skuNumber -> SKU_ID
17:52:50,002 DEBUG main cfg.HbmBinder:1335 - Mapped property: skuCode -> SKU_CODE
17:52:50,002 DEBUG main cfg.Configuration:1678 - null<-org.dom4j.tree.DefaultAttribute@9aba32 [Attribute: name resource value "InventoryItem.hbm.xml"]
17:52:50,002  INFO main cfg.Configuration:655 - Reading mappings from resource : InventoryItem.hbm.xml
17:52:50,002 DEBUG main util.DTDEntityResolver:64 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
17:52:50,002 DEBUG main util.DTDEntityResolver:66 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
17:52:50,002 DEBUG main util.DTDEntityResolver:76 - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
17:52:50,034  INFO main cfg.HbmBinder:348 - Mapping class: com.maple.domain.inventory.InventoryItem -> INVENTORY_ITEM
17:52:50,034 DEBUG main cfg.HbmBinder:1335 - Mapped property: itemId -> INVENTORY_ID
17:52:50,034 DEBUG main cfg.HbmBinder:1335 - Mapped property: inventoryIn -> INVENTORY_IN
17:52:50,034 DEBUG main cfg.HbmBinder:1335 - Mapped property: inventoryOut -> INVENTORY_OUT
17:52:50,049  INFO main cfg.Configuration:1633 - Configured SessionFactory: null
17:52:50,049 DEBUG main cfg.Configuration:1634 - properties: {hibernate.connection.password=05Sep2008, java.runtime.name=Java(TM) SE Runtime Environment, hibernate.cache.provider_class=org.hibernate.cache.NoCacheProvider, hibernate.default_schema=TEST, sun.boot.library.path=C:\Program Files\Java\jre6\bin, java.vm.version=11.0-b16, hibernate.connection.username=db2admin, 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.java.launcher=SUN_STANDARD, sun.os.patch.level=Service Pack 3, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Devavrat\eclipseworkspaces\maple\Maple, java.runtime.version=1.6.0_11-b03, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, hibernate.current_session_context_class=thread, java.endorsed.dirs=C:\Program Files\Java\jre6\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\722679\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., cache.provider_class=org.hibernate.cache.NoCacheProvider, default_schema=TEST, user.variant=, os.name=Windows XP, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jre6\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jre6\bin\client;C:\Program Files\Java\jre6\bin;%M2%;C:\Program Files\CA\SC\CAWIN\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\Downloaded Program Files;C:\IBMTOOLS\Python22;C:\PROGRA~1\CA\SC\CAM\bin;C:\Program Files\CA\DSM\bin;C:\Program Files\Java\jdk1.5.0_15\bin;C:\Devavrat\software\Ant\apache-ant-1.7.1\bin;C:\Program Files\VisualSVN Server\bin;C:\Program Files\MySQL\MySQL Server 5.1\bin;, java.specification.name=Java Platform API Specification, java.class.version=50.0, hibernate.connection.pool_size=1, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, connection.password=05Sep2008, user.home=C:\Documents and Settings\722679, user.timezone=Asia/Calcutta, connection.username=db2admin, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.6, hibernate.connection.driver_class=com.ibm.db2.jcc.DB2Driver, show_sql=true, user.name=722679, java.class.path=C:\Devavrat\eclipseworkspaces\maple\Maple\bin;C:\eclipse\plugins\org.junit4_4.3.1\junit.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.asm-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.context-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.core-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.expression-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.beans-3.0.2.RELEASE.jar;C:\Devavrat\eclipseworkspaces\maple\Maple\src\main\resources;C:\Devavrat\software\db2\drivers\db2jcc_license_cu.jar;C:\Devavrat\software\db2\drivers\db2jcc.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\antlr-2.7.6.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\commons-collections-3.1.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\dom4j-1.6.1.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\javassist-3.9.0.GA.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\lib\required\jta-1.1.jar;C:\Devavrat\software\hibernate\hibernate-distribution-3.5.2-Final\hibernate3.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.orm-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.jdbc-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.transaction-3.0.2.RELEASE.jar;C:\Documents and Settings\722679\.m2\repository\commons-dbcp\commons-dbcp-1.4\commons-dbcp-1.4.jar;C:\Documents and Settings\722679\.m2\repository\commons-pool\commons-pool-1.5.4\commons-pool-1.5.4.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.aop-3.0.2.RELEASE.jar;C:\Devavrat\software\Spring\spring-framework-3.0.2.RELEASE\dist\org.springframework.aspects-3.0.2.RELEASE.jar;C:\Documents and Settings\722679\.m2\repository\aopalliance\aopalliance-alpha1.jar;C:\Documents and Settings\722679\.m2\repository\aopalliance\aopalliance.jar;C:\Devavrat\software\slf4j\slf4j-1.5.2\slf4j-api-1.5.2.jar;C:\Devavrat\software\slf4j\slf4j-1.5.2\slf4j-log4j12-1.5.2.jar;C:\dcm4chee-2.14.8-mysql\server\default\lib\log4j.jar;C:\Devavrat\software\slf4j\slf4j-1.5.2\jcl-over-slf4j-1.5.2.jar;/C:/eclipse/configuration/org.eclipse.osgi/bundles/191/1/.cp/;/C:/eclipse/configuration/org.eclipse.osgi/bundles/192/1/.cp/;/C:/eclipse/configuration/org.eclipse.osgi/bundles/190/1/.cp/, hibernate.bytecode.use_reflection_optimizer=false, hibernate.show_sql=true, current_session_context_class=thread, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jre6, sun.arch.data.model=32, hibernate.connection.url=jdbc:db2://172.25.2.3:50000/SMKTST, connection.pool_size=1, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, java.version=1.6.0_11, java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\classes, java.vendor=Sun Microsystems Inc., connection.driver_class=com.ibm.db2.jcc.DB2Driver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, connection.url=jdbc:db2://172.25.2.3:50000/SMKTST, sun.cpu.isalist=}
17:52:50,049 DEBUG main cfg.Configuration:1376 - Preparing to build session factory with filters : {}
17:52:50,049 DEBUG main cfg.Configuration:1211 - processing extends queue
17:52:50,049 DEBUG main cfg.Configuration:1215 - processing collection mappings
17:52:50,049 DEBUG main cfg.Configuration:1226 - processing native query and ResultSetMapping mappings
17:52:50,049 DEBUG main cfg.Configuration:1234 - processing association property references
17:52:50,049 DEBUG main cfg.Configuration:1256 - processing foreign key constraints
17:52:50,049  INFO main connection.DriverManagerConnectionProvider:64 - Using Hibernate built-in connection pool (not for production use!)
17:52:50,049  INFO main connection.DriverManagerConnectionProvider:65 - Hibernate connection pool size: 1
17:52:50,049  INFO main connection.DriverManagerConnectionProvider:68 - autocommit mode: false
17:52:50,049  INFO main connection.DriverManagerConnectionProvider:103 - using driver: com.ibm.db2.jcc.DB2Driver at URL: jdbc:db2://172.25.2.3:50000/SMKTST
17:52:50,049  INFO main connection.DriverManagerConnectionProvider:106 - connection properties: {user=db2admin, password=05Sep2008}
17:52:50,049 DEBUG main connection.DriverManagerConnectionProvider:132 - opening new JDBC connection
17:52:50,081 DEBUG main connection.DriverManagerConnectionProvider:138 - created connection to: jdbc:db2://172.25.2.3:50000/SMKTST, Isolation Level: 2
17:52:50,081  INFO main cfg.SettingsFactory:117 - RDBMS: DB2/NT, version: SQL09013
17:52:50,081  INFO main cfg.SettingsFactory:118 - JDBC driver: IBM DB2 JDBC Universal Driver Architecture, version: 3.50.152
17:52:50,081  INFO main dialect.Dialect:206 - Using dialect: org.hibernate.dialect.DB2Dialect
17:52:50,081  INFO main jdbc.JdbcSupportLoader:79 - Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
17:52:50,081  INFO main transaction.TransactionFactoryFactory:59 - Using default transaction strategy (direct JDBC transactions)
17:52:50,096  INFO main transaction.TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
17:52:50,096  INFO main cfg.SettingsFactory:169 - Automatic flush during beforeCompletion(): disabled
17:52:50,096  INFO main cfg.SettingsFactory:173 - Automatic session close at end of transaction: disabled
17:52:50,096  INFO main cfg.SettingsFactory:188 - Scrollable result sets: enabled
17:52:50,096 DEBUG main cfg.SettingsFactory:192 - Wrap result sets: disabled
17:52:50,096  INFO main cfg.SettingsFactory:196 - JDBC3 getGeneratedKeys(): enabled
17:52:50,096  INFO main cfg.SettingsFactory:204 - Connection release mode: auto
17:52:50,096  INFO main cfg.SettingsFactory:222 - Default schema: TEST
17:52:50,096  INFO main cfg.SettingsFactory:231 - Default batch fetch size: 1
17:52:50,096  INFO main cfg.SettingsFactory:235 - Generate SQL with comments: disabled
17:52:50,096  INFO main cfg.SettingsFactory:239 - Order SQL updates by primary key: disabled
17:52:50,096  INFO main cfg.SettingsFactory:243 - Order SQL inserts for batching: disabled
17:52:50,096  INFO main cfg.SettingsFactory:410 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:52:50,096  INFO main ast.ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
17:52:50,096  INFO main cfg.SettingsFactory:251 - Query language substitutions: {}
17:52:50,096  INFO main cfg.SettingsFactory:256 - JPA-QL strict compliance: disabled
17:52:50,096  INFO main cfg.SettingsFactory:261 - Second-level cache: enabled
17:52:50,096  INFO main cfg.SettingsFactory:265 - Query cache: disabled
17:52:50,112  INFO main cfg.SettingsFactory:395 - Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
17:52:50,112  INFO main bridge.RegionFactoryCacheProviderBridge:61 - Cache provider: org.hibernate.cache.NoCacheProvider
17:52:50,112  INFO main cfg.SettingsFactory:275 - Optimize cache for minimal puts: disabled
17:52:50,112  INFO main cfg.SettingsFactory:284 - Structured second-level cache entries: disabled
17:52:50,112  INFO main cfg.SettingsFactory:304 - Echoing all SQL to stdout
17:52:50,112  INFO main cfg.SettingsFactory:313 - Statistics: disabled
17:52:50,112  INFO main cfg.SettingsFactory:317 - Deleted entity synthetic identifier rollback: disabled
17:52:50,112  INFO main cfg.SettingsFactory:332 - Default entity-mode: pojo
17:52:50,112  INFO main cfg.SettingsFactory:336 - Named query checking : enabled
17:52:50,112  INFO main cfg.SettingsFactory:340 - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
17:52:50,127  INFO main impl.SessionFactoryImpl:199 - building session factory
17:52:50,127 DEBUG main impl.SessionFactoryImpl:238 - Session factory constructed with filter configurations : {}
17:52:50,127 DEBUG main impl.SessionFactoryImpl:242 - instantiating session factory with properties: {java.runtime.name=Java(TM) SE
[snip]
environment info
[snip]
sun.desktop=windows, connection.url=jdbc:db2://172.25.2.3:50000/SMKTST, sun.cpu.isalist=}
17:52:50,127 DEBUG main factory.DefaultIdentifierGeneratorFactory:89 - Setting dialect [org.hibernate.dialect.DB2Dialect]
17:52:50,127 DEBUG main factory.DefaultIdentifierGeneratorFactory:89 - Setting dialect [org.hibernate.dialect.DB2Dialect]
17:52:50,127 DEBUG main entity.AbstractEntityPersister:2936 - Static SQL for entity: com.maple.domain.inventory.InventoryItem
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2941 -  Version select: select INVENTORY_ID from TEST.INVENTORY_ITEM where INVENTORY_ID =?
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2944 -  Snapshot select: select inventoryi_.INVENTORY_ID, inventoryi_.INVENTORY_IN as INVENTORY2_9_, inventoryi_.INVENTORY_OUT as INVENTORY3_9_ from TEST.INVENTORY_ITEM inventoryi_ where inventoryi_.INVENTORY_ID=?
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2947 -  Insert 0: insert into TEST.INVENTORY_ITEM (INVENTORY_IN, INVENTORY_OUT, INVENTORY_ID) values (?, ?, ?)
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2948 -  Update 0: update TEST.INVENTORY_ITEM set INVENTORY_IN=?, INVENTORY_OUT=? where INVENTORY_ID=?
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2949 -  Delete 0: delete from TEST.INVENTORY_ITEM where INVENTORY_ID=?
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2936 - Static SQL for entity: com.maple.domain.inventory.Sku
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2941 -  Version select: select SKU_ID from TEST.SKU where SKU_ID =?
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2944 -  Snapshot select: select sku_.SKU_ID, sku_.SKU_CODE as SKU2_8_ from TEST.SKU sku_ where sku_.SKU_ID=?
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2947 -  Insert 0: insert into TEST.SKU (SKU_CODE, SKU_ID) values (?, ?)
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2948 -  Update 0: update TEST.SKU set SKU_CODE=? where SKU_ID=?
17:52:50,143 DEBUG main entity.AbstractEntityPersister:2949 -  Delete 0: delete from TEST.SKU where SKU_ID=?
17:52:50,143 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.InventoryItem [NONE]: select inventoryi0_.INVENTORY_ID as INVENTORY1_9_0_, inventoryi0_.INVENTORY_IN as INVENTORY2_9_0_, inventoryi0_.INVENTORY_OUT as INVENTORY3_9_0_ from TEST.INVENTORY_ITEM inventoryi0_ where inventoryi0_.INVENTORY_ID=?
[snip]
more hibernate logs
[snip]
17:52:50,159 DEBUG main entity.EntityLoader:56 - Static select for action ACTION_REFRESH on entity com.maple.domain.inventory.InventoryItem: select inventoryi0_.INVENTORY_ID as INVENTORY1_9_0_, inventoryi0_.INVENTORY_IN as INVENTORY2_9_0_, inventoryi0_.INVENTORY_OUT as INVENTORY3_9_0_ from TEST.INVENTORY_ITEM inventoryi0_ where inventoryi0_.INVENTORY_ID=?
17:52:50,159 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [NONE]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=?
17:52:50,159 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [READ]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=?
17:52:50,159 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [UPGRADE]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:50,159 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [UPGRADE_NOWAIT]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:50,174 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [FORCE]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:50,174 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [PESSIMISTIC_READ]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:50,174 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [PESSIMISTIC_WRITE]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:50,174 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [PESSIMISTIC_FORCE_INCREMENT]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=? for read only with rs
17:52:50,174 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [OPTIMISTIC]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=?
17:52:50,174 DEBUG main entity.EntityLoader:124 - Static select for entity com.maple.domain.inventory.Sku [OPTIMISTIC_FORCE_INCREMENT]: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=?
17:52:50,174 DEBUG main entity.EntityLoader:56 - Static select for action ACTION_MERGE on entity com.maple.domain.inventory.Sku: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=?
17:52:50,205 DEBUG main entity.EntityLoader:56 - Static select for action ACTION_REFRESH on entity com.maple.domain.inventory.Sku: select sku0_.SKU_ID as SKU1_8_0_, sku0_.SKU_CODE as SKU2_8_0_ from TEST.SKU sku0_ where sku0_.SKU_ID=?
17:52:50,205 DEBUG main impl.SessionFactoryObjectFactory:99 - registered: 2c998202296f0f5501296f0f725d0002 (unnamed)
17:52:50,205  INFO main impl.SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured
17:52:50,205 DEBUG main impl.SessionFactoryImpl:378 - instantiated session factory
17:52:50,221 DEBUG main impl.SessionFactoryImpl:550 - Checking 0 named HQL queries
17:52:50,221 DEBUG main impl.SessionFactoryImpl:570 - Checking 0 named SQL queries
17:52:50,330 DEBUG main impl.SessionImpl:257 - opened session at timestamp: 12774685702
17:52:50,424 DEBUG main transaction.JDBCTransaction:82 - begin
17:52:50,424 DEBUG main jdbc.ConnectionManager:444 - opening JDBC connection
17:52:50,424 DEBUG main transaction.JDBCTransaction:87 - current autocommit status: false
17:52:50,424 DEBUG main transaction.JDBCTransaction:134 - commit
17:52:50,424 DEBUG main transaction.JDBCTransaction:147 - committed JDBC Connection
17:52:50,424 DEBUG main jdbc.ConnectionManager:427 - aggressively releasing JDBC connection
17:52:50,424 DEBUG main jdbc.ConnectionManager:464 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
17:52:50,424 DEBUG main util.JDBCExceptionReporter:69 - SQL Warning
com.ibm.db2.jcc.b.SqlWarning: DB2 SQL Warning: SQLCODE=0, SQLSTATE=     , SQLERRMC=1;1208;DB2ADMIN;SMKTST;QDB2/NT;2499;2499;0;1208;0;, DRIVER=3.50.152
   at com.ibm.db2.jcc.b.wc.b(wc.java:163)
   at com.ibm.db2.jcc.b.wc.b(wc.java:232)
   at com.ibm.db2.jcc.b.eb.a(eb.java:3607)
   at com.ibm.db2.jcc.t4.bb.l(bb.java:403)
   at com.ibm.db2.jcc.t4.bb.d(bb.java:141)
   at com.ibm.db2.jcc.t4.b.Dc(b.java:1383)
   at com.ibm.db2.jcc.t4.b.b(b.java:1307)
   at com.ibm.db2.jcc.t4.b.s(b.java:1022)
   at com.ibm.db2.jcc.t4.b.c(b.java:632)
   at com.ibm.db2.jcc.t4.b.b(b.java:618)
   at com.ibm.db2.jcc.t4.b.a(b.java:360)
   at com.ibm.db2.jcc.t4.b.<init>(b.java:298)
   at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:193)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at java.sql.DriverManager.getConnection(Unknown Source)
   at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
   at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:114)
   at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)
   at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)
   at com.maple.domain.inventory.TestInventoryItem.testHibernate(TestInventoryItem.java:40)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
   at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
   at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
   at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
   at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
   at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
   at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
   at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
   at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
   at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
   at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
   at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
   at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
17:52:50,440  WARN main util.JDBCExceptionReporter:77 - SQL Warning: 0, SQLState:     
17:52:50,440  WARN main util.JDBCExceptionReporter:78 - DB2 SQL Warning: SQLCODE=0, SQLSTATE=     , SQLERRMC=1;1208;DB2ADMIN;SMKTST;QDB2/NT;2499;2499;0;1208;0;, DRIVER=3.50.152


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

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.