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 -
[email protected]() 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 -
[email protected]() 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 -
[email protected]() 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 -
[email protected]() 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 -
[email protected]() 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 -
[email protected]() 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.
