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

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 
  Previous topic | Next topic 
Author Message
offby1
 Post subject: UnsupportedOperationException using WebSphere CMT in WAS6.1
PostPosted: Sat May 19, 2007 6:14 pm 
Newbie

Joined: Sat May 19, 2007 5:02 pm
Posts: 5
Hibernate version: 3.2.3

Mapping documents: Probably not relevant; I can attach them to a subsequent message if requested

Code between sessionFactory.openSession() and session.close(): It's complicated: see below

Full stack trace of any exception that occurs: attached

Name and version of the database you are using: Oracle9i

The generated SQL (show_sql=true): attached

Debug level Hibernate log excerpt: attached-ish

Here's the setup: WebSphere appserver 6.1.0.5, running on Linux. Our application includes hibernate 3.2.3 (just the basics; no caching, for example) configured partially by a hibernate config file (below) and partially through code (I programmatically add the entities that are managed. I doubt that entities are relevant to this, so I've elected to leave them out, but I'm open to posting the details if need be).

During what should be a basic operation (inserting a new entity in the DB) I get an UnsupportedOperationException coming out of the transaction manager, like so (full trace is below):
Quote:
WTRN0074E: Exception caught from before_completion synchronization operation: java.lang.UnsupportedOperationException
at org.hibernate.transaction.WebSphereExtendedJTATransactionLookup$TransactionManagerAdapter$TransactionAdapter.setRollbackOnly(WebSphereExtendedJTATransactionLookup.java:211)


So, what am I doing wrong?

First, the code that's doing the addition. The two identical calls to findbydocumentid are because there is a document lookup occurring in two contexts, but the code is a bit oddly laid out and so I could not copy/paste it here.

Code:
        DsmDocumentValue document = findByDocumentId (documentId);                                                                                                                                                                         
        document = findByDocumentId (documentId);                                                                                                                                                                         
                                                                                                                                                                                                                                                    if (document == null) {                                                                                                                                                                                                             
            throw new InvalidDataErrorException ("Attempting to add an event to a non-existent document " + documentId);                                                                                                                                                                             
        }                                                                                                                                                                                                                                   
                                                                                                                                                                                                                                                   validateEvent (document, event);                                                                                                                                                                                                   
        document.addEvent (event);                                                                                                                                                                                                         
        session.save (document);


