-->
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.  [ 2 posts ] 
Author Message
 Post subject: Direct JDBC updates not saved in Hibernate 3.1
PostPosted: Thu Jan 12, 2006 2:12 pm 
Newbie

Joined: Wed Jan 11, 2006 5:50 pm
Posts: 2
This simple example works using Hibernate 3.0.5 but if I use Hibernate 3.1, the change does not get saved to the database.

Does this need to be coded differently in 3.1 or should this still work? In both cases, I'm using the default JDBC transaction strategy.


Code:
      Configuration stgCfg = new Configuration();
     
      SessionFactory stgSF = stgCfg.buildSessionFactory();
      Session s = stgSF.openSession();
     
      Connection connection = s.connection();   
     
      Transaction tx = null;
      try {
         
         Statement stmt = connection.createStatement();
         
         tx = s.beginTransaction();
         
         stmt.execute("update STG_WORKFLOW_STATUS " +
                      " set status = 'SHUTDOWN' " +
                      " where SOURCE_TYPE = 'GR_CC' " +
                      "   and WORKFLOW_TYPE = 'LOAD'");
         
         tx.commit();
         
         stmt.close();

      }
      catch (Exception e) {
         if (tx != null) tx.rollback();
         e.printStackTrace();
      }
      finally {
         s.close();
      }



Debug level Hibernate 3.0.5 log excerpt:

