Kevin, Thanks for your response.
I am including the full log from my junit test with TRACE turned on via openjpa.Log in persistence.xml <property name="openjpa.Log" value="DefaultLevel=WARN, Runtime=TRACE, Tool=INFO, SQL=TRACE"/> I am using the DB2Dictionary in my persistence.xml <property name="openjpa.jdbc.DBDictionary" value="org.apache.openjpa.jdbc.sql.DB2Dictionary"/> I have a junit test which prints out these two variables from the DB2Dictionary. public void testShowDb2Dictionary() { DB2Dictionary dictionary = new org.apache.openjpa.jdbc.sql.DB2Dictionary(); log.info("dictionary.lastGeneratedKeyQuery="+dictionary.lastGeneratedKeyQuery); //this shows VALUES(IDENTITY_VAL_LOCAL()) log.info("dictionary.supportsGetGeneratedKeys="+dictionary.supportsGetGeneratedKeys); //this shows null } This prints out 2011-01-25 10:27:06,266 INFO [] com.ais.persistence.InpartmasterTest:103 - dictionary.lastGeneratedKeyQuery=VALUES(IDENTITY_VAL_LOCAL()) 2011-01-25 10:27:06,266 INFO [] com.ais.persistence.InpartmasterTest:104 - dictionary.supportsGetGeneratedKeys=null I would think the DB2Dictionary.supportsGetGeneratedKeys ==null is part of the problem. But I dont know how to resolve. I know I am able to use stmt.getGeneratedKeys with the same db2 jdbc driver class (p:driverClass="com.ibm.db2.jcc.DB2Driver") with a straight JDBC Dao Framework Thank you for your help. Full Log Below ======================== 2011-01-25 10:26:55,861 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:81 - FirestormUtil static init loading spring 2011-01-25 10:26:55,876 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:122 - applicationContext.xml exists=true 2011-01-25 10:26:55,878 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:126 - URL=file:/C:/RAD/aircore-JPA-J2-SNAPSHOT/target/classes/applicationContext.xml 2011-01-25 10:26:55,879 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:135 - running with applicationContext.xml 2011-01-25 10:26:55,880 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:122 - applicationContext2.xml exists=true 2011-01-25 10:26:55,881 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:126 - URL=file:/C:/RAD/aircore-JPA-J2-SNAPSHOT/target/classes/applicationContext2.xml 2011-01-25 10:26:55,882 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:135 - running with applicationContext2.xml 2011-01-25 10:26:55,883 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:122 - applicationContext3.xml exists=false 2011-01-25 10:26:55,884 ERROR [] com.cms.shared.ext.firestorm.FirestormUtil:130 - class path resource [applicationContext3.xml] cannot be resolved to URL because it does not exist 2011-01-25 10:26:55,886 ERROR [] com.cms.shared.ext.firestorm.FirestormUtil:139 - running without applicationContext3.xml 2011-01-25 10:26:55,912 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:101 - building Spring ClassPathXmlApplicationContext from these files[applicationContext.xml applicationContext2.xml] 2011-01-25 10:26:55,957 INFO [] org.springframework.context.support.ClassPathXmlApplicationContext:456 - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@4998a455: startup date [Tue Jan 25 10:26:55 PST 2011]; root of context hierarchy 2011-01-25 10:26:56,013 INFO [] org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [applicationContext.xml] 2011-01-25 10:26:56,417 INFO [] org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [jpapersistence.xml] 2011-01-25 10:26:56,669 INFO [] org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [stdcore.xml] 2011-01-25 10:26:59,331 INFO [] org.springframework.beans.factory.xml.XmlBeanDefinitionReader:315 - Loading XML bean definitions from class path resource [applicationContext2.xml] 2011-01-25 10:26:59,384 INFO [] org.springframework.beans.factory.support.DefaultListableBeanFactory:618 - Overriding bean definition for bean 'fiscalYrDao': replacing [Generic bean: class [com.cms.shared.gen.firestorm.jdbc.FiscalYrDaoImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [stdcore.xml]] with [Generic bean: class [com.cms.shared.gen.firestorm.jdbc.FiscalYrDaoImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [applicationContext2.xml]] 2011-01-25 10:26:59,392 INFO [] org.springframework.beans.factory.support.DefaultListableBeanFactory:618 - Overriding bean definition for bean 'aircraftDao': replacing [Generic bean: class [com.cms.shared.gen.firestorm.jdbc.AircraftDaoImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [stdcore.xml]] with [Generic bean: class [com.cms.shared.gen.firestorm.jdbc.AircraftDaoImpl]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [applicationContext2.xml]] 2011-01-25 10:26:59,426 INFO [] org.springframework.beans.factory.support.DefaultListableBeanFactory:618 - Overriding bean definition for bean 'maintenanceManager': replacing [Generic bean: class [com.cms.mx.MaintenanceManager]; scope=singleton; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in file [C:\RAD\aircore-JPA-J2-SNAPSHOT\target\classes\com\cms\mx\MaintenanceManager.class]] with [Generic bean: class [com.cms.mx.MaintenanceManager]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null; defined in class path resource [applicationContext2.xml]] 2011-01-25 10:27:00,438 INFO [] org.springframework.beans.factory.support.DefaultListableBeanFactory:555 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@42ef83d3: defining beans [mainDataSource,securityDataSource,auditDataSource,auditTriggerDataSource,companyIdLength,defaultCompanyId,defaultCompanyName,entityManagerFactory,jpaDialect,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,partsRequestDao,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor#0,jpaFamasterDao,jpaFadistDao,jpaCountersDao,jpaGlopenDao,jpaGltransaDao,jpaInpartmasterDao,jpaInmasterDao,jpaCategoryDao,jpaInpartactypeDao,partsRequestJpaManager,partsRequestLineJpaManager,org.springframework.beans.factory.annotation.RequiredAnnotationBeanPostProcessor#0,validator,accountingManager,transactionValidator,aircraftManager,accountsPayableInvoiceManager,accountsPayablePaymentManager,inventoryInvoiceManager,inventoryPurchaseOrderManager,purchaseOrderManager,commentManager,partsRequestManager,maintenanceManager,counterManager,resourceManager,firestormUtil,txProxyTemplate,auditLogInterceptor,updateInterceptor,triggerChgColumnsInterceptor,updateNoLockrecInterceptor,lockService,lookupService,applicationConfigurationDao,counterDao,glopenDao,phoneDao,gltransaDao,companyDao,checkconfigDao,glmasterDao,jnlcdeDao,ctldescDao,dtldescDao,subtotcdsDao,accttypeDao,acctgroupDao,fiscalYrDao,apmasterDao,cashDisbursementsDao,cashDisbursementsVendorsDao,cashDisbursementsVendorsInvoicesDao,invoiceSummaryApmasterDao,vendor1099PaymentAmountDao,cashDisbursementInvoicesDao,cdCheckctrDao,armasterDao,wocountersDao,womasterDao,wodetailDao,wotransDao,womatrixDao,wodistDao,pomasterDao,podetailDao,podistDao,orderDistributionDao,potransDao,invoiceSummaryDao,paymentSummaryDao,podoctypeDao,wodoctypeDao,controlacctsDao,apcountersDao,arcountersDao,memoDao,invoiceDetailDao,locnDao,iodevicesDao,historical1099Dao,glbudgetDao,vendtypesDao,famasterDao,fadistDao,agingMasterDao,agingDetailDao,interCompAcctDao,acdefaultsDao,aircraftDao,shiplocnDao,shipmodeDao,shipvendDao,custtypesDao,regionDao,statesDao,paytermsDao,remittanceTypeDao,billingCycleDao,apArMappingDao,commentTypesDao,commentMasterDao,commentDetailDao,codefileDao,codefile01Dao,codefile02Dao,codefile11Dao,codefile04Dao,travelagentDao,invoiceRestrictionsDao,invoiceRestrictionRulesDao,glmasterRetriever,generalLedgerValidator,glopenRetriever,generalLedgerManager,fiscalYearManager,jpaInventoryManager,fixedAssetManager,orderReportHelper,summaryCheckReportHelper,apmasterValidator,accountsPayableManager,armasterValidator,accountsReceivableInvoiceValidator,accountsReceivableManager,accountsReceivableInvoiceManager,codefileManager,securityService,inmasterDao,inpartmasterDao,inmasterConsolidatedDao,iprequestDao,inventorylocationDao,inventoryclassDao,inventoryclassmatrixDao,inventorycategorymatrixDao,inventorycategoryDao,inventorycontrolDao,inventorydistributionDao,inventorytypeDao,inventoryOptionsDao,packingListDao,employeeDao,processQueueDao,mxtailDao,mxassemblyDao,mxactionrqDao,mxactionrqPartDao,mxactionrqAarDao,inventorycountDao,physicalInventoryGlDao,fuelmasterDao,fueltypeDao,fuelcatDao,glfuelDao,fuelacctDao,fuelmasterPriceComponentDao,fuelLocDao,fuelLocTypeDao,fuelTxnDao,fuelTxnRelatedGlopenDao,fuelLocEffectiveDao,flightDao,inmasterReportDao,glopenReportDao,airportsDao,clientDao,inpartactypeDao,inpartaircraftDao,movementValidator,inventoryValidator,maintenanceValidator,transactionRetriever,postInventoryTransactionDelegate,receivingDelegate,purchaseOrderHelper,movementHelper,partIssueStrategy,partReturnStrategy,adjustmentDecrementStrategy,adjustmentIncrementStrategy,expendableTransferOutStrategy,expendableTransferInStrategy,rotableIssueStrategy,rotableReturnStrategy,returnWithoutRepairStrategy,beyondEconomicRepairStrategy,loanPartStrategy,returnLoanedPartStrategy,robPartStrategy,returnForRepairStrategy,voidReturnForRepairStrategy,robForRepairStrategy,rotableTransferOutStrategy,rotableTransferInStrategy,beginningInventoryStrategy,scrapExpiredPartStrategy,rotableIssueForInductionStrategy,expendableIssueForInductionStrategy,changeRotableIssueToInductionStrategy,rotableInspectionPassStrategy,rotableInspectionFailStrategy,rotableReturnToVendorNonAssetStrategy,rotableReturnToVendorStrategy,expendableReturnToVendorStrategy,returnForRepairTearDownStrategy,returnForRepairNonConformingPartStrategy,inventoryManager,physicalInventoryManager,fuelGlopenPostingCallback,fuelManager,flightManager,job2,cronTrigger2,job3,cronTrigger3,job4,cronTrigger4,dbConnectionTester,job5,cronTrigger5,scheduler]; root of factory hierarchy 2011-01-25 10:27:00,460 INFO [] com.mchange.v2.log.MLog:80 - MLog clients using log4j logging. 2011-01-25 10:27:00,585 INFO [] com.mchange.v2.c3p0.C3P0Registry:204 - Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10] 2011-01-25 10:27:00,850 INFO [] org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean:221 - Building JPA container EntityManagerFactory for persistence unit 'airweb-JPA-J2-SNAPSHOT' 2011-01-25 10:27:01,026 INFO [] com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource:462 - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 1, acquireRetryAttempts -> 0, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> com.cms.db.CmsConnectionCustomizer, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgf4i18d1gu515km9qccj|4987b287, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.ibm.db2.jcc.DB2Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgf4i18d1gu515km9qccj|4987b287, idleConnectionTestPeriod -> 25, initialPoolSize -> 0, jdbcUrl -> jdbc:db2://db2svr:50001/cmsdb:driverType=4;currentSchema=CMSDB;defaultIsolationLevel=2;retrieveMessagesFromServerOnGetMessage=true;, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 600, maxPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> /* ping */ select 1 from (values 1), properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ] 23 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Setting the following properties from "?" into configuration: {javax.persistence.provider=org.apache.openjpa.persistence.PersistenceProviderImpl, openjpa.RuntimeUnenhancedClasses=unsupported, openjpa.jdbc.Schema=CMSDB, javax.persistence.sharedCache.mode=UNSPECIFIED, openjpa.jdbc.DBDictionary=org.apache.openjpa.jdbc.sql.DB2Dictionary, openjpa.Log=DefaultLevel=WARN, Runtime=TRACE, Tool=INFO, SQL=TRACE, PersistenceVersion=2.0, openjpa.Id=airweb-JPA-J2-SNAPSHOT, openjpa.MaxFetchDepth=5, openjpa.ConnectionFactoryMode=managed, openjpa.ConnectionFactory=com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 1, acquireRetryAttempts -> 0, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> com.cms.db.CmsConnectionCustomizer, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgf4i18d1gu515km9qccj|4987b287, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.ibm.db2.jcc.DB2Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgf4i18d1gu515km9qccj|4987b287, idleConnectionTestPeriod -> 25, initialPoolSize -> 0, jdbcUrl -> jdbc:db2://db2svr:50001/cmsdb:driverType=4;currentSchema=CMSDB;defaultIsolationLevel=2;retrieveMessagesFromServerOnGetMessage=true;, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 600, maxPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> /* ping */ select 1 from (values 1), properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ], javax.persistence.validation.mode=NONE, openjpa.MetaDataFactory=jpa(Files=/C:/RAD/aircore-JPA-J2-SNAPSHOT/target/classes/, Types=com.ais.persistence.entities.InpartmasterPK;com.ais.persistence.entities.Inpartmaster;com.ais.persistence.entities.GltransaPK;com.ais.persistence.entities.Gltransa;com.ais.persistence.entities.GlopenPK;com.ais.persistence.entities.Glopen;com.ais.persistence.entities.FamasterPK;com.ais.persistence.entities.Famaster;com.ais.persistence.entities.FadistPK;com.ais.persistence.entities.Fadist;com.ais.persistence.entities.CountersPK;com.ais.persistence.entities.Counters;com.ais.persistence.entities.Inmaster;com.ais.persistence.entities.InmasterPK;com.ais.persistence.entities.PartsRequest;com.ais.persistence.entities.PartsRequestLine;com.ais.persistence.entities.Category;com.ais.persistence.entities.Inpartactype;com.ais.persistence.entities.InpartactypePK), openjpa.ClassResolver=org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl@2390d8e1, openjpa.ConnectionFactory2=com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 1, acquireRetryAttempts -> 0, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> com.cms.db.CmsConnectionCustomizer, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgf4i18d1gu515km9qccj|4987b287, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.ibm.db2.jcc.DB2Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgf4i18d1gu515km9qccj|4987b287, idleConnectionTestPeriod -> 25, initialPoolSize -> 0, jdbcUrl -> jdbc:db2://db2svr:50001/cmsdb:driverType=4;currentSchema=CMSDB;defaultIsolationLevel=2;retrieveMessagesFromServerOnGetMessage=true;, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 600, maxPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> /* ping */ select 1 from (values 1), properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ], openjpa.jdbc.MappingDefaults=StoreEnumOrdinal=false} 29 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - No cache marshaller found for id org.apache.openjpa.conf.MetaDataCacheMaintenance. 15 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Setting the following properties from "?" into configuration: {openjpa.BrokerFactory=jdbc, javax.persistence.provider=org.apache.openjpa.persistence.PersistenceProviderImpl, openjpa.RuntimeUnenhancedClasses=unsupported, openjpa.jdbc.Schema=CMSDB, javax.persistence.sharedCache.mode=UNSPECIFIED, openjpa.jdbc.DBDictionary=org.apache.openjpa.jdbc.sql.DB2Dictionary, openjpa.Log=DefaultLevel=WARN, Runtime=TRACE, Tool=INFO, SQL=TRACE, PersistenceVersion=2.0, openjpa.Id=airweb-JPA-J2-SNAPSHOT, openjpa.MaxFetchDepth=5, openjpa.ConnectionFactoryMode=managed, openjpa.ConnectionFactory=com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 1, acquireRetryAttempts -> 0, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> com.cms.db.CmsConnectionCustomizer, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgf4i18d1gu515km9qccj|4987b287, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.ibm.db2.jcc.DB2Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgf4i18d1gu515km9qccj|4987b287, idleConnectionTestPeriod -> 25, initialPoolSize -> 0, jdbcUrl -> jdbc:db2://db2svr:50001/cmsdb:driverType=4;currentSchema=CMSDB;defaultIsolationLevel=2;retrieveMessagesFromServerOnGetMessage=true;, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 600, maxPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> /* ping */ select 1 from (values 1), properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ], javax.persistence.validation.mode=NONE, openjpa.BrokerImpl=non-finalizing, openjpa.MetaDataFactory=jpa(Files=/C:/RAD/aircore-JPA-J2-SNAPSHOT/target/classes/, Types=com.ais.persistence.entities.InpartmasterPK;com.ais.persistence.entities.Inpartmaster;com.ais.persistence.entities.GltransaPK;com.ais.persistence.entities.Gltransa;com.ais.persistence.entities.GlopenPK;com.ais.persistence.entities.Glopen;com.ais.persistence.entities.FamasterPK;com.ais.persistence.entities.Famaster;com.ais.persistence.entities.FadistPK;com.ais.persistence.entities.Fadist;com.ais.persistence.entities.CountersPK;com.ais.persistence.entities.Counters;com.ais.persistence.entities.Inmaster;com.ais.persistence.entities.InmasterPK;com.ais.persistence.entities.PartsRequest;com.ais.persistence.entities.PartsRequestLine;com.ais.persistence.entities.Category;com.ais.persistence.entities.Inpartactype;com.ais.persistence.entities.InpartactypePK), openjpa.ClassResolver=org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl@2390d8e1, openjpa.ConnectionFactory2=com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 1, acquireRetryAttempts -> 0, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> com.cms.db.CmsConnectionCustomizer, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgf4i18d1gu515km9qccj|4987b287, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.ibm.db2.jcc.DB2Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgf4i18d1gu515km9qccj|4987b287, idleConnectionTestPeriod -> 25, initialPoolSize -> 0, jdbcUrl -> jdbc:db2://db2svr:50001/cmsdb:driverType=4;currentSchema=CMSDB;defaultIsolationLevel=2;retrieveMessagesFromServerOnGetMessage=true;, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 600, maxPoolSize -> 50, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 0, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> /* ping */ select 1 from (values 1), properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> true, testConnectionOnCheckout -> true, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ], openjpa.jdbc.MappingDefaults=StoreEnumOrdinal=false} 30 airweb-JPA-J2-SNAPSHOT WARN [main] openjpa.Runtime - An error occurred while registering a ClassTransformer with PersistenceUnitInfo: name 'airweb-JPA-J2-SNAPSHOT', root URL [file:/C:/RAD/aircore-JPA-J2-SNAPSHOT/target/classes/]. The error is logged along with this warning. Load-time class transformation will not be available. java.lang.reflect.UndeclaredThrowableException at $Proxy6.addTransformer(Unknown Source) at org.apache.openjpa.persistence.PersistenceProviderImpl.createContainerEntityManagerFactory(PersistenceProviderImpl.java:172) at org.apache.openjpa.persistence.PersistenceProviderImpl.createContainerEntityManagerFactory(PersistenceProviderImpl.java:66) at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:225) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:308) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:563) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93) at com.cms.shared.ext.firestorm.FirestormUtil.<clinit>(FirestormUtil.java:103) at com.ais.persistence.InpartmasterTest.setUp(InpartmasterTest.java:29) at junit.framework.TestCase.runBare(TestCase.java:125) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22) at junit.extensions.TestSetup$1.protect(TestSetup.java:19) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.extensions.TestSetup.run(TestSetup.java:23) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.orm.jpa.persistenceunit.DefaultPersistenceUnitManager$Jpa2PersistenceUnitInfoDecorator.invoke(DefaultPersistenceUnitManager.java:444) ... 37 more Caused by: java.lang.IllegalStateException: Must start with Java agent to use InstrumentationLoadTimeWeaver. See Spring documentation. at org.springframework.instrument.classloading.InstrumentationLoadTimeWeaver.addTransformer(InstrumentationLoadTimeWeaver.java:87) at org.springframework.orm.jpa.persistenceunit.SpringPersistenceUnitInfo.addTransformer(SpringPersistenceUnitInfo.java:111) ... 42 more 32 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Not creating a ValidatorImpl because ValidationMode=NONE 46 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.PersistenceProviderImpl@7f42731 creating container org.apache.openjpa.persistence.EntityManagerFactoryImpl@2e39060b for PU airweb-JPA-J2-SNAPSHOT. 2011-01-25 10:27:02,459 INFO [] com.cms.shared.ext.firestorm.ResourceManager:25 - Spring DataSource Based ResourceManager static init 2011-01-25 10:27:06,244 INFO [] org.quartz.core.QuartzScheduler:195 - Quartz Scheduler v.1.5.2 created. 2011-01-25 10:27:06,246 INFO [] org.quartz.simpl.RAMJobStore:138 - RAMJobStore initialized. 2011-01-25 10:27:06,246 INFO [] org.quartz.impl.StdSchedulerFactory:1014 - Quartz scheduler 'cmsScheduler' initialized from an externally provided properties instance. 2011-01-25 10:27:06,246 INFO [] org.quartz.impl.StdSchedulerFactory:1018 - Quartz scheduler version: 1.5.2 2011-01-25 10:27:06,248 INFO [] org.quartz.core.QuartzScheduler:1853 - JobFactory set to: org.springframework.scheduling.quartz.AdaptableJobFactory@35a271f5 2011-01-25 10:27:06,254 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:237 - Setting Chgprog to JPATest for this thread. 2011-01-25 10:27:06,255 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:225 - Setting Chgusername to InpartmasterTest for this thread. 2011-01-25 10:27:06,266 INFO [] com.ais.persistence.InpartmasterTest:103 - dictionary.lastGeneratedKeyQuery=VALUES(IDENTITY_VAL_LOCAL()) 2011-01-25 10:27:06,266 INFO [] com.ais.persistence.InpartmasterTest:104 - dictionary.supportsGetGeneratedKeys=null 2011-01-25 10:27:06,267 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:237 - Setting Chgprog to JPATest for this thread. 2011-01-25 10:27:06,267 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:225 - Setting Chgusername to InpartmasterTest for this thread. 2011-01-25 10:27:06,267 INFO [] com.ais.persistence.InpartmasterTest:110 - insert 2011-01-25 10:27:06,268 INFO [] com.ais.persistence.InpartmasterTest:111 - part=1295980015840 2011-01-25 10:27:06,268 INFO [] com.ais.persistence.InpartmasterTest:120 - com.ais.persistence.entities.Inpartmaster@36101d01 3917 airweb-JPA-J2-SNAPSHOT INFO [main] openjpa.Runtime - Starting OpenJPA 2.2.0-SNAPSHOT 3918 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Properties: javax.persistence.lock.timeout: 0 javax.persistence.query.timeout: 0 javax.persistence.sharedCache.mode: UNSPECIFIED javax.persistence.validation.group.pre-persist: javax.validation.groups.Default javax.persistence.validation.group.pre-update: javax.validation.groups.Default javax.persistence.validation.mode: NONE openjpa.AutoClear: 0 openjpa.AutoDetach: [Ljava.lang.String;@4e2d8ecc openjpa.BrokerFactory: jdbc openjpa.BrokerImpl: non-finalizing openjpa.CacheDistributionPolicy: default openjpa.Callbacks: default openjpa.ClassResolver: org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl openjpa.Compatibility: default openjpa.ConnectionFactoryMode: true openjpa.ConnectionRetainMode: 0 openjpa.DataCache: false openjpa.DataCacheManager: default openjpa.DataCacheTimeout: -1 openjpa.DetachState: loaded openjpa.DynamicDataStructs: false openjpa.DynamicEnhancementAgent: true openjpa.EntityManagerFactory: default openjpa.FetchBatchSize: -1 openjpa.FetchGroups: [Ljava.lang.String;@10fa1b2d openjpa.FlushBeforeQueries: 0 openjpa.Id: airweb-JPA-J2-SNAPSHOT openjpa.IgnoreChanges: false openjpa.InitializeEagerly: false openjpa.InstrumentationManager: default openjpa.InverseManager: false openjpa.LifecycleEventManager: default openjpa.LockManager: mixed openjpa.Log: true(DefaultLevel=WARN, Runtime=TRACE, Tool=INFO, SQL=TRACE) openjpa.ManagedRuntime: auto openjpa.MaxFetchDepth: 5 openjpa.MetaDataFactory: jpa(Files=/C:/RAD/aircore-JPA-J2-SNAPSHOT/target/classes/, Types=com.ais.persistence.entities.InpartmasterPK;com.ais.persistence.entities.Inpartmaster;com.ais.persistence.entities.GltransaPK;com.ais.persistence.entities.Gltransa;com.ais.persistence.entities.GlopenPK;com.ais.persistence.entities.Glopen;com.ais.persistence.entities.FamasterPK;com.ais.persistence.entities.Famaster;com.ais.persistence.entities.FadistPK;com.ais.persistence.entities.Fadist;com.ais.persistence.entities.CountersPK;com.ais.persistence.entities.Counters;com.ais.persistence.entities.Inmaster;com.ais.persistence.entities.InmasterPK;com.ais.persistence.entities.PartsRequest;com.ais.persistence.entities.PartsRequestLine;com.ais.persistence.entities.Category;com.ais.persistence.entities.Inpartactype;com.ais.persistence.entities.InpartactypePK) openjpa.MetaDataRepository: default openjpa.Multithreaded: false openjpa.NontransactionalRead: true openjpa.NontransactionalWrite: true openjpa.Optimistic: true openjpa.OrphanedKeyAction: log openjpa.ProxyManager: default openjpa.QueryCache: false openjpa.QueryCompilationCache: true openjpa.ReadLockLevel: 10 openjpa.RefreshFromDataCache: false openjpa.RestoreState: 1 openjpa.RetainState: true openjpa.RetryClassRegistration: false openjpa.RuntimeUnenhancedClasses: 1 openjpa.SavepointManager: in-mem openjpa.Sequence: table openjpa.TransactionMode: false openjpa.WriteLockLevel: 20 openjpa.jdbc.DBDictionary: db2 openjpa.jdbc.DriverDataSource: auto openjpa.jdbc.EagerFetchMode: 2 openjpa.jdbc.FetchDirection: 1000 openjpa.jdbc.FinderCache: true openjpa.jdbc.IdentifierUtil: default openjpa.jdbc.LRSSize: 2 openjpa.jdbc.MappingDefaults: jpa(StoreEnumOrdinal=false) openjpa.jdbc.QuerySQLCache: true openjpa.jdbc.ResultSetType: 1003 openjpa.jdbc.SQLFactory: default openjpa.jdbc.Schema: CMSDB openjpa.jdbc.SchemaFactory: dynamic openjpa.jdbc.Schemas: [Ljava.lang.String;@4e2d8ecc openjpa.jdbc.SubclassFetchMode: 1 openjpa.jdbc.SynchronizeMappings: null openjpa.jdbc.TransactionIsolation: -1 openjpa.jdbc.UpdateManager: default 3918 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - No cache marshaller found for id org.apache.openjpa.conf.MetaDataCacheMaintenance. 2011-01-25 10:27:06,815 INFO [] com.cms.db.CmsConnectionCustomizer:20 - Acquired com.ibm.db2.jcc.t4.b@67afe460 [1hgf4i18d1gu515km9qccj|4987b287] 4512 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 230731210> executing stmnt 64922498 SELECT CURRENT SCHEMA FROM SYSIBM.SYSDUMMY1 4521 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 230731210> [9 ms] spent 4574 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Found datasource 2: datasource -607958316 from config. StoreContext: org.apache.openjpa.kernel.BrokerImpl@19a33662 2011-01-25 10:27:07,010 INFO [] com.cms.db.CmsConnectionCustomizer:20 - Acquired com.ibm.db2.jcc.t4.b@fd50fd2 [1hgf4i18d1gu515km9qccj|4987b287] 5833 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerFactoryImpl@2e39060b created EntityManager org.apache.openjpa.persistence.EntityManagerImpl@19a33662. 6003 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Access style for "com.ais.persistence.entities.InmasterPK" can not be determined. The default "implicit field access" will be used. If this access style is not correct, specify the correct style explicitly on the persistent type or within the mapping file. 6004 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Access style for "com.ais.persistence.entities.InmasterPK" can not be determined. The default "implicit field access" will be used. If this access style is not correct, specify the correct style explicitly on the persistent type or within the mapping file. 6127 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 1585215636> executing prepstmnt 137322702 INSERT INTO CMSDB.INPARTMASTER (incomp, inpart, chgdate, chgprog, chgtype, chguser, inactype, inalt1, inalt2, inalt3, inata, inclass, incntiv, incomt, indcost, indcostro, indcostropvcr, indepot, indescr, inetops, inexchg, inexcis, infill1, ingrp, inhazmatind, inidxflg, inisunit, inlead, inlohi, inlprice, inmethod, inmfg, innotes, inodisc, inpartnd, inpdisc, inpkg, inpkgbrk, inplno, inprev, inprice, inreturn, inrvflg, inshippref, inshlind, insos, instatus, insuperced, interchg, intypart, intype, invcost1, invcost2, invcost3, invcost4, invdate1, invdate2, invdate3, invdate4, invend, invend1, invend2, invend3, invend4, invendlt, invendro, invendropref, inwarflg, inwprice, inwrkscp, chgpage) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?] 6132 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 1585215636> [4 ms] spent 6145 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerImpl@19a33662.close() invoked. 2011-01-25 10:27:08,513 INFO [] com.ais.persistence.InpartmasterTest:124 - recId=null 2011-01-25 10:27:08,516 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:237 - Setting Chgprog to JPATest for this thread. 2011-01-25 10:27:08,517 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:225 - Setting Chgusername to InpartmasterTest for this thread. 2011-01-25 10:27:08,517 INFO [] com.ais.persistence.InpartmasterTest:143 - update 6156 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Found datasource 2: datasource -607958316 from config. StoreContext: org.apache.openjpa.kernel.BrokerImpl@22652552 6156 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerFactoryImpl@2e39060b created EntityManager org.apache.openjpa.persistence.EntityManagerImpl@22652552. 6182 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 1424834147> executing prepstmnt 612501574 SELECT t0.chgpage, t0.chgdate, t0.chgprog, t0.chgtype, t0.chguser, t0.inactype, t0.inalt1, t0.inalt2, t0.inalt3, t0.inata, t0.inclass, t0.incntiv, t0.incomt, t0.indcost, t0.indcostro, t0.indcostropvcr, t0.indepot, t0.indescr, t0.inetops, t0.inexchg, t0.inexcis, t0.infill1, t0.ingrp, t0.inhazmatind, t0.inidxflg, t0.inisunit, t0.inlead, t0.inlohi, t0.inlprice, t0.inmethod, t0.inmfg, t0.innotes, t0.inodisc, t0.inpartnd, t0.inpdisc, t0.inpkg, t0.inpkgbrk, t0.inplno, t0.inprev, t0.inprice, t0.inreturn, t0.inrvflg, t0.inshippref, t0.inshlind, t0.insos, t0.instatus, t0.insuperced, t0.interchg, t0.intypart, t0.intype, t0.invcost1, t0.invcost2, t0.invcost3, t0.invcost4, t0.invdate1, t0.invdate2, t0.invdate3, t0.invdate4, t0.invend, t0.invend1, t0.invend2, t0.invend3, t0.invend4, t0.invendlt, t0.invendro, t0.invendropref, t0.inwarflg, t0.inwprice, t0.inwrkscp, t0.incomp, t0.inpart, t0.REC_ID, t1.incomp, t1.inpart, t1.inindiv, t1.chgpage, t1.chgdate, t1.chgprog, t1.chgtype, t1.chguser, t1.inalloc, t1.inamu, t1.inback, t1.inbin, t1.inc01, t1.inc02, t1.inc03, t1.inc04, t1.inc05, t1.inc06, t1.inc07, t1.inc08, t1.inc09, t1.inc10, t1.inc11, t1.inc12, t1.inc13, t1.incanyr, t1.incntdte, t1.incntstat, t1.incyavg, t1.inentdte, t1.inguide, t1.inlost, t1.inlstrec, t1.inlstsld, t1.inmax, t1.inmaxstk, t1.inmbin, t1.inmin, t1.inmtop, t1.inodate, t1.inopen, t1.inp00, t1.inp01, t1.inp02, t1.inp03, t1.inp04, t1.inp05, t1.inp06, t1.inp07, t1.inp08, t1.inp09, t1.inp10, t1.inp11, t1.inp12, t1.inp13, t1.inpercnt, t1.inperptr, t1.inpyavg, t1.inqbo, t1.inqfinv, t1.inqiq, t1.inqoh, t1.inqoo, t1.inqpi, t1.inreordr, t1.inreqdte, t1.inreqqty, t1.inshelf, t1.intranst, t1.invar, t1.REC_ID FROM CMSDB.INPARTMASTER t0 LEFT OUTER JOIN CMSDB.Inmaster t1 ON t0.incomp = t1.incomp AND t0.inpart = t1.inpart WHERE t0.incomp = ? AND t0.inpart = ? [params=?, ?] 6190 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 1424834147> [8 ms] spent 6201 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerImpl@22652552.close() invoked. 2011-01-25 10:27:08,563 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:237 - Setting Chgprog to JPATest for this thread. 2011-01-25 10:27:08,564 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:225 - Setting Chgusername to InpartmasterTest for this thread. 2011-01-25 10:27:08,565 INFO [] com.ais.persistence.InpartmasterTest:161 - testAssertRecIdNotZero 6203 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Found datasource 2: datasource -607958316 from config. StoreContext: org.apache.openjpa.kernel.BrokerImpl@4ab3a5d1 6203 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerFactoryImpl@2e39060b created EntityManager org.apache.openjpa.persistence.EntityManagerImpl@4ab3a5d1. 6205 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 1411809407> executing prepstmnt 651088296 SELECT t0.chgpage, t0.chgdate, t0.chgprog, t0.chgtype, t0.chguser, t0.inactype, t0.inalt1, t0.inalt2, t0.inalt3, t0.inata, t0.inclass, t0.incntiv, t0.incomt, t0.indcost, t0.indcostro, t0.indcostropvcr, t0.indepot, t0.indescr, t0.inetops, t0.inexchg, t0.inexcis, t0.infill1, t0.ingrp, t0.inhazmatind, t0.inidxflg, t0.inisunit, t0.inlead, t0.inlohi, t0.inlprice, t0.inmethod, t0.inmfg, t0.innotes, t0.inodisc, t0.inpartnd, t0.inpdisc, t0.inpkg, t0.inpkgbrk, t0.inplno, t0.inprev, t0.inprice, t0.inreturn, t0.inrvflg, t0.inshippref, t0.inshlind, t0.insos, t0.instatus, t0.insuperced, t0.interchg, t0.intypart, t0.intype, t0.invcost1, t0.invcost2, t0.invcost3, t0.invcost4, t0.invdate1, t0.invdate2, t0.invdate3, t0.invdate4, t0.invend, t0.invend1, t0.invend2, t0.invend3, t0.invend4, t0.invendlt, t0.invendro, t0.invendropref, t0.inwarflg, t0.inwprice, t0.inwrkscp, t0.incomp, t0.inpart, t0.REC_ID, t1.incomp, t1.inpart, t1.inindiv, t1.chgpage, t1.chgdate, t1.chgprog, t1.chgtype, t1.chguser, t1.inalloc, t1.inamu, t1.inback, t1.inbin, t1.inc01, t1.inc02, t1.inc03, t1.inc04, t1.inc05, t1.inc06, t1.inc07, t1.inc08, t1.inc09, t1.inc10, t1.inc11, t1.inc12, t1.inc13, t1.incanyr, t1.incntdte, t1.incntstat, t1.incyavg, t1.inentdte, t1.inguide, t1.inlost, t1.inlstrec, t1.inlstsld, t1.inmax, t1.inmaxstk, t1.inmbin, t1.inmin, t1.inmtop, t1.inodate, t1.inopen, t1.inp00, t1.inp01, t1.inp02, t1.inp03, t1.inp04, t1.inp05, t1.inp06, t1.inp07, t1.inp08, t1.inp09, t1.inp10, t1.inp11, t1.inp12, t1.inp13, t1.inpercnt, t1.inperptr, t1.inpyavg, t1.inqbo, t1.inqfinv, t1.inqiq, t1.inqoh, t1.inqoo, t1.inqpi, t1.inreordr, t1.inreqdte, t1.inreqqty, t1.inshelf, t1.intranst, t1.invar, t1.REC_ID FROM CMSDB.INPARTMASTER t0 LEFT OUTER JOIN CMSDB.Inmaster t1 ON t0.incomp = t1.incomp AND t0.inpart = t1.inpart WHERE t0.incomp = ? AND t0.inpart = ? [params=?, ?] 6212 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 1411809407> [7 ms] spent 6214 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerImpl@4ab3a5d1.close() invoked. 2011-01-25 10:27:08,576 INFO [] com.ais.persistence.InpartmasterTest:171 - recId=16503 2011-01-25 10:27:08,577 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:237 - Setting Chgprog to JPATest for this thread. 2011-01-25 10:27:08,577 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:225 - Setting Chgusername to InpartmasterTest for this thread. 2011-01-25 10:27:08,577 INFO [] com.ais.persistence.InpartmasterTest:185 - update 6216 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Found datasource 2: datasource -607958316 from config. StoreContext: org.apache.openjpa.kernel.BrokerImpl@e776f7 6216 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerFactoryImpl@2e39060b created EntityManager org.apache.openjpa.persistence.EntityManagerImpl@e776f7. 6217 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 1143424520> executing prepstmnt 505410915 SELECT t0.chgpage, t0.chgdate, t0.chgprog, t0.chgtype, t0.chguser, t0.inactype, t0.inalt1, t0.inalt2, t0.inalt3, t0.inata, t0.inclass, t0.incntiv, t0.incomt, t0.indcost, t0.indcostro, t0.indcostropvcr, t0.indepot, t0.indescr, t0.inetops, t0.inexchg, t0.inexcis, t0.infill1, t0.ingrp, t0.inhazmatind, t0.inidxflg, t0.inisunit, t0.inlead, t0.inlohi, t0.inlprice, t0.inmethod, t0.inmfg, t0.innotes, t0.inodisc, t0.inpartnd, t0.inpdisc, t0.inpkg, t0.inpkgbrk, t0.inplno, t0.inprev, t0.inprice, t0.inreturn, t0.inrvflg, t0.inshippref, t0.inshlind, t0.insos, t0.instatus, t0.insuperced, t0.interchg, t0.intypart, t0.intype, t0.invcost1, t0.invcost2, t0.invcost3, t0.invcost4, t0.invdate1, t0.invdate2, t0.invdate3, t0.invdate4, t0.invend, t0.invend1, t0.invend2, t0.invend3, t0.invend4, t0.invendlt, t0.invendro, t0.invendropref, t0.inwarflg, t0.inwprice, t0.inwrkscp, t0.incomp, t0.inpart, t0.REC_ID, t1.incomp, t1.inpart, t1.inindiv, t1.chgpage, t1.chgdate, t1.chgprog, t1.chgtype, t1.chguser, t1.inalloc, t1.inamu, t1.inback, t1.inbin, t1.inc01, t1.inc02, t1.inc03, t1.inc04, t1.inc05, t1.inc06, t1.inc07, t1.inc08, t1.inc09, t1.inc10, t1.inc11, t1.inc12, t1.inc13, t1.incanyr, t1.incntdte, t1.incntstat, t1.incyavg, t1.inentdte, t1.inguide, t1.inlost, t1.inlstrec, t1.inlstsld, t1.inmax, t1.inmaxstk, t1.inmbin, t1.inmin, t1.inmtop, t1.inodate, t1.inopen, t1.inp00, t1.inp01, t1.inp02, t1.inp03, t1.inp04, t1.inp05, t1.inp06, t1.inp07, t1.inp08, t1.inp09, t1.inp10, t1.inp11, t1.inp12, t1.inp13, t1.inpercnt, t1.inperptr, t1.inpyavg, t1.inqbo, t1.inqfinv, t1.inqiq, t1.inqoh, t1.inqoo, t1.inqpi, t1.inreordr, t1.inreqdte, t1.inreqqty, t1.inshelf, t1.intranst, t1.invar, t1.REC_ID FROM CMSDB.INPARTMASTER t0 LEFT OUTER JOIN CMSDB.Inmaster t1 ON t0.incomp = t1.incomp AND t0.inpart = t1.inpart WHERE t0.incomp = ? AND t0.inpart = ? [params=?, ?] 6224 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 1143424520> [7 ms] spent 6227 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerImpl@e776f7.close() invoked. 2011-01-25 10:27:08,589 INFO [] com.ais.persistence.InpartmasterTest:191 - com.ais.persistence.entities.Inpartmaster@5b58539f 6228 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Found datasource 2: datasource -607958316 from config. StoreContext: org.apache.openjpa.kernel.BrokerImpl@3da1a93 6228 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerFactoryImpl@2e39060b created EntityManager org.apache.openjpa.persistence.EntityManagerImpl@3da1a93. 6235 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 804539046> executing prepstmnt 321652935 SELECT t0.chgpage FROM CMSDB.INPARTMASTER t0 WHERE t0.incomp = ? AND t0.inpart = ? [params=?, ?] 6236 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 804539046> [1 ms] spent 6237 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerImpl@3da1a93.close() invoked. 2011-01-25 10:27:08,599 INFO [] com.ais.persistence.InpartmasterTest:198 - recId=16503 2011-01-25 10:27:08,599 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:237 - Setting Chgprog to JPATest for this thread. 2011-01-25 10:27:08,600 INFO [] com.cms.shared.ext.firestorm.FirestormUtil:225 - Setting Chgusername to InpartmasterTest for this thread. 6238 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - Found datasource 2: datasource -607958316 from config. StoreContext: org.apache.openjpa.kernel.BrokerImpl@4af08d0f 6238 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerFactoryImpl@2e39060b created EntityManager org.apache.openjpa.persistence.EntityManagerImpl@4af08d0f. 6266 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 907430540> executing prepstmnt 1866436667 select * from INPARTMASTER where incomp = ? and inpart like ? [params=?, ?] 6271 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.jdbc.SQL - <t 1586592944, conn 907430540> [5 ms] spent 2011-01-25 10:27:08,667 INFO [] com.ais.persistence.entities.dao.InpartmasterDao:69 - InpartmasterManager:getInpartmasterByCompanyPartLike(): results.size()==>5 6306 airweb-JPA-J2-SNAPSHOT TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerImpl@4af08d0f.close() invoked. 2011-01-25 10:27:08,670 INFO [] com.ais.persistence.InpartmasterTest:243 - com.ais.persistence.entities.Inpartmaster@57d7e64f 2011-01-25 10:27:08,670 INFO [] com.ais.persistence.InpartmasterTest:243 - com.ais.persistence.entities.Inpartmaster@1f517997 2011-01-25 10:27:08,671 INFO [] com.ais.persistence.InpartmasterTest:243 - com.ais.persistence.entities.Inpartmaster@1e05b891 2011-01-25 10:27:08,671 INFO [] com.ais.persistence.InpartmasterTest:243 - com.ais.persistence.entities.Inpartmaster@99846fd 2011-01-25 10:27:08,672 INFO [] com.ais.persistence.InpartmasterTest:243 - com.ais.persistence.entities.Inpartmaster@6c5c90f6 -- View this message in context: http://openjpa.208410.n2.nabble.com/How-to-get-generated-keys-without-requerying-the-database-tp5957346p5959976.html Sent from the OpenJPA Users mailing list archive at Nabble.com.