The segment of the WebSphere SystemOut.log file from hibernate init to the error in question:
Code:
======= MARK =======
[5/19/07 14:55:37:039 GMT-07:00] 00000024 Environment   I org.hibernate.cfg.Environment <clinit> Hibernate 3.2.3
[5/19/07 14:55:37:053 GMT-07:00] 00000024 Environment   I org.hibernate.cfg.Environment <clinit> loaded properties from resource hibernate.properties: {hibernate.bytecode.use_reflection_optimizer=false}
[5/19/07 14:55:37:065 GMT-07:00] 00000024 Environment   I org.hibernate.cfg.Environment buildBytecodeProvider Bytecode provider name : cglib
[5/19/07 14:55:37:078 GMT-07:00] 00000024 Environment   I org.hibernate.cfg.Environment <clinit> using JDK 1.4 java.sql.Timestamp handling
[5/19/07 14:55:37:156 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration configure configuring from url: wsjar:file:/opt/IBM/WAS61/AppServer/profiles/Ecourier38/installedApps/gigerNode02Cell/crjupdsm_e-Courier.ear/ecasIssuerOptions.jar!/ecourier_hibernate.cfg.xml
[5/19/07 14:55:37:236 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration doConfigure Configured SessionFactory: null
[5/19/07 14:55:37:256 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addClass Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmDocumentEventValue.hbm.xml
[5/19/07 14:55:37:266 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addResource Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmDocumentEventValue.hbm.xml
[5/19/07 14:55:37:329 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues Mapping class: com.aciworldwide.ecourier.dsmv2.data.DsmDocumentEventValue -> dsm_document_event
[5/19/07 14:55:37:394 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addClass Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmDocumentValue.hbm.xml
[5/19/07 14:55:37:402 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addResource Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmDocumentValue.hbm.xml
[5/19/07 14:55:37:437 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues Mapping class: com.aciworldwide.ecourier.dsmv2.data.DsmDocumentValue -> dsm_document
[5/19/07 14:55:37:459 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addClass Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmApplicationDataValue.hbm.xml
[5/19/07 14:55:37:467 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addResource Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmApplicationDataValue.hbm.xml
[5/19/07 14:55:37:488 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues Mapping class: com.aciworldwide.ecourier.dsmv2.data.DsmApplicationDataValue -> dsm_application_data
[5/19/07 14:55:37:504 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addClass Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmDocumentEventPropertyValue.hbm.xml
[5/19/07 14:55:37:511 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addResource Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmDocumentEventPropertyValue.hbm.xml
[5/19/07 14:55:37:529 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues Mapping class: com.aciworldwide.ecourier.dsmv2.data.DsmDocumentEventPropertyValue -> dsm_document_event_property
[5/19/07 14:55:37:539 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addClass Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmApplicationDataPropertyValue.hbm.xml
[5/19/07 14:55:37:546 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addResource Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmApplicationDataPropertyValue.hbm.xml
[5/19/07 14:55:37:565 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues Mapping class: com.aciworldwide.ecourier.dsmv2.data.DsmApplicationDataPropertyValue -> dsm_application_data_property
[5/19/07 14:55:37:580 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addClass Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmDocumentPropertyValue.hbm.xml
[5/19/07 14:55:37:588 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addResource Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmDocumentPropertyValue.hbm.xml
[5/19/07 14:55:37:612 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues Mapping class: com.aciworldwide.ecourier.dsmv2.data.DsmDocumentPropertyValue -> dsm_document_property
[5/19/07 14:55:37:621 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addClass Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmRawDataValue.hbm.xml
[5/19/07 14:55:37:631 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addResource Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmRawDataValue.hbm.xml
[5/19/07 14:55:37:654 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues Mapping class: com.aciworldwide.ecourier.dsmv2.data.DsmRawDataValue -> dsm_raw_data
[5/19/07 14:55:37:662 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addClass Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmRawDataPropertyValue.hbm.xml
[5/19/07 14:55:37:671 GMT-07:00] 00000024 Configuration I org.hibernate.cfg.Configuration addResource Reading mappings from resource: com/aciworldwide/ecourier/dsmv2/data/DsmRawDataPropertyValue.hbm.xml
[5/19/07 14:55:37:691 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues Mapping class: com.aciworldwide.ecourier.dsmv2.data.DsmRawDataPropertyValue -> dsm_raw_data_property
[5/19/07 14:55:37:700 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindCollectionSecondPass Mapping collection: com.aciworldwide.ecourier.dsmv2.data.DsmDocumentEventValue.properties -> dsm_document_event_property
[5/19/07 14:55:37:717 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindCollectionSecondPass Mapping collection: com.aciworldwide.ecourier.dsmv2.data.DsmDocumentValue.properties -> dsm_document_property
[5/19/07 14:55:37:726 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindCollectionSecondPass Mapping collection: com.aciworldwide.ecourier.dsmv2.data.DsmDocumentValue.events -> dsm_document_event
[5/19/07 14:55:37:736 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindCollectionSecondPass Mapping collection: com.aciworldwide.ecourier.dsmv2.data.DsmApplicationDataValue.properties -> dsm_application_data_property
[5/19/07 14:55:37:745 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindCollectionSecondPass Mapping collection: com.aciworldwide.ecourier.dsmv2.data.DsmApplicationDataValue.documents -> dsm_document
[5/19/07 14:55:37:753 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindCollectionSecondPass Mapping collection: com.aciworldwide.ecourier.dsmv2.data.DsmRawDataValue.applicationData -> dsm_application_data
[5/19/07 14:55:37:761 GMT-07:00] 00000024 HbmBinder     I org.hibernate.cfg.HbmBinder bindCollectionSecondPass Mapping collection: com.aciworldwide.ecourier.dsmv2.data.DsmRawDataValue.properties -> dsm_raw_data_property
[5/19/07 14:55:37:825 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:37:835 GMT-07:00] 00000024 DatasourceCon I org.hibernate.connection.DatasourceConnectionProvider configure Using datasource: jdbc/ecourier-crjupdsmDS
[5/19/07 14:55:37:850 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings RDBMS: Oracle, version: Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
[5/19/07 14:55:37:858 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings JDBC driver: Oracle JDBC driver, version: 9.2.0.6.0
[5/19/07 14:55:37:877 GMT-07:00] 00000024 Dialect       I org.hibernate.dialect.Dialect <init> Using dialect: org.hibernate.dialect.Oracle9Dialect
[5/19/07 14:55:37:891 GMT-07:00] 00000024 TransactionFa I org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory Transaction strategy: org.hibernate.transaction.CMTTransactionFactory
[5/19/07 14:55:37:900 GMT-07:00] 00000024 TransactionMa I org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup instantiating TransactionManagerLookup: org.hibernate.transaction.WebSphereExtendedJTATransactionLookup
[5/19/07 14:55:37:909 GMT-07:00] 00000024 TransactionMa I org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup instantiated TransactionManagerLookup
[5/19/07 14:55:37:917 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Automatic flush during beforeCompletion(): enabled
[5/19/07 14:55:37:925 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Automatic session close at end of transaction: enabled
[5/19/07 14:55:37:933 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Scrollable result sets: enabled
[5/19/07 14:55:37:941 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings JDBC3 getGeneratedKeys(): disabled
[5/19/07 14:55:37:949 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Connection release mode: auto
[5/19/07 14:55:37:958 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Maximum outer join fetch depth: 3
[5/19/07 14:55:37:966 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Default batch fetch size: 1
[5/19/07 14:55:37:973 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Generate SQL with comments: disabled
[5/19/07 14:55:37:981 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Order SQL updates by primary key: enabled
[5/19/07 14:55:37:989 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[5/19/07 14:55:38:000 GMT-07:00] 00000024 ASTQueryTrans I org.hibernate.hql.ast.ASTQueryTranslatorFactory <init> Using ASTQueryTranslatorFactory
[5/19/07 14:55:38:009 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Query language substitutions: {}
[5/19/07 14:55:38:017 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings JPA-QL strict compliance: disabled
[5/19/07 14:55:38:024 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Second-level cache: enabled
[5/19/07 14:55:38:032 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Query cache: disabled
[5/19/07 14:55:38:040 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory createCacheProvider Cache provider: org.hibernate.cache.NoCacheProvider
[5/19/07 14:55:38:049 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Optimize cache for minimal puts: disabled
[5/19/07 14:55:38:057 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Structured second-level cache entries: disabled
[5/19/07 14:55:38:066 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Echoing all SQL to stdout
[5/19/07 14:55:38:074 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Statistics: disabled
[5/19/07 14:55:38:082 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Deleted entity synthetic identifier rollback: disabled
[5/19/07 14:55:38:090 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Default entity-mode: pojo
[5/19/07 14:55:38:098 GMT-07:00] 00000024 SettingsFacto I org.hibernate.cfg.SettingsFactory buildSettings Named query checking : enabled
[5/19/07 14:55:38:131 GMT-07:00] 00000024 SessionFactor I org.hibernate.impl.SessionFactoryImpl <init> building session factory
[5/19/07 14:55:38:664 GMT-07:00] 00000024 SessionFactor I org.hibernate.impl.SessionFactoryObjectFactory addInstance Not binding factory to JNDI, no JNDI name configured
[5/19/07 14:55:38:679 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:38:734 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:38:743 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:38:793 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:38:800 GMT-07:00] 00000024 SystemOut     O Hibernate: select this_.document_id as document1_1_0_, this_.application_data_id as applicat2_1_0_, this_.parent_document_id as parent3_1_0_, this_.channel_type as channel4_1_0_, this_.physical_channel_type as physical5_1_0_, this_.message_id as message6_1_0_, this_.destination_address as destinat7_1_0_, this_.document_definition_id as document8_1_0_, this_.user_id as user9_1_0_, this_.account_class as account10_1_0_, this_.account_number as account11_1_0_, this_.job_id as job12_1_0_, this_.creation_date as creation13_1_0_ from dsm_document this_ where this_.message_id=?
[5/19/07 14:55:38:844 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:38:851 GMT-07:00] 00000024 SystemOut     O Hibernate: select dsmapplica0_.application_data_id as applicat1_2_0_, dsmapplica0_.raw_data_id as raw2_2_0_, dsmapplica0_.application_id as applicat3_2_0_, dsmapplica0_.issuer_record_id as issuer4_2_0_, dsmapplica0_.xml_data as xml5_2_0_, dsmapplica0_.job_id as job6_2_0_, dsmapplica0_.creation_date as creation7_2_0_ from dsm_application_data dsmapplica0_ where dsmapplica0_.application_data_id=?
[5/19/07 14:55:38:884 GMT-07:00] 00000024 SystemOut     O Hibernate: select properties0_.application_data_id as applicat1_1_, properties0_.property_name as property2_1_, properties0_.application_data_id as applicat1_4_0_, properties0_.property_name as property2_4_0_, properties0_.property_value as property3_4_0_ from dsm_application_data_property properties0_ where properties0_.application_data_id=?
[5/19/07 14:55:38:895 GMT-07:00] 00000024 SystemOut     O Hibernate: select dsmrawdata0_.raw_data_id as raw1_6_0_, dsmrawdata0_.issuer_data_id as issuer2_6_0_, dsmrawdata0_.issuer_data_type as issuer3_6_0_, dsmrawdata0_.checkpoint_record_number as checkpoint4_6_0_, dsmrawdata0_.checkpoint_record_offset as checkpoint5_6_0_, dsmrawdata0_.job_id as job6_6_0_, dsmrawdata0_.creation_date as creation7_6_0_ from dsm_raw_data dsmrawdata0_ where dsmrawdata0_.raw_data_id=?
[5/19/07 14:55:38:904 GMT-07:00] 00000024 SystemOut     O Hibernate: select properties0_.raw_data_id as raw1_1_, properties0_.property_name as property2_1_, properties0_.raw_data_id as raw1_7_0_, properties0_.property_name as property2_7_0_, properties0_.property_value as property3_7_0_ from dsm_raw_data_property properties0_ where properties0_.raw_data_id=?
[5/19/07 14:55:38:914 GMT-07:00] 00000024 SystemOut     O Hibernate: select events0_.document_id as document2_1_, events0_.document_event_id as document1_1_, events0_.document_event_id as document1_0_0_, events0_.document_id as document2_0_0_, events0_.document_event_type as document3_0_0_, events0_.description as descript4_0_0_, events0_.event_date as event5_0_0_ from dsm_document_event events0_ where events0_.document_id=? order by events0_.event_date desc
[5/19/07 14:55:38:928 GMT-07:00] 00000024 SystemOut     O Hibernate: select properties0_.document_event_id as document1_1_, properties0_.property_name as property2_1_, properties0_.document_event_id as document1_3_0_, properties0_.property_name as property2_3_0_, properties0_.property_value as property3_3_0_ from dsm_document_event_property properties0_ where properties0_.document_event_id=?
[5/19/07 14:55:39:518 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:39:529 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:39:538 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:39:540 GMT-07:00] 00000024 SystemOut     O Hibernate: select dsmdocumen0_.document_id as document1_1_0_, dsmdocumen0_.application_data_id as applicat2_1_0_, dsmdocumen0_.parent_document_id as parent3_1_0_, dsmdocumen0_.channel_type as channel4_1_0_, dsmdocumen0_.physical_channel_type as physical5_1_0_, dsmdocumen0_.message_id as message6_1_0_, dsmdocumen0_.destination_address as destinat7_1_0_, dsmdocumen0_.document_definition_id as document8_1_0_, dsmdocumen0_.user_id as user9_1_0_, dsmdocumen0_.account_class as account10_1_0_, dsmdocumen0_.account_number as account11_1_0_, dsmdocumen0_.job_id as job12_1_0_, dsmdocumen0_.creation_date as creation13_1_0_ from dsm_document dsmdocumen0_ where dsmdocumen0_.document_id=?
[5/19/07 14:55:39:555 GMT-07:00] 00000024 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:39:558 GMT-07:00] 00000024 SystemOut     O Hibernate: select events0_.document_id as document2_1_, events0_.document_event_id as document1_1_, events0_.document_event_id as document1_0_0_, events0_.document_id as document2_0_0_, events0_.document_event_type as document3_0_0_, events0_.description as descript4_0_0_, events0_.event_date as event5_0_0_ from dsm_document_event events0_ where events0_.document_id=? order by events0_.event_date desc
[5/19/07 14:55:39:563 GMT-07:00] 00000024 SystemOut     O Hibernate: select properties0_.document_event_id as document1_1_, properties0_.property_name as property2_1_, properties0_.document_event_id as document1_3_0_, properties0_.property_name as property2_3_0_, properties0_.property_value as property3_3_0_ from dsm_document_event_property properties0_ where properties0_.document_event_id=?
[5/19/07 14:55:39:565 GMT-07:00] 00000024 SystemOut     O Hibernate: select properties0_.document_event_id as document1_1_, properties0_.property_name as property2_1_, properties0_.document_event_id as document1_3_0_, properties0_.property_name as property2_3_0_, properties0_.property_value as property3_3_0_ from dsm_document_event_property properties0_ where properties0_.document_event_id=?
[5/19/07 14:55:39:627 GMT-07:00] 00000025 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:39:637 GMT-07:00] 00000025 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:39:647 GMT-07:00] 00000025 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:39:650 GMT-07:00] 00000025 SystemOut     O Hibernate: select dsmdocumen0_.document_id as document1_1_0_, dsmdocumen0_.application_data_id as applicat2_1_0_, dsmdocumen0_.parent_document_id as parent3_1_0_, dsmdocumen0_.channel_type as channel4_1_0_, dsmdocumen0_.physical_channel_type as physical5_1_0_, dsmdocumen0_.message_id as message6_1_0_, dsmdocumen0_.destination_address as destinat7_1_0_, dsmdocumen0_.document_definition_id as document8_1_0_, dsmdocumen0_.user_id as user9_1_0_, dsmdocumen0_.account_class as account10_1_0_, dsmdocumen0_.account_number as account11_1_0_, dsmdocumen0_.job_id as job12_1_0_, dsmdocumen0_.creation_date as creation13_1_0_ from dsm_document dsmdocumen0_ where dsmdocumen0_.document_id=?
[5/19/07 14:55:39:667 GMT-07:00] 00000025 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:39:677 GMT-07:00] 00000025 NamingHelper  I org.hibernate.util.NamingHelper getInitialContext JNDI InitialContext properties:{}
[5/19/07 14:55:39:678 GMT-07:00] 00000025 SystemOut     O Hibernate: select events0_.document_id as document2_1_, events0_.document_event_id as document1_1_, events0_.document_event_id as document1_0_0_, events0_.document_id as document2_0_0_, events0_.document_event_type as document3_0_0_, events0_.description as descript4_0_0_, events0_.event_date as event5_0_0_ from dsm_document_event events0_ where events0_.document_id=? order by events0_.event_date desc
[5/19/07 14:55:39:694 GMT-07:00] 00000025 RegisteredSyn E   WTRN0074E: Exception caught from before_completion synchronization operation: java.lang.UnsupportedOperationException
   at org.hibernate.transaction.WebSphereExtendedJTATransactionLookup$TransactionManagerAdapter$TransactionAdapter.setRollbackOnly(WebSphereExtendedJTATransactionLookup.java:211)
   at org.hibernate.transaction.CacheSynchronization.setRollbackOnly(CacheSynchronization.java:73)
   at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:63)
   at org.hibernate.transaction.WebSphereExtendedJTATransactionLookup$1.invoke(WebSphereExtendedJTATransactionLookup.java:136)
   at $Proxy0.beforeCompletion(Unknown Source)
   at com.ibm.ws.jtaextensions.SynchronizationCallbackWrapper.beforeCompletion(SynchronizationCallbackWrapper.java:65)
   at com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:240)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.prePrepare(TransactionImpl.java:2373)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:1606)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.processCommit(TransactionImpl.java:1577)
   at com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:1512)
   at com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:237)
   at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:162)
   at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:756)
   at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:181)
   at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:581)
   at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3893)
   at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3715)
   at com.aciworldwide.ecourier.management.ejb.remote.EJSRemoteStatelessDocumentManager_dff32e35.addTrackingEvent(Unknown Source)
   at com.aciworldwide.ecourier.management.ejb.remote._EJSRemoteStatelessDocumentManager_dff32e35_Tie.addTrackingEvent(_EJSRemoteStatelessDocumentManager_dff32e35_Tie.java:228)
   at com.aciworldwide.ecourier.management.ejb.remote._EJSRemoteStatelessDocumentManager_dff32e35_Tie._invoke(_EJSRemoteStatelessDocumentManager_dff32e35_Tie.java:119)
   at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:613)
   at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:466)
   at com.ibm.rmi.iiop.ORB.process(ORB.java:503)
   at com.ibm.CORBA.iiop.ORB.process(ORB.java:1552)
   at com.ibm.rmi.iiop.Connection.respondTo(Connection.java:2673)
   at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2551)
   at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:62)
   at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:118)
   at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)


The hibernate config file
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Hibernate Configuration File -->
<!-- Author: rosec -->
<!-- Modified: Friday, April 13, 2007 1:34:36 PM -->
<!DOCTYPE hibernate-configuration PUBLIC
   "-//Hibernate/Hibernate Configuration DTD//EN"
   "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
   <session-factory>
      <!-- Specify the dialect for the connection -->
      <property name = "dialect">org.hibernate.dialect.Oracle9Dialect</property>

      <!-- Specify the JNDI name from which data sources will be taken -->
      <property name = "connection.datasource">jdbc/ecourier-crjupdsmDS</property>

      <!-- Specify a JNDI name that the session factory will use to register itself -->
      <!-- property name = "session_factory_name">ecourier-hibernate-crjupdsm-session-factory</property -->

      <!-- Specify container-independent transaction characteristics -->
      <property name = "transaction.factory_class">org.hibernate.transaction.CMTTransactionFactory</property>
      <property name = "transaction.manager_lookup_class">org.hibernate.transaction.WebSphereExtendedJTATransactionLookup</property>
      <property name = "transaction.flush_before_completion">true</property>
      <property name = "transaction.auto_close_session">true</property>
      
      <!-- Disable the second-level cache  -->
           <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
       
           <!-- Force Hibernate to order SQL updates by the primary key value of the items being updated. This will result in fewer transaction deadlocks in highly concurrent systems. -->
      <property name = "hibernate.order_updates">true</property>
      
      <property name = "hibernate.jdbc.use_streams_for_binary">true</property>
      
      <property name = "hibernate.bytecode.use_reflection_optimizer">true</property>

      <!-- Print SQL to stdout? -->
      <property name="show_sql">true</property>

      <!-- turn off batching to make debugging easier -->
      <property name = "hibernate.jdbc.batch_size">0</property>

      <property name = "hibernate.max_fetch_depth">3</property>

   </session-factory>
</hibernate-configuration>


Can anyone help me get this to work?

_________________
Chris R

Top
 Profile  
 
offby1
 Post subject: Anything else?
PostPosted: Tue May 22, 2007 1:06 pm 
Newbie

Joined: Sat May 19, 2007 5:02 pm
Posts: 5
With all the silence, is there any more information I could provide that would make it more likely that I'll get a response? I'm free to put together just about anything you might need.

_________________
Chris R

Top
 Profile  
 
bjornw
 Post subject: Workaround
PostPosted: Mon Jun 18, 2007 12:10 pm 
Newbie

Joined: Mon Dec 12, 2005 4:25 am
Posts: 6
You can use the "old" way of Websphere transaction synchronization, read more in this thread:

http://forum.hibernate.org/viewtopic.php?t=966463

I still don't know how this affects performance or stabilty but it work and we have used it in production for a long time now.
Top
 Profile  
 
kpdunn
 Post subject:
PostPosted: Thu Jun 28, 2007 11:53 am 
Newbie

Joined: Mon Jun 04, 2007 12:07 pm
Posts: 5
Can you make sure that the java type documentId is correct for the DB type you've mapped it to. I just had the same problem because for an integer DB type I was trying to pass in a java long to my equivalent of your findByDocumentID.
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

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

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