16:06:23,000 INFO Environment:464 - Hibernate 3.0.5
16:06:23,016 INFO Environment:482 - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, hibernate.default_schema=CHRISH_72_DATA, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=1, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=CHRISH_72_DATA, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:oracle:thin:@pbr:1521:pbr, hibernate.show_sql=true, hibernate.connection.password=****, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=1}
16:06:23,031 INFO Environment:509 - using java.io streams to persist binary types
16:06:23,031 INFO Environment:510 - using CGLIB reflection optimizer
16:06:23,031 INFO Environment:540 - using JDK 1.4 java.sql.Timestamp handling
16:06:23,188 DEBUG Configuration:998 - Preparing to build session factory with filters : {}
16:06:23,188 INFO Configuration:875 - processing extends queue
16:06:23,188 INFO Configuration:879 - processing collection mappings
16:06:23,188 INFO Configuration:888 - processing association property references
16:06:23,188 INFO Configuration:917 - processing foreign key constraints
16:06:23,203 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
16:06:23,219 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
16:06:23,219 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
16:06:23,359 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@highland:1521:highland
16:06:23,359 INFO DriverManagerConnectionProvider:83 - connection properties: {user=CHRISH_72_DATA, password=CHRISH_72_DATA}
16:06:23,359 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
16:06:23,359 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
16:06:23,969 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:oracle:thin:@highland:1521:highland, Isolation Level: 2
16:06:23,984 DEBUG SettingsFactory:295 - could not get database version from JDBC metadata
16:06:23,984 INFO SettingsFactory:77 - RDBMS: Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
16:06:23,984 INFO SettingsFactory:78 - JDBC driver: Oracle JDBC driver, version: 9.2.0.1.0
16:06:24,000 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
16:06:24,047 INFO Dialect:92 - Using dialect: org.hibernate.dialect.Oracle9Dialect
16:06:24,141 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
16:06:24,156 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
16:06:24,156 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
16:06:24,156 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
16:06:24,156 INFO SettingsFactory:136 - JDBC batch size: 15
16:06:24,156 INFO SettingsFactory:139 - JDBC batch updates for versioned data: enabled
16:06:24,156 INFO SettingsFactory:144 - Scrollable result sets: enabled
16:06:24,172 DEBUG SettingsFactory:148 - Wrap result sets: disabled
16:06:24,172 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
16:06:24,172 INFO SettingsFactory:160 - Connection release mode: null
16:06:24,172 INFO SettingsFactory:178 - Default schema: CHRISH_72_DATA
16:06:24,172 INFO SettingsFactory:184 - Maximum outer join fetch depth: 1
16:06:24,172 INFO SettingsFactory:187 - Default batch fetch size: 1
16:06:24,172 INFO SettingsFactory:191 - Generate SQL with comments: disabled
16:06:24,172 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
16:06:24,172 INFO SettingsFactory:334 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
16:06:24,172 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
16:06:24,172 INFO SettingsFactory:203 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
16:06:24,172 INFO SettingsFactory:209 - Second-level cache: enabled
16:06:24,172 INFO SettingsFactory:213 - Query cache: disabled
16:06:24,188 INFO SettingsFactory:321 - Cache provider: org.hibernate.cache.HashtableCacheProvider
16:06:24,188 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
16:06:24,188 INFO SettingsFactory:233 - Cache region prefix: hibernate.test
16:06:24,188 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
16:06:24,188 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
16:06:24,203 INFO SettingsFactory:257 - Echoing all SQL to stdout
16:06:24,203 INFO SettingsFactory:261 - Statistics: disabled
16:06:24,203 INFO SettingsFactory:265 - Deleted entity synthetic identifier rollback: disabled
16:06:24,203 INFO SettingsFactory:279 - Default entity-mode: pojo
16:06:24,406 INFO SessionFactoryImpl:152 - building session factory
16:06:24,406 DEBUG SessionFactoryImpl:161 - Session factory constructed with filter configurations : {}
16:06:24,406 DEBUG SessionFactoryImpl:164 - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=CHRISH_72_DATA, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_04\jre\bin, hibernate.default_schema=CHRISH_72_DATA, java.vm.version=1.5.0_04-b05, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=CHRISH_72_DATA, 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 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\GIM_JAVA\workspace\GIM, java.runtime.version=1.5.0_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\CWHAMI~1.CAM\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, hibernate.jdbc.batch_versioned_data=true, hibernate.cache.region_prefix=hibernate.test, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_04\bin;.;C:\WINNT\system32;C:\WINNT;c:\ant\bin;c:\jdk1.4.2\bin;C:\oracle\ora90\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;c:\WebSphereCCD\bin;C:\WSStudio\runtimes\base_v5\bin;C:\Program Files\IBM\WebSphere MQ\Java\bin;C:/Program Files/IBM/WebSphere MQ/WEMPS\bin;c:\websphereccd\jre\bin\server;c:\csatk\bin;C:\CSEB\BIN;C:\CSEB\DLL;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\IBM\WebSphere MQ\WEMPS\bin;C:\PROGRA~1\IBM\IMNNQ;C:\tools\clearcase\ClearCase\bin;C:\tools\clearcase\common;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\db2\SQLLIB\BIN;C:\db2\SQLLIB\FUNCTION;C:\db2\SQLLIB\SAMPLES\REPL;C:\CSATK\BIN;C:\CSEB\BIN;C:\CSEB\DLL, java.specification.name=Java Platform API Specification, java.class.version=49.0, hibernate.connection.pool_size=1, sun.management.compiler=HotSpot Client Compiler, os.version=5.0, user.home=C:\Documents and Settings\cwhamilt.CAMELOT, user.timezone=America/New_York, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, java.class.path=C:\GIM_JAVA\workspace\GIM;C:\oracle\ora90\jdbc\lib\classes12.jar;C:\db2\SQLLIB\java\db2java.zip;C:\hibernate-3.1\lib\xml-apis.jar;C:\hibernate-3.1\lib\asm.jar;C:\hibernate-3.1\lib\cglib-2.1.2.jar;C:\hibernate-3.1\lib\commons-collections-2.1.1.jar;C:\hibernate-3.1\lib\commons-logging-1.0.4.jar;C:\hibernate-3.1\lib\dom4j-1.6.1.jar;C:\hibernate-3.1\lib\jta.jar;C:\hibernate-3.1\lib\antlr-2.7.5H3.jar;C:\hibernate-3.1\lib\asm-attrs.jar;C:\GIM_JAVA\eclipse\plugins\org.junit_3.8.1\junit.jar;C:\dbunit-2.1\dbunit-2.1.jar;C:\Business Objects\ext\lib\xerces.jar;C:\Business Objects\ext\lib\axis.jar;C:\Business Objects\ext\lib\jaxrpc.jar;C:\Business Objects\ext\lib\saaj.jar;C:\Business Objects\ext\lib\commons-discovery.jar;C:\gcti\GIM_ETL\lib\tkv.jar;C:\gcti\GIM_ETL\lib\log4j.jar;C:\gcti\GIM_ETL\lib\commonlib.jar;C:\gcti\GIM_ETL\lib\flexlm.jar;C:\gcti\GIM_ETL\lib\gml.jar;C:\gcti\GIM_ETL\lib\license.jar;C:\gcti\GIM_ETL\lib\cfglib.jar;C:\SQLServerJDBC\lib\msbase.jar;C:\SQLServerJDBC\lib\msutil.jar;C:\SQLServerJDBC\lib\mssqlserver.jar;C:\hibernate-3.0\lib\log4j-1.2.9.jar;C:\hibernate-3.0\hibernate3.jar, user.name=cwhamilt, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\Program Files\Java\jdk1.5.0_04\jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, hibernate.connection.url=jdbc:oracle:thin:@highland:1521:highland, 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, hibernate.jdbc.use_streams_for_binary=true, java.version=1.5.0_04, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_04\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_04\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, hibernate.max_fetch_depth=1, sun.desktop=windows, sun.cpu.isalist=}
16:06:24,641 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
16:06:24,641 DEBUG SessionFactoryObjectFactory:76 - registered: 4028a40608bb4a710108bb4a73010000 (unnamed)
16:06:24,641 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
16:06:24,641 DEBUG SessionFactoryImpl:262 - instantiated session factory
16:06:24,641 INFO SessionFactoryImpl:379 - Checking 0 named queries
16:06:24,719 DEBUG SessionImpl:250 - opened session at timestamp: 4657207642689536
16:06:24,719 DEBUG ConnectionManager:296 - opening JDBC connection
16:06:24,719 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
16:06:24,719 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
16:06:24,719 DEBUG JDBCTransaction:46 - begin
16:06:24,719 DEBUG JDBCTransaction:50 - current autocommit status: false
16:06:24,719 DEBUG JDBCTransaction:83 - commit
16:06:24,719 DEBUG SessionImpl:323 - automatically flushing session
16:06:24,719 DEBUG JDBCContext:278 - before transaction completion
16:06:24,719 DEBUG SessionImpl:372 - before transaction completion
16:06:24,734 DEBUG JDBCTransaction:96 - committed JDBC Connection
16:06:24,734 DEBUG JDBCContext:283 - after transaction completion
16:06:24,734 DEBUG SessionImpl:403 - after transaction completion
16:06:24,734 DEBUG SessionImpl:269 - closing session
16:06:24,734 DEBUG ConnectionManager:317 - closing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
16:06:24,734 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
16:06:24,734 DEBUG JDBCContext:283 - after transaction completion
16:06:24,734 DEBUG SessionImpl:403 - after transaction completion




