openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From robsinner <robsin...@yahoo.com>
Subject Re: How to get generated keys without requerying the database?
Date Tue, 25 Jan 2011 18:36:58 GMT

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.

Mime
View raw message