Rob,
Thanks for the additional info and trace. I'll try to reproduce this
locally. What level of DB2 and JCC driver are you using? I scanned the
trace, but neither jumped out at me.
-Jeremy
On Tue, Jan 25, 2011 at 12:36 PM, robsinner <robsin...@yahoo.com> wrote:
>
> 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.
>