Debug level Hibernate 3.1 log excerpt:

16:04:26,516 INFO Environment:479 - Hibernate 3.1
16:04:26,548 INFO Environment:524 - using java.io streams to persist binary types
16:04:26,548 INFO Environment:525 - using CGLIB reflection optimizer
16:04:26,548 INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
16:04:26,720 DEBUG Configuration:1145 - Preparing to build session factory with filters : {}
16:04:26,720 INFO Configuration:1022 - processing extends queue
16:04:26,720 INFO Configuration:1026 - processing collection mappings
16:04:26,720 INFO Configuration:1035 - processing association property references
16:04:26,720 INFO Configuration:1057 - processing foreign key constraints
16:04:26,735 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
16:04:26,751 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
16:04:26,751 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
16:04:26,923 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@highland:1521:highland
16:04:26,923 INFO DriverManagerConnectionProvider:83 - connection properties: {user=CHRISH_72_DATA, password=CHRISH_72_DATA}
16:04:26,923 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
16:04:26,923 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
16:04:27,532 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:oracle:thin:@highland:1521:highland, Isolation Level: 2
16:04:27,563 DEBUG SettingsFactory:299 - could not get database version from JDBC metadata
16:04:27,563 INFO SettingsFactory:77 - RDBMS: Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
16:04:27,563 INFO SettingsFactory:78 - JDBC driver: Oracle JDBC driver, version: 9.2.0.1.0
16:04:27,563 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
16:04:27,610 INFO Dialect:103 - Using dialect: org.hibernate.dialect.Oracle9Dialect
16:04:27,720 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
16:04:27,735 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
16:04:27,735 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
16:04:27,735 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
16:04:27,735 INFO SettingsFactory:136 - JDBC batch size: 15
16:04:27,735 INFO SettingsFactory:139 - JDBC batch updates for versioned data: enabled
16:04:27,735 INFO SettingsFactory:144 - Scrollable result sets: enabled
16:04:27,735 DEBUG SettingsFactory:148 - Wrap result sets: disabled
16:04:27,735 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
16:04:27,735 INFO SettingsFactory:160 - Connection release mode: auto
16:04:27,735 INFO SettingsFactory:178 - Default schema: CHRISH_72_DATA
16:04:27,751 INFO SettingsFactory:184 - Maximum outer join fetch depth: 1
16:04:27,751 INFO SettingsFactory:187 - Default batch fetch size: 1
16:04:27,751 INFO SettingsFactory:191 - Generate SQL with comments: disabled
16:04:27,751 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
16:04:27,751 INFO SettingsFactory:338 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
16:04:27,751 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
16:04:27,751 INFO SettingsFactory:203 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
16:04:27,751 INFO SettingsFactory:209 - Second-level cache: enabled
16:04:27,751 INFO SettingsFactory:213 - Query cache: disabled
16:04:27,751 INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.HashtableCacheProvider
16:04:27,766 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
16:04:27,766 INFO SettingsFactory:233 - Cache region prefix: hibernate.test
16:04:27,766 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
16:04:27,766 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
16:04:27,766 INFO SettingsFactory:257 - Echoing all SQL to stdout
16:04:27,782 INFO SettingsFactory:264 - Statistics: disabled
16:04:27,782 INFO SettingsFactory:268 - Deleted entity synthetic identifier rollback: disabled
16:04:27,782 INFO SettingsFactory:283 - Default entity-mode: pojo
16:04:27,845 INFO SessionFactoryImpl:153 - building session factory
16:04:27,845 DEBUG SessionFactoryImpl:164 - Session factory constructed with filter configurations : {}
16:04:27,845 DEBUG SessionFactoryImpl:167 - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.connection.password=CHRISH_72_DATA, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, sun.boot.library.path=C:\Program Files\Java\jdk1.5.0_04\jre\bin, hibernate.default_schema=CHRISH_72_DATA, java.vm.version=1.5.0_04-b05, hibernate.proxool.pool_alias=pool1, hibernate.connection.username=CHRISH_72_DATA, 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 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\GIM_JAVA\workspace\GIM, java.runtime.version=1.5.0_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\CWHAMI~1.CAM\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, hibernate.jdbc.batch_versioned_data=true, hibernate.cache.region_prefix=hibernate.test, sun.jnu.encoding=Cp1252, java.library.path=C:\Program Files\Java\jdk1.5.0_04\bin;.;C:\WINNT\system32;C:\WINNT;c:\ant\bin;c:\jdk1.4.2\bin;C:\oracle\ora90\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;c:\WebSphereCCD\bin;C:\WSStudio\runtimes\base_v5\bin;C:\Program Files\IBM\WebSphere MQ\Java\bin;C:/Program Files/IBM/WebSphere MQ/WEMPS\bin;c:\websphereccd\jre\bin\server;c:\csatk\bin;C:\CSEB\BIN;C:\CSEB\DLL;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\IBM\WebSphere MQ\WEMPS\bin;C:\PROGRA~1\IBM\IMNNQ;C:\tools\clearcase\ClearCase\bin;C:\tools\clearcase\common;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\db2\SQLLIB\BIN;C:\db2\SQLLIB\FUNCTION;C:\db2\SQLLIB\SAMPLES\REPL;C:\CSATK\BIN;C:\CSEB\BIN;C:\CSEB\DLL, java.specification.name=Java Platform API Specification, java.class.version=49.0, hibernate.connection.pool_size=1, sun.management.compiler=HotSpot Client Compiler, os.version=5.0, user.home=C:\Documents and Settings\cwhamilt.CAMELOT, user.timezone=America/New_York, java.awt.printerjob=sun.awt.windows.WPrinterJob, java.specification.version=1.5, file.encoding=Cp1252, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, user.name=cwhamilt, java.class.path=C:\GIM_JAVA\workspace\GIM;C:\oracle\ora90\jdbc\lib\classes12.jar;C:\db2\SQLLIB\java\db2java.zip;C:\hibernate-3.1\lib\xml-apis.jar;C:\hibernate-3.1\lib\asm.jar;C:\hibernate-3.1\lib\cglib-2.1.2.jar;C:\hibernate-3.1\lib\commons-collections-2.1.1.jar;C:\hibernate-3.1\lib\commons-logging-1.0.4.jar;C:\hibernate-3.1\lib\dom4j-1.6.1.jar;C:\hibernate-3.1\lib\jta.jar;C:\hibernate-3.1\lib\antlr-2.7.5H3.jar;C:\hibernate-3.1\lib\asm-attrs.jar;C:\GIM_JAVA\eclipse\plugins\org.junit_3.8.1\junit.jar;C:\dbunit-2.1\dbunit-2.1.jar;C:\Business Objects\ext\lib\xerces.jar;C:\Business Objects\ext\lib\axis.jar;C:\Business Objects\ext\lib\jaxrpc.jar;C:\Business Objects\ext\lib\saaj.jar;C:\Business Objects\ext\lib\commons-discovery.jar;C:\gcti\GIM_ETL\lib\tkv.jar;C:\gcti\GIM_ETL\lib\log4j.jar;C:\gcti\GIM_ETL\lib\commonlib.jar;C:\gcti\GIM_ETL\lib\flexlm.jar;C:\gcti\GIM_ETL\lib\gml.jar;C:\gcti\GIM_ETL\lib\license.jar;C:\gcti\GIM_ETL\lib\cfglib.jar;C:\SQLServerJDBC\lib\msbase.jar;C:\SQLServerJDBC\lib\msutil.jar;C:\SQLServerJDBC\lib\mssqlserver.jar;C:\hibernate-3.1\hibernate3.jar;C:\hibernate-3.0\lib\log4j-1.2.9.jar, hibernate.show_sql=true, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=C:\Program Files\Java\jdk1.5.0_04\jre, hibernate.connection.url=jdbc:oracle:thin:@highland:1521:highland, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, java.specification.vendor=Sun Microsystems Inc., user.language=en, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, hibernate.cglib.use_reflection_optimizer=true, java.version=1.5.0_04, hibernate.jdbc.use_streams_for_binary=true, java.ext.dirs=C:\Program Files\Java\jdk1.5.0_04\jre\lib\ext, sun.boot.class.path=C:\Program Files\Java\jdk1.5.0_04\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_04\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, sun.desktop=windows, hibernate.max_fetch_depth=1, sun.cpu.isalist=}
16:04:28,001 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
16:04:28,001 DEBUG SessionFactoryObjectFactory:76 - registered: 4028a40608bb48aa0108bb48ab510000 (unnamed)
16:04:28,001 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
16:04:28,001 DEBUG SessionFactoryImpl:292 - instantiated session factory
16:04:28,001 INFO SessionFactoryImpl:353 - Checking 0 named HQL queries
16:04:28,001 INFO SessionFactoryImpl:373 - Checking 0 named SQL queries
16:04:28,079 DEBUG SessionImpl:272 - opened session at timestamp: 4657207164932096
16:04:28,095 DEBUG JDBCContext:115 - opening user JDBC connection, application must close it
16:04:28,095 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
16:04:28,095 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
16:04:28,095 DEBUG JDBCTransaction:54 - begin
16:04:28,095 DEBUG ConnectionManager:313 - opening JDBC connection
16:04:28,095 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 1
16:04:28,095 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
16:04:28,157 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:oracle:thin:@highland:1521:highland, Isolation Level: 2
16:04:28,157 DEBUG JDBCTransaction:59 - current autocommit status: false
16:04:28,157 DEBUG JDBCContext:202 - after transaction begin
16:04:28,157 DEBUG JDBCTransaction:103 - commit
16:04:28,157 DEBUG SessionImpl:352 - automatically flushing session
16:04:28,157 DEBUG JDBCContext:193 - before transaction completion
16:04:28,157 DEBUG SessionImpl:404 - before transaction completion
16:04:28,157 DEBUG JDBCTransaction:116 - committed JDBC Connection
16:04:28,173 DEBUG JDBCContext:207 - after transaction completion
16:04:28,173 DEBUG ConnectionManager:296 - aggressively releasing JDBC connection
16:04:28,173 DEBUG ConnectionManager:333 - closing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
16:04:28,173 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
16:04:28,173 DEBUG SessionImpl:434 - after transaction completion
16:04:28,173 DEBUG SessionImpl:296 - closing session
16:04:28,188 DEBUG ConnectionManager:267 - connection already null in cleanup : no action


Top
 Profile  
 
 Post subject: It works if done 3.1 style....
PostPosted: Fri Jan 13, 2006 11:29 am 
Newbie

Joined: Wed Jan 11, 2006 5:50 pm
Posts: 2
Rewriting the example to use the 3.1 current session idiom and adding

hibernate.current_session_context_class thread

to the hibernate.properties file works.

Was breaking the 3.0.5 pattern an unintended side effect of the changes in transaction handling for 3.1?

Code:
      Configuration stgCfg = new Configuration();
     
      SessionFactory stgSF = stgCfg.buildSessionFactory(); 
     
      try {
         
         stgSF.getCurrentSession().beginTransaction();
         
         Connection connection = stgSF.getCurrentSession().connection();
         Statement stmt = connection.createStatement();
         
         stmt.executeUpdate("update STG_WORKFLOW_STATUS " +
                            " set status = 'SHUTDOWN' " +
                            " where SOURCE_TYPE = 'GR_CC' " +
                            "   and WORKFLOW_TYPE = 'LOAD'");
                 
         stgSF.getCurrentSession().getTransaction().commit();
         
         stmt.close();

      }
      catch (Exception e) {
         stgSF.getCurrentSession().getTransaction().rollback();
         e.printStackTrace();
      }


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