openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From George Hongell <ghong...@us.ibm.com>
Subject Re: openjpa NativeQuery and NamedNativeQuery only allow select sql statements
Date Mon, 04 Dec 2006 23:05:09 GMT
Hi Marc,
Can you tell me how to get the nested stack trace(s)?

I am running in eclipse and my persistence.xml now has
                        <property name="openjpa.Log" 
value="File=stderr,Runtime=TRACE,SQL=TRACE,JDBC=TRACE,QUERY=TRACE"/>

my junit stack trace still looks like
<4|false|0.0.0> org.apache.openjpa.persistence.InvalidStateException: 
Cannot perform an update or delete operation on select query: "insert into 
DeptBean  (deptno) values  (?)".
        at 
org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:306)
        at 
com.ibm.ws.query.tests.JUNamedNativeQueryTest.testInsertQuery(JUNamedNativeQueryTest.java:315)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:615)
        at junit.framework.TestCase.runTest(Unknown Source)
        at junit.framework.TestCase.runBare(Unknown Source)
        at junit.framework.TestResult$1.protect(Unknown Source)
        at junit.framework.TestResult.runProtected(Unknown Source)
        at junit.framework.TestResult.run(Unknown Source)
        at junit.framework.TestCase.run(Unknown Source)
        at junit.framework.TestSuite.runTest(Unknown Source)
        at junit.framework.TestSuite.run(Unknown Source)
        at 
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
        at 
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
        at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
        at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
        at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
        at 
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

my output console looks like
16  mdd  TRACE  [main] openjpa.Runtime - Setting the following properties 
from 
"file:/C:/apacheEclipse3.2/openjpa_096_incubating/workspace/jpa.test/bin/META-INF/persistence.xml" 
into configuration: 
{openjpa.jdbc.SynchronizeMappings=buildSchema(ForeignKeys=true), 
openjpa.ConnectionDriverName=org.apache.commons.dbcp.BasicDataSource, 
openjpa.ConnectionProperties=DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:tmp/mdd-test-database;create=true, 
openjpa.MetaDataFactory=Resources=META-INF/queryTestCatalogAno.xml, 
openjpa.Id=mdd, 
openjpa.Log=File=stderr,Runtime=TRACE,SQL=TRACE,JDBC=TRACE,QUERY=TRACE, 
openjpa.BrokerFactory=jdbc}
94  mdd  INFO   [main] openjpa.Runtime - Starting OpenJPA 0.0.0
94  mdd  TRACE  [main] openjpa.Runtime - Properties: openjpa.AutoDetach: 
openjpa.MetaDataFactory: Resources=META-INF/queryTestCatalogAno.xml
openjpa.EntityManagerFactory: default
openjpa.ProxyManager: default
openjpa.jdbc.EagerFetchMode: parallel
openjpa.DataCache: false
openjpa.LockTimeout: -1
openjpa.Id: mdd
openjpa.QueryCache: true
openjpa.BrokerImpl: default
openjpa.BrokerFactory: jdbc
openjpa.Compatibility: default
openjpa.FetchGroups: default
openjpa.ConnectionDriverName: org.apache.commons.dbcp.BasicDataSource
openjpa.QueryCompilationCache: true
openjpa.DataCacheTimeout: -1
openjpa.NontransactionalWrite: true
openjpa.RetryClassRegistration: false
openjpa.jdbc.TransactionIsolation: default
openjpa.Multithreaded: false
openjpa.TransactionMode: local
openjpa.ConnectionRetainMode: on-demand
openjpa.AutoClear: datastore
openjpa.Sequence: table
openjpa.jdbc.Schemas: 
openjpa.WriteLockLevel: write
openjpa.MetaDataRepository: default
openjpa.DynamicDataStructs: false
openjpa.RetainState: true
openjpa.ConnectionProperties: 
DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:tmp/mdd-test-database;create=true
openjpa.Optimistic: true
openjpa.jdbc.ResultSetType: forward-only
openjpa.LockManager: version
openjpa.RestoreState: immutable
openjpa.jdbc.SynchronizeMappings: buildSchema(ForeignKeys=true)
openjpa.jdbc.FetchDirection: forward
openjpa.InverseManager: false
openjpa.jdbc.LRSSize: query
openjpa.jdbc.SQLFactory: default
openjpa.DataCacheManager: default
openjpa.MaxFetchDepth: -1
openjpa.NontransactionalRead: true
openjpa.jdbc.MappingDefaults: jpa
openjpa.ReadLockLevel: read
openjpa.ClassResolver: default
openjpa.FlushBeforeQueries: true
openjpa.FetchBatchSize: -1
openjpa.SavepointManager: in-mem
openjpa.ManagedRuntime: auto
openjpa.IgnoreChanges: false
openjpa.jdbc.SchemaFactory: dynamic
openjpa.ConnectionFactoryMode: local
openjpa.OrphanedKeyAction: log
openjpa.jdbc.SubclassFetchMode: join
openjpa.jdbc.UpdateManager: default
openjpa.Log: File=stderr,Runtime=TRACE,SQL=TRACE,JDBC=TRACE,QUERY=TRACE
openjpa.jdbc.DriverDataSource: simple
openjpa.DetachState: loaded
203  mdd  INFO   [main] openjpa.jdbc.JDBC - OpenJPA will now connect to 
the database to attempt to determine what type of database dictionary to 
use.  To prevent this connection in the future, set your 
openjpa.jdbc.DBDictionary configuration property to the appropriate value 
for your database (see the documentation for available values).
1781  mdd  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class 
"org.apache.openjpa.jdbc.sql.DerbyDictionary" (Apache Derby 10.1.3.2 
,Apache Derby Embedded JDBC Driver 10.1.3.2).
1797  mdd  TRACE  [main] openjpa.jdbc.JDBC - catalogSeparator: 
catalogTerm: CATALOG
databaseProductName: Apache Derby
databaseProductVersion: 10.1.3.2
driverName: Apache Derby Embedded JDBC Driver
driverVersion: 10.1.3.2
extraNameCharacters: 
identifierQuoteString: "
numericFunctions: ABS,SQRT
procedureTerm: PROCEDURE
schemaTerm: SCHEMA
searchStringEscape: 
sqlKeywords: 
ALIAS,BIGINT,BOOLEAN,CALL,CLASS,COPY,DB2J_DEBUG,EXECUTE,EXPLAIN,FILE,FILTER,GETCURRENTCONNECTION,INDEX,INSTANCEOF,METHOD,NEW,OFF,PROPERTIES,PUBLICATION,RECOMPILE,REFRESH,RENAME,RUNTIMESTATISTICS,STATEMENT,STATISTICS,TIMING,WAIT
stringFunctions: LENGTH,LOWER,LTRIM,RTRIM,SUBSTR,SUBSTRING,UPPER
systemFunctions: 
CURRENT_USER,getCurrentConnection,runTimeStatistics,SESSION_USER,USER,CURRENT 
SCHEMA
timeDateFunctions: 
CURDATE,CURTIME,CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,EXTRACT
url: jdbc:derby:tmp/mdd-test-database
userName: APP
defaultTransactionIsolation: 2
driverMajorVersion: 10
driverMinorVersion: 1
maxBinaryLiteralLength: 0
maxCatalogNameLength: 0
maxCharLiteralLength: 0
maxColumnNameLength: 128
maxColumnsInGroupBy: 0
maxColumnsInIndex: 0
maxColumnsInOrderBy: 0
maxColumnsInSelect: 0
maxColumnsInTable: 0
maxConnections: 0
maxCursorNameLength: 128
maxIndexLength: 0
maxProcedureNameLength: 128
maxRowSize: 0
maxSchemaNameLength: 128
maxStatementLength: 0
maxStatements: 0
maxTableNameLength: 128
maxTablesInSelect: 0
maxUserNameLength: 30
isCatalogAtStart: false
isReadOnly: false
nullPlusNonNullIsNull: true
nullsAreSortedAtEnd: false
nullsAreSortedAtStart: false
nullsAreSortedHigh: true
nullsAreSortedLow: false
storesLowerCaseIdentifiers: false
storesLowerCaseQuotedIdentifiers: false
storesMixedCaseIdentifiers: false
storesMixedCaseQuotedIdentifiers: true
storesUpperCaseIdentifiers: true
storesUpperCaseQuotedIdentifiers: false
supportsAlterTableWithAddColumn: true
supportsAlterTableWithDropColumn: true
supportsANSI92EntryLevelSQL: false
supportsANSI92FullSQL: false
supportsANSI92IntermediateSQL: false
supportsCatalogsInDataManipulation: false
supportsCatalogsInIndexDefinitions: false
supportsCatalogsInPrivilegeDefinitions: false
supportsCatalogsInProcedureCalls: false
supportsCatalogsInTableDefinitions: false
supportsColumnAliasing: true
supportsConvert: true
supportsCoreSQLGrammar: false
supportsCorrelatedSubqueries: true
supportsDataDefinitionAndDataManipulationTransactions: true
supportsDataManipulationTransactionsOnly: false
supportsDifferentTableCorrelationNames: true
supportsExpressionsInOrderBy: false
supportsExtendedSQLGrammar: false
supportsFullOuterJoins: false
supportsGroupBy: true
supportsGroupByBeyondSelect: true
supportsGroupByUnrelated: true
supportsIntegrityEnhancementFacility: false
supportsLikeEscapeClause: true
supportsLimitedOuterJoins: true
supportsMinimumSQLGrammar: true
supportsMixedCaseIdentifiers: false
supportsMixedCaseQuotedIdentifiers: true
supportsMultipleResultSets: true
supportsMultipleTransactions: true
supportsNonNullableColumns: true
supportsOpenCursorsAcrossCommit: false
supportsOpenCursorsAcrossRollback: false
supportsOpenStatementsAcrossCommit: true
supportsOpenStatementsAcrossRollback: false
supportsOrderByUnrelated: false
supportsOuterJoins: true
supportsPositionedDelete: true
supportsPositionedUpdate: true
supportsSchemasInDataManipulation: true
supportsSchemasInIndexDefinitions: true
supportsSchemasInPrivilegeDefinitions: true
supportsSchemasInProcedureCalls: true
supportsSchemasInTableDefinitions: true
supportsSelectForUpdate: true
supportsStoredProcedures: true
supportsSubqueriesInComparisons: true
supportsSubqueriesInExists: true
supportsSubqueriesInIns: true
supportsSubqueriesInQuantifieds: true
supportsTableCorrelationNames: true
supportsTransactions: true
supportsUnion: true
supportsUnionAll: true
usesLocalFilePerTable: true
usesLocalFiles: true
allProceduresAreCallable: true
allTablesAreSelectable: true
dataDefinitionCausesTransactionCommit: false
dataDefinitionIgnoredInTransactions: false
doesMaxRowSizeIncludeBlobs: true
supportsBatchUpdates: true
1813  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
2047  mdd  INFO   [main] openjpa.MetaData - Found 15 classes with metadata 
in 62 milliseconds.
2188  mdd  INFO   [main] openjpa.MetaData - Found 15 classes with metadata 
in 47 milliseconds.
2266  mdd  INFO   [main] openjpa.MetaData - Parsing resource 
"file:/C:/apacheEclipse3.2/openjpa_096_incubating/workspace/jpa.test/bin/META-INF/queryTestCatalogAno.xml".
2485  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.DeptBean".
2516  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.DeptBean".
2516  mdd  INFO   [main] openjpa.MetaData - Parsing package 
"com.ibm.ws.query.entities.objectgrid.annotated.DeptBean".
2563  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"findAllDepartmentsLikeName".
2563  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"joinDeptWithEmps".
2563  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"deleteDepartmentsGreaterThan".
2563  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"updateDeptBudget".
2563  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"updateDeptBudgetForParent".
2563  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeFindAllDepartmentNumbersLikeName".
2578  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeFindAllDepartmentColumns".
2578  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeFindAllDepartments".
2578  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeDeleteDepartmentsGreaterThan".
2578  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeUpdateDeptBudget".
2578  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeUpdateDeptBudgetForParent".
2625  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.EmpBean".
2625  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.EmpBean".
2656  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.ProjectBean".
2656  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.ProjectBean".
2672  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TaskBean".
2672  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TaskBean".
2688  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.AddressBean".
2688  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.AddressBean".
2703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TypeTestBean".
2719  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TypeTestBean".
2719  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Customer".
2735  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Customer".
2735  mdd  INFO   [main] openjpa.MetaData - Parsing package 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Customer".
2735  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.LineItem".
2735  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.LineItem".
2750  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Order".
2813  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Order".
2813  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Part".
2813  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Part".
2844  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartBase".
2844  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartBase".
2844  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartComposite".
2844  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartComposite".
2844  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Product".
2844  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Product".
2860  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Supplier".
2860  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Supplier".
2860  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Usage".
2860  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Usage".
2906  mdd  WARN   [main] openjpa.MetaData - OpenJPA cannot map field 
"com.ibm.ws.query.entities.objectgrid.annotated.TypeTestBean.obytes" 
efficiently.  It is of an unsupported type. The field value will be 
serialized to a BLOB by default.
2985  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "AddressBean".
2985  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
2985  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, ADDRESSBEAN, null
3235  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Customerparttab".
3235  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3235  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, CUSTOMERPARTTAB, null
3250  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "DeptBean".
3250  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3250  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, DEPTBEAN, null
3250  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "EmpBean".
3250  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3250  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, EMPBEAN, null
3266  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "LineItemparttab".
3266  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3266  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, LINEITEMPARTTAB, null
3281  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Orderparttab".
3281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, ORDERPARTTAB, null
3297  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "parttab".
3297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, PARTTAB, null
3313  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Productparttab".
3313  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3313  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, PRODUCTPARTTAB, null
3313  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "ProjectBean".
3313  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3313  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, PROJECTBEAN, null
3328  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Supplierparttab".
3328  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3328  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, SUPPLIERPARTTAB, null
3328  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Supplierparttab_parttab".
3328  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3328  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, SUPPLIERPARTTAB_PARTTAB, null
3328  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "TaskBean".
3328  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3328  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, TASKBEAN, null
3344  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "TaskBean_EmpBean".
3344  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3344  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, TASKBEAN_EMPBEAN, null
3344  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "TypeTestBean".
3344  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3344  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, TYPETESTBEAN, null
3360  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Usageparttab".
3360  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3360  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getColumns: null, null, USAGEPARTTAB, null
3375  mdd  INFO   [main] openjpa.jdbc.Schema - Reading sequence 
information for schema "null", sequence name "null".
3375  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] commit
3375  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
3375  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3375  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, ADDRESSBEAN
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, CUSTOMERPARTTAB
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, DEPTBEAN
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, EMPBEAN
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, LINEITEMPARTTAB
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3406  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, ORDERPARTTAB
3422  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3422  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, PARTTAB
3422  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3422  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, PRODUCTPARTTAB
3422  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3422  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, PROJECTBEAN
3422  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3438  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, SUPPLIERPARTTAB
3438  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3438  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, SUPPLIERPARTTAB_PARTTAB
3453  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3453  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, TASKBEAN
3453  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3453  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, TASKBEAN_EMPBEAN
3453  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3453  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, TYPETESTBEAN
3453  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] rollback
3453  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> getImportedKeys: null, null, USAGEPARTTAB
3485  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [0 ms] commit
3485  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
3594  mdd  INFO   [main] openjpa.MetaData - Parsing resource 
"file:/C:/apacheEclipse3.2/openjpa_096_incubating/workspace/jpa.test/bin/META-INF/queryTestCatalogAno.xml".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.DeptBean".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.DeptBean".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing package 
"com.ibm.ws.query.entities.objectgrid.annotated.DeptBean".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"findAllDepartmentsLikeName".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"joinDeptWithEmps".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"deleteDepartmentsGreaterThan".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"updateDeptBudget".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"updateDeptBudgetForParent".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeFindAllDepartmentNumbersLikeName".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeFindAllDepartmentColumns".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeFindAllDepartments".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeDeleteDepartmentsGreaterThan".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeUpdateDeptBudget".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeUpdateDeptBudgetForParent".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.EmpBean".
3641  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.EmpBean".
3656  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.ProjectBean".
3656  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.ProjectBean".
3656  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TaskBean".
3656  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TaskBean".
3672  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.AddressBean".
3672  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.AddressBean".
3672  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TypeTestBean".
3672  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TypeTestBean".
3672  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Customer".
3672  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Customer".
3672  mdd  INFO   [main] openjpa.MetaData - Parsing package 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Customer".
3688  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.LineItem".
3688  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.LineItem".
3688  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Order".
3688  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Order".
3688  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Part".
3688  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Part".
3688  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartBase".
3703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartBase".
3703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartComposite".
3703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartComposite".
3703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Product".
3703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Product".
3703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Supplier".
3703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Supplier".
3703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Usage".
3703  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Usage".
4125  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 862729068 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t2.reportsTo_deptno, t1.execLevel, t1.hireDate, t1.hireTime, 
t1.hireTimestamp, t3.street, t3.city, t3.state, t3.zip, t1.isManager, 
t1.name, t1.salary, t4.street, t4.city, t4.state, t4.zip, t0.name, 
t5.deptno, t5.budget, t5.mgr_empid, t5.name FROM DeptBean t0 LEFT OUTER 
JOIN EmpBean t1 ON t0.mgr_empid = t1.empid LEFT OUTER JOIN DeptBean t5 ON 
t0.reportsTo_deptno = t5.deptno LEFT OUTER JOIN DeptBean t2 ON 
t1.dept_deptno = t2.deptno LEFT OUTER JOIN AddressBean t3 ON 
t1.home_street = t3.street LEFT OUTER JOIN AddressBean t4 ON 
t1.work_street = t4.street
4141  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [16 ms] spent
4313  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1094992196 SELECT t0.bonus, t1.deptno, 
t1.budget, t1.name, t0.execLevel, t0.hireDate, t0.hireTime, 
t0.hireTimestamp, t2.street, t2.city, t2.state, t2.zip, t0.isManager, 
t0.name, t0.salary, t3.street, t3.city, t3.state, t3.zip FROM EmpBean t0 
LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno LEFT OUTER JOIN 
AddressBean t2 ON t0.home_street = t2.street LEFT OUTER JOIN AddressBean 
t3 ON t0.work_street = t3.street WHERE t0.empid = ? [params=(int) 8]
4313  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 95159724 SELECT t1.empid, t1.bonus, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t2.street, 
t2.city, t2.state, t2.zip, t1.isManager, t1.name, t1.salary, t3.street, 
t3.city, t3.state, t3.zip FROM DeptBean t0 INNER JOIN EmpBean t1 ON 
t0.mgr_empid = t1.empid LEFT OUTER JOIN AddressBean t2 ON t1.home_street = 
t2.street LEFT OUTER JOIN AddressBean t3 ON t1.work_street = t3.street 
WHERE t0.deptno = ? [params=(int) 100]
4422  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [31 ms] spent
4438  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4578  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 788672258 SELECT t0.empid, t0.bonus, 
t1.deptno, t1.budget, t2.empid, t2.bonus, t2.dept_deptno, t2.execLevel, 
t2.hireDate, t2.hireTime, t2.hireTimestamp, t2.home_street, t2.isManager, 
t2.name, t2.salary, t2.work_street, t1.name, t3.deptno, t3.budget, 
t3.mgr_empid, t3.name, t0.execLevel, t0.hireDate, t0.hireTime, 
t0.hireTimestamp, t4.street, t4.city, t4.state, t4.zip, t0.isManager, 
t0.name, t0.salary, t5.street, t5.city, t5.state, t5.zip FROM EmpBean t0 
LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno LEFT OUTER JOIN 
AddressBean t4 ON t0.home_street = t4.street LEFT OUTER JOIN AddressBean 
t5 ON t0.work_street = t5.street LEFT OUTER JOIN EmpBean t2 ON 
t1.mgr_empid = t2.empid LEFT OUTER JOIN DeptBean t3 ON t1.reportsTo_deptno 
= t3.deptno WHERE t0.dept_deptno = ? [params=(int) 210]
4594  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [16 ms] spent
4610  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4719  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 405280808 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 1]
4719  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4719  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4735  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 2107145624 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 2]
4735  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4735  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4750  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1435391374 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 7]
4750  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4750  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4750  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1000618916 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 9]
4750  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4750  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4766  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 565715384 SELECT t0.empid, t0.bonus, 
t1.deptno, t1.budget, t2.empid, t2.bonus, t2.dept_deptno, t2.execLevel, 
t2.hireDate, t2.hireTime, t2.hireTimestamp, t2.home_street, t2.isManager, 
t2.name, t2.salary, t2.work_street, t1.name, t3.deptno, t3.budget, 
t3.mgr_empid, t3.name, t0.execLevel, t0.hireDate, t0.hireTime, 
t0.hireTimestamp, t4.street, t4.city, t4.state, t4.zip, t0.isManager, 
t0.name, t0.salary, t5.street, t5.city, t5.state, t5.zip FROM EmpBean t0 
LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno LEFT OUTER JOIN 
AddressBean t4 ON t0.home_street = t4.street LEFT OUTER JOIN AddressBean 
t5 ON t0.work_street = t5.street LEFT OUTER JOIN EmpBean t2 ON 
t1.mgr_empid = t2.empid LEFT OUTER JOIN DeptBean t3 ON t1.reportsTo_deptno 
= t3.deptno WHERE t0.dept_deptno = ? [params=(int) 220]
4766  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4781  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4813  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 189664078 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 5]
4813  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4813  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4828  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1025785124 SELECT t0.empid, t0.bonus, 
t1.deptno, t1.budget, t2.empid, t2.bonus, t2.dept_deptno, t2.execLevel, 
t2.hireDate, t2.hireTime, t2.hireTimestamp, t2.home_street, t2.isManager, 
t2.name, t2.salary, t2.work_street, t1.name, t3.deptno, t3.budget, 
t3.mgr_empid, t3.name, t0.execLevel, t0.hireDate, t0.hireTime, 
t0.hireTimestamp, t4.street, t4.city, t4.state, t4.zip, t0.isManager, 
t0.name, t0.salary, t5.street, t5.city, t5.state, t5.zip FROM EmpBean t0 
LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno LEFT OUTER JOIN 
AddressBean t4 ON t0.home_street = t4.street LEFT OUTER JOIN AddressBean 
t5 ON t0.work_street = t5.street LEFT OUTER JOIN EmpBean t2 ON 
t1.mgr_empid = t2.empid LEFT OUTER JOIN DeptBean t3 ON t1.reportsTo_deptno 
= t3.deptno WHERE t0.dept_deptno = ? [params=(int) 300]
4828  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4828  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4844  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 696002940 SELECT t0.empid, t0.bonus, 
t1.deptno, t1.budget, t2.empid, t2.bonus, t2.dept_deptno, t2.execLevel, 
t2.hireDate, t2.hireTime, t2.hireTimestamp, t2.home_street, t2.isManager, 
t2.name, t2.salary, t2.work_street, t1.name, t3.deptno, t3.budget, 
t3.mgr_empid, t3.name, t0.execLevel, t0.hireDate, t0.hireTime, 
t0.hireTimestamp, t4.street, t4.city, t4.state, t4.zip, t0.isManager, 
t0.name, t0.salary, t5.street, t5.city, t5.state, t5.zip FROM EmpBean t0 
LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno LEFT OUTER JOIN 
AddressBean t4 ON t0.home_street = t4.street LEFT OUTER JOIN AddressBean 
t5 ON t0.work_street = t5.street LEFT OUTER JOIN EmpBean t2 ON 
t1.mgr_empid = t2.empid LEFT OUTER JOIN DeptBean t3 ON t1.reportsTo_deptno 
= t3.deptno WHERE t0.dept_deptno = ? [params=(int) 200]
4844  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4844  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4860  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 67634184 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 3]
4860  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4860  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4875  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1981969954 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 4]
4875  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4875  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4891  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1279151166 SELECT t0.empid, t0.bonus, 
t1.deptno, t1.budget, t2.empid, t2.bonus, t2.dept_deptno, t2.execLevel, 
t2.hireDate, t2.hireTime, t2.hireTimestamp, t2.home_street, t2.isManager, 
t2.name, t2.salary, t2.work_street, t1.name, t3.deptno, t3.budget, 
t3.mgr_empid, t3.name, t0.execLevel, t0.hireDate, t0.hireTime, 
t0.hireTimestamp, t4.street, t4.city, t4.state, t4.zip, t0.isManager, 
t0.name, t0.salary, t5.street, t5.city, t5.state, t5.zip FROM EmpBean t0 
LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno LEFT OUTER JOIN 
AddressBean t4 ON t0.home_street = t4.street LEFT OUTER JOIN AddressBean 
t5 ON t0.work_street = t5.street LEFT OUTER JOIN EmpBean t2 ON 
t1.mgr_empid = t2.empid LEFT OUTER JOIN DeptBean t3 ON t1.reportsTo_deptno 
= t3.deptno WHERE t0.dept_deptno = ? [params=(int) 100]
4891  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4891  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4891  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1680761902 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 6]
4891  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4906  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
4906  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 416684246 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 8]
4906  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
4906  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
5016  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1907257774 DELETE FROM TaskBean_EmpBean 
WHERE empid = ? [params=(int) 1]
5016  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5016  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 2047769102 DELETE FROM TaskBean_EmpBean 
WHERE empid = ? [params=(int) 2]
5016  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5016  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 500964828 DELETE FROM TaskBean_EmpBean 
WHERE empid = ? [params=(int) 7]
5016  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1043086892 DELETE FROM TaskBean_EmpBean 
WHERE empid = ? [params=(int) 9]
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 3932220 DELETE FROM TaskBean_EmpBean WHERE 
empid = ? [params=(int) 5]
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 703343084 DELETE FROM TaskBean_EmpBean 
WHERE empid = ? [params=(int) 3]
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1508006370 DELETE FROM TaskBean_EmpBean 
WHERE empid = ? [params=(int) 4]
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1959163078 DELETE FROM TaskBean_EmpBean 
WHERE empid = ? [params=(int) 6]
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 618669280 DELETE FROM TaskBean_EmpBean 
WHERE empid = ? [params=(int) 8]
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5031  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1020542164 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 1]
5047  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [16 ms] spent
5047  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1529240358 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 2]
5047  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5047  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 826683718 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 7]
5047  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5047  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1441289704 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 9]
5047  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5047  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1820617860 DELETE FROM DeptBean WHERE 
deptno = ? [params=(int) 210]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 983186074 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 5]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1875406792 DELETE FROM DeptBean WHERE 
deptno = ? [params=(int) 220]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 190712670 DELETE FROM DeptBean WHERE 
deptno = ? [params=(int) 300]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 758000942 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 3]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 152439062 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 4]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1990227616 DELETE FROM DeptBean WHERE 
deptno = ? [params=(int) 200]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1352290458 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 6]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 432413126 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 8]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 975714856 DELETE FROM DeptBean WHERE 
deptno = ? [params=(int) 100]
5063  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5110  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 584852188 SELECT t2.taskid, t2.cost, 
t2.description, t2.name, t2.project_projid FROM EmpBean t0 INNER JOIN 
TaskBean_EmpBean t1 ON t0.empid = t1.empid INNER JOIN TaskBean t2 ON 
t1.tasks_taskid = t2.taskid
5110  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5172  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 955267312 SELECT t0.taskid, t0.cost, 
t0.description, t0.name, t1.projid, t1.budget, t1.cost, t2.deptno, 
t2.budget, t3.empid, t3.bonus, t4.deptno, t4.budget, t4.mgr_empid, 
t4.name, t3.execLevel, t3.hireDate, t3.hireTime, t3.hireTimestamp, 
t5.street, t5.city, t5.state, t5.zip, t3.isManager, t3.name, t3.salary, 
t6.street, t6.city, t6.state, t6.zip, t2.name, t7.deptno, t7.budget, 
t7.mgr_empid, t7.name, t1.description, t1.durationDays, t1.name, 
t1.personMonths, t1.startTime FROM TaskBean t0 LEFT OUTER JOIN ProjectBean 
t1 ON t0.project_projid = t1.projid LEFT OUTER JOIN DeptBean t2 ON 
t1.dept_deptno = t2.deptno LEFT OUTER JOIN EmpBean t3 ON t2.mgr_empid = 
t3.empid LEFT OUTER JOIN DeptBean t7 ON t2.reportsTo_deptno = t7.deptno 
LEFT OUTER JOIN DeptBean t4 ON t3.dept_deptno = t4.deptno LEFT OUTER JOIN 
AddressBean t5 ON t3.home_street = t5.street LEFT OUTER JOIN AddressBean 
t6 ON t3.work_street = t6.street
5172  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5219  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 839528970 SELECT t0.empid, t0.bonus, 
t1.deptno, t1.budget, t2.empid, t2.bonus, t2.dept_deptno, t2.execLevel, 
t2.hireDate, t2.hireTime, t2.hireTimestamp, t2.home_street, t2.isManager, 
t2.name, t2.salary, t2.work_street, t1.name, t3.deptno, t3.budget, 
t3.mgr_empid, t3.name, t0.execLevel, t0.hireDate, t0.hireTime, 
t0.hireTimestamp, t4.street, t4.city, t4.state, t4.zip, t0.isManager, 
t0.name, t0.salary, t5.street, t5.city, t5.state, t5.zip FROM EmpBean t0 
LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno LEFT OUTER JOIN 
AddressBean t4 ON t0.home_street = t4.street LEFT OUTER JOIN AddressBean 
t5 ON t0.work_street = t5.street LEFT OUTER JOIN EmpBean t2 ON 
t1.mgr_empid = t2.empid LEFT OUTER JOIN DeptBean t3 ON t1.reportsTo_deptno 
= t3.deptno
5235  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5235  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1642619368 SELECT t0.deptno, t0.budget, 
t1.empid, t1.bonus, t2.deptno, t2.budget, t2.mgr_empid, t2.name, 
t1.execLevel, t1.hireDate, t1.hireTime, t1.hireTimestamp, t3.street, 
t3.city, t3.state, t3.zip, t1.isManager, t1.name, t1.salary, t4.street, 
t4.city, t4.state, t4.zip, t0.name, t5.deptno, t5.budget, t5.mgr_empid, 
t5.name FROM DeptBean t0 LEFT OUTER JOIN EmpBean t1 ON t0.mgr_empid = 
t1.empid LEFT OUTER JOIN DeptBean t5 ON t0.reportsTo_deptno = t5.deptno 
LEFT OUTER JOIN DeptBean t2 ON t1.dept_deptno = t2.deptno LEFT OUTER JOIN 
AddressBean t3 ON t1.home_street = t3.street LEFT OUTER JOIN AddressBean 
t4 ON t1.work_street = t4.street WHERE t0.mgr_empid = ? [params=(int) 10]
5235  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5281  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 771239416 SELECT t0.projid, t0.budget, 
t0.cost, t1.deptno, t1.budget, t2.empid, t2.bonus, t3.deptno, t3.budget, 
t3.mgr_empid, t3.name, t2.execLevel, t2.hireDate, t2.hireTime, 
t2.hireTimestamp, t4.street, t4.city, t4.state, t4.zip, t2.isManager, 
t2.name, t2.salary, t5.street, t5.city, t5.state, t5.zip, t1.name, 
t6.deptno, t6.budget, t6.mgr_empid, t6.name, t0.description, 
t0.durationDays, t0.name, t0.personMonths, t0.startTime FROM ProjectBean 
t0 LEFT OUTER JOIN DeptBean t1 ON t0.dept_deptno = t1.deptno LEFT OUTER 
JOIN EmpBean t2 ON t1.mgr_empid = t2.empid LEFT OUTER JOIN DeptBean t6 ON 
t1.reportsTo_deptno = t6.deptno LEFT OUTER JOIN DeptBean t3 ON 
t2.dept_deptno = t3.deptno LEFT OUTER JOIN AddressBean t4 ON 
t2.home_street = t4.street LEFT OUTER JOIN AddressBean t5 ON 
t2.work_street = t5.street
5297  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [16 ms] spent
5313  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1200244618 SELECT t0.street, t0.city, 
t0.state, t0.zip FROM AddressBean t0
5313  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5313  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1412584498 DELETE FROM TaskBean_EmpBean 
WHERE empid = ? [params=(int) 10]
5313  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 2002155350 DELETE FROM EmpBean WHERE empid 
= ? [params=(int) 10]
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 2059565762 DELETE FROM AddressBean WHERE 
street = ? [params=(String) 1780 Mercury Way]
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1641308628 DELETE FROM AddressBean WHERE 
street = ? [params=(String) 512 Venus Drive]
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 481434802 DELETE FROM AddressBean WHERE 
street = ? [params=(String) 12440 Vulcan Avenue]
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1015954574 DELETE FROM AddressBean WHERE 
street = ? [params=(String) 4983 Plutonium Avenue]
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1544182794 DELETE FROM AddressBean WHERE 
street = ? [params=(String) 182 Martian Street]
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1856401062 DELETE FROM AddressBean WHERE 
street = ? [params=(String) 555 Silicon Valley Drive]
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 53347118 DELETE FROM AddressBean WHERE 
street = ? [params=(String) 6200 Vegas Drive]
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5328  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 342103140 DELETE FROM AddressBean WHERE 
street = ? [params=(String) 150 North First Apt E1]
5344  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [16 ms] spent
5344  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 681846948 DELETE FROM AddressBean WHERE 
street = ? [params=(String) 8900 Jupiter Park]
5344  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5360  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1012153428 INSERT INTO DeptBean (deptno, 
budget, name, mgr_empid, reportsTo_deptno) VALUES (?, ?, ?, ?, ?) 
[params=(int) 210, (float) 2.1, (String) Development, (int) 3, (int) 200]
5375  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [15 ms] spent
5375  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1038237154 INSERT INTO DeptBean (deptno, 
budget, name, mgr_empid, reportsTo_deptno) VALUES (?, ?, ?, ?, ?) 
[params=(int) 220, (float) 2.1, (String) Service, (int) 4, (int) 200]
5375  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5375  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 53609266 INSERT INTO DeptBean (deptno, 
budget, name, mgr_empid, reportsTo_deptno) VALUES (?, ?, ?, ?, ?) 
[params=(int) 300, (float) 2.1, (String) Sales, (int) 6, (int) 100]
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1382175330 INSERT INTO DeptBean (deptno, 
budget, name, mgr_empid, reportsTo_deptno) VALUES (?, ?, ?, ?, ?) 
[params=(int) 200, (float) 2.1, (String) Admin, (int) 8, (int) 100]
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1754818712 INSERT INTO DeptBean (deptno, 
budget, name, mgr_empid, reportsTo_deptno) VALUES (?, ?, ?, ?, ?) 
[params=(int) 100, (float) 2.1, (String) CEO, (int) 10, (int) 100]
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 592454480 INSERT INTO AddressBean (street, 
city, state, zip) VALUES (?, ?, ?, ?) [params=(String) 1780 Mercury Way, 
(String) CA, (String) Morgan Hill, (String) 95037]
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1531337542 INSERT INTO AddressBean 
(street, city, state, zip) VALUES (?, ?, ?, ?) [params=(String) 512 Venus 
Drive, (String) CA, (String) Morgan Hill, (String) 95037]
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1970697590 INSERT INTO AddressBean 
(street, city, state, zip) VALUES (?, ?, ?, ?) [params=(String) 12440 
Vulcan Avenue, (String) CA, (String) Los Altos, (String) 95130]
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 150341878 INSERT INTO AddressBean (street, 
city, state, zip) VALUES (?, ?, ?, ?) [params=(String) 4983 Plutonium 
Avenue, (String) CA, (String) Palo Alto, (String) 95140]
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 630597014 INSERT INTO AddressBean (street, 
city, state, zip) VALUES (?, ?, ?, ?) [params=(String) 182 Martian Street, 
(String) CA, (String) San Jose, (String) 95120]
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 960117050 INSERT INTO AddressBean (street, 
city, state, zip) VALUES (?, ?, ?, ?) [params=(String) 555 Silicon Valley 
Drive, (String) CA, (String) San Jose, (String) 94120]
5391  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5406  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1264208730 INSERT INTO AddressBean 
(street, city, state, zip) VALUES (?, ?, ?, ?) [params=(String) 6200 Vegas 
Drive, (String) CA, (String) San Jose, (String) 95120]
5406  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5406  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1676567534 INSERT INTO AddressBean 
(street, city, state, zip) VALUES (?, ?, ?, ?) [params=(String) 150 North 
First Apt E1, (String) CA, (String) San Jose, (String) 94003]
5406  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5406  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 2056813208 INSERT INTO AddressBean 
(street, city, state, zip) VALUES (?, ?, ?, ?) [params=(String) 8900 
Jupiter Park, (String) CA, (String) San Jose, (String) 94005]
5406  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5406  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 287445282 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 1, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 0, 
(String) david, (double) 12.1, (int) 210, (String) 1780 Mercury Way, 
(String) 555 Silicon Valley Drive]
5422  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [16 ms] spent
5422  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 417863912 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 2, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 0, 
(String) andrew, (double) 13.1, (int) 210, (String) 1780 Mercury Way, 
(String) 555 Silicon Valley Drive]
5422  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5422  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 2106359180 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 3, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 1, 
(String) minmei, (double) 15.5, (int) 200, (String) 1780 Mercury Way, 
(String) 555 Silicon Valley Drive]
5422  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5422  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 623387944 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 4, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 1, 
(String) george, (double) 0.0, (int) 200, (String) 512 Venus Drive, 
(String) 555 Silicon Valley Drive]
5438  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [16 ms] spent
5438  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1294880046 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 5, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 1, 
(String) ritika, (double) 0.0, (int) 220, (String) 12440 Vulcan Avenue, 
(String) 555 Silicon Valley Drive]
5438  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5438  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 218500358 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 6, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 1, 
(String) ahmad, (double) 0.0, (int) 100, (String) 4983 Plutonium Avenue, 
(String) 4983 Plutonium Avenue]
5438  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5438  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 2051045952 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 7, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 1, 
(String) charlene, (double) 0.0, (int) 210, (String) 182 Martian Street, 
(String) 555 Silicon Valley Drive]
5438  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5438  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 243011196 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 8, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 1, 
(String) Tom Rayburn, (double) 0.0, (int) 100, (String) 6200 Vegas Drive, 
(String) 555 Silicon Valley Drive]
5453  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [15 ms] spent
5453  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1076641836 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 9, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 1, 
(String) harry, (double) 0.0, (int) 210, (String) 150 North First Apt E1, 
(String) 8900 Jupiter Park]
5453  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5453  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> executing prepstmnt 1685611640 INSERT INTO EmpBean (empid, 
bonus, execLevel, hireDate, hireTime, hireTimestamp, isManager, name, 
salary, dept_deptno, home_street, work_street) VALUES (?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?) [params=(int) 10, (double) 0.0, (int) 65, (Date) 
1969-12-31, (Time) 16:00:00, (Timestamp) 1969-12-31 16:00:00.0, (int) 1, 
(String) Catalina Wei, (double) 0.0, (null) null, (null) null, (String) 
555 Silicon Valley Drive]
5453  mdd  TRACE  [main] openjpa.jdbc.SQL - <t 1094861122, conn 
1027882308> [0 ms] spent
5469  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 
1027882308> [16 ms] commit
5469  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
0  mdd  TRACE  [main] openjpa.Runtime - Setting the following properties 
from 
"file:/C:/apacheEclipse3.2/openjpa_096_incubating/workspace/jpa.test/bin/META-INF/persistence.xml" 
into configuration: 
{openjpa.jdbc.SynchronizeMappings=buildSchema(ForeignKeys=true), 
openjpa.ConnectionDriverName=org.apache.commons.dbcp.BasicDataSource, 
openjpa.ConnectionProperties=DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:tmp/mdd-test-database;create=true, 
openjpa.MetaDataFactory=Resources=META-INF/queryTestCatalogAno.xml, 
openjpa.Id=mdd, 
openjpa.Log=File=stderr,Runtime=TRACE,SQL=TRACE,JDBC=TRACE,QUERY=TRACE, 
openjpa.BrokerFactory=jdbc}
0  mdd  INFO   [main] openjpa.Runtime - Starting OpenJPA 0.0.0
0  mdd  TRACE  [main] openjpa.Runtime - Properties: openjpa.AutoDetach: 
openjpa.MetaDataFactory: Resources=META-INF/queryTestCatalogAno.xml
openjpa.EntityManagerFactory: default
openjpa.ProxyManager: default
openjpa.jdbc.EagerFetchMode: parallel
openjpa.DataCache: false
openjpa.LockTimeout: -1
openjpa.Id: mdd
openjpa.QueryCache: true
openjpa.BrokerImpl: default
openjpa.BrokerFactory: jdbc
openjpa.Compatibility: default
openjpa.FetchGroups: default
openjpa.ConnectionDriverName: org.apache.commons.dbcp.BasicDataSource
openjpa.QueryCompilationCache: true
openjpa.DataCacheTimeout: -1
openjpa.NontransactionalWrite: true
openjpa.RetryClassRegistration: false
openjpa.jdbc.TransactionIsolation: default
openjpa.Multithreaded: false
openjpa.TransactionMode: local
openjpa.ConnectionRetainMode: on-demand
openjpa.AutoClear: datastore
openjpa.Sequence: table
openjpa.jdbc.Schemas: 
openjpa.WriteLockLevel: write
openjpa.MetaDataRepository: default
openjpa.DynamicDataStructs: false
openjpa.RetainState: true
openjpa.ConnectionProperties: 
DriverClassName=org.apache.derby.jdbc.EmbeddedDriver,Url=jdbc:derby:tmp/mdd-test-database;create=true
openjpa.Optimistic: true
openjpa.jdbc.ResultSetType: forward-only
openjpa.LockManager: version
openjpa.RestoreState: immutable
openjpa.jdbc.SynchronizeMappings: buildSchema(ForeignKeys=true)
openjpa.jdbc.FetchDirection: forward
openjpa.InverseManager: false
openjpa.jdbc.LRSSize: query
openjpa.jdbc.SQLFactory: default
openjpa.DataCacheManager: default
openjpa.MaxFetchDepth: -1
openjpa.NontransactionalRead: true
openjpa.jdbc.MappingDefaults: jpa
openjpa.ReadLockLevel: read
openjpa.ClassResolver: default
openjpa.FlushBeforeQueries: true
openjpa.FetchBatchSize: -1
openjpa.SavepointManager: in-mem
openjpa.ManagedRuntime: auto
openjpa.IgnoreChanges: false
openjpa.jdbc.SchemaFactory: dynamic
openjpa.ConnectionFactoryMode: local
openjpa.OrphanedKeyAction: log
openjpa.jdbc.SubclassFetchMode: join
openjpa.jdbc.UpdateManager: default
openjpa.Log: File=stderr,Runtime=TRACE,SQL=TRACE,JDBC=TRACE,QUERY=TRACE
openjpa.jdbc.DriverDataSource: simple
openjpa.DetachState: loaded
15  mdd  INFO   [main] openjpa.jdbc.JDBC - OpenJPA will now connect to the 
database to attempt to determine what type of database dictionary to use. 
To prevent this connection in the future, set your 
openjpa.jdbc.DBDictionary configuration property to the appropriate value 
for your database (see the documentation for available values).
31  mdd  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class 
"org.apache.openjpa.jdbc.sql.DerbyDictionary" (Apache Derby 10.1.3.2 
,Apache Derby Embedded JDBC Driver 10.1.3.2).
31  mdd  TRACE  [main] openjpa.jdbc.JDBC - catalogSeparator: 
catalogTerm: CATALOG
databaseProductName: Apache Derby
databaseProductVersion: 10.1.3.2
driverName: Apache Derby Embedded JDBC Driver
driverVersion: 10.1.3.2
extraNameCharacters: 
identifierQuoteString: "
numericFunctions: ABS,SQRT
procedureTerm: PROCEDURE
schemaTerm: SCHEMA
searchStringEscape: 
sqlKeywords: 
ALIAS,BIGINT,BOOLEAN,CALL,CLASS,COPY,DB2J_DEBUG,EXECUTE,EXPLAIN,FILE,FILTER,GETCURRENTCONNECTION,INDEX,INSTANCEOF,METHOD,NEW,OFF,PROPERTIES,PUBLICATION,RECOMPILE,REFRESH,RENAME,RUNTIMESTATISTICS,STATEMENT,STATISTICS,TIMING,WAIT
stringFunctions: LENGTH,LOWER,LTRIM,RTRIM,SUBSTR,SUBSTRING,UPPER
systemFunctions: 
CURRENT_USER,getCurrentConnection,runTimeStatistics,SESSION_USER,USER,CURRENT 
SCHEMA
timeDateFunctions: 
CURDATE,CURTIME,CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,EXTRACT
url: jdbc:derby:tmp/mdd-test-database
userName: APP
defaultTransactionIsolation: 2
driverMajorVersion: 10
driverMinorVersion: 1
maxBinaryLiteralLength: 0
maxCatalogNameLength: 0
maxCharLiteralLength: 0
maxColumnNameLength: 128
maxColumnsInGroupBy: 0
maxColumnsInIndex: 0
maxColumnsInOrderBy: 0
maxColumnsInSelect: 0
maxColumnsInTable: 0
maxConnections: 0
maxCursorNameLength: 128
maxIndexLength: 0
maxProcedureNameLength: 128
maxRowSize: 0
maxSchemaNameLength: 128
maxStatementLength: 0
maxStatements: 0
maxTableNameLength: 128
maxTablesInSelect: 0
maxUserNameLength: 30
isCatalogAtStart: false
isReadOnly: false
nullPlusNonNullIsNull: true
nullsAreSortedAtEnd: false
nullsAreSortedAtStart: false
nullsAreSortedHigh: true
nullsAreSortedLow: false
storesLowerCaseIdentifiers: false
storesLowerCaseQuotedIdentifiers: false
storesMixedCaseIdentifiers: false
storesMixedCaseQuotedIdentifiers: true
storesUpperCaseIdentifiers: true
storesUpperCaseQuotedIdentifiers: false
supportsAlterTableWithAddColumn: true
supportsAlterTableWithDropColumn: true
supportsANSI92EntryLevelSQL: false
supportsANSI92FullSQL: false
supportsANSI92IntermediateSQL: false
supportsCatalogsInDataManipulation: false
supportsCatalogsInIndexDefinitions: false
supportsCatalogsInPrivilegeDefinitions: false
supportsCatalogsInProcedureCalls: false
supportsCatalogsInTableDefinitions: false
supportsColumnAliasing: true
supportsConvert: true
supportsCoreSQLGrammar: false
supportsCorrelatedSubqueries: true
supportsDataDefinitionAndDataManipulationTransactions: true
supportsDataManipulationTransactionsOnly: false
supportsDifferentTableCorrelationNames: true
supportsExpressionsInOrderBy: false
supportsExtendedSQLGrammar: false
supportsFullOuterJoins: false
supportsGroupBy: true
supportsGroupByBeyondSelect: true
supportsGroupByUnrelated: true
supportsIntegrityEnhancementFacility: false
supportsLikeEscapeClause: true
supportsLimitedOuterJoins: true
supportsMinimumSQLGrammar: true
supportsMixedCaseIdentifiers: false
supportsMixedCaseQuotedIdentifiers: true
supportsMultipleResultSets: true
supportsMultipleTransactions: true
supportsNonNullableColumns: true
supportsOpenCursorsAcrossCommit: false
supportsOpenCursorsAcrossRollback: false
supportsOpenStatementsAcrossCommit: true
supportsOpenStatementsAcrossRollback: false
supportsOrderByUnrelated: false
supportsOuterJoins: true
supportsPositionedDelete: true
supportsPositionedUpdate: true
supportsSchemasInDataManipulation: true
supportsSchemasInIndexDefinitions: true
supportsSchemasInPrivilegeDefinitions: true
supportsSchemasInProcedureCalls: true
supportsSchemasInTableDefinitions: true
supportsSelectForUpdate: true
supportsStoredProcedures: true
supportsSubqueriesInComparisons: true
supportsSubqueriesInExists: true
supportsSubqueriesInIns: true
supportsSubqueriesInQuantifieds: true
supportsTableCorrelationNames: true
supportsTransactions: true
supportsUnion: true
supportsUnionAll: true
usesLocalFilePerTable: true
usesLocalFiles: true
allProceduresAreCallable: true
allTablesAreSelectable: true
dataDefinitionCausesTransactionCommit: false
dataDefinitionIgnoredInTransactions: false
doesMaxRowSizeIncludeBlobs: true
supportsBatchUpdates: true
31  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
31  mdd  INFO   [main] openjpa.MetaData - Found 15 classes with metadata 
in 0 milliseconds.
31  mdd  INFO   [main] openjpa.MetaData - Found 15 classes with metadata 
in 0 milliseconds.
47  mdd  INFO   [main] openjpa.MetaData - Parsing resource 
"file:/C:/apacheEclipse3.2/openjpa_096_incubating/workspace/jpa.test/bin/META-INF/queryTestCatalogAno.xml".
78  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.DeptBean".
78  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.DeptBean".
78  mdd  INFO   [main] openjpa.MetaData - Parsing package 
"com.ibm.ws.query.entities.objectgrid.annotated.DeptBean".
78  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"findAllDepartmentsLikeName".
78  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"joinDeptWithEmps".
78  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"deleteDepartmentsGreaterThan".
78  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"updateDeptBudget".
78  mdd  INFO   [main] openjpa.MetaData - Parsing query 
"updateDeptBudgetForParent".
78  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeFindAllDepartmentNumbersLikeName".
78  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeFindAllDepartmentColumns".
78  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeFindAllDepartments".
78  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeDeleteDepartmentsGreaterThan".
78  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeUpdateDeptBudget".
78  mdd  INFO   [main] openjpa.MetaData - Parsing native query 
"nativeUpdateDeptBudgetForParent".
94  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.EmpBean".
94  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.EmpBean".
94  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.ProjectBean".
94  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.ProjectBean".
94  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TaskBean".
94  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TaskBean".
109  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.AddressBean".
109  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.AddressBean".
109  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TypeTestBean".
109  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.objectgrid.annotated.TypeTestBean".
109  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Customer".
109  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Customer".
109  mdd  INFO   [main] openjpa.MetaData - Parsing package 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Customer".
109  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.LineItem".
109  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.LineItem".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Order".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Order".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Part".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Part".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartBase".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartBase".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartComposite".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.PartComposite".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Product".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Product".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Supplier".
125  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Supplier".
140  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Usage".
140  mdd  INFO   [main] openjpa.MetaData - Parsing class 
"com.ibm.ws.query.entities.inheritance.parttest.annotated.Usage".
140  mdd  WARN   [main] openjpa.MetaData - OpenJPA cannot map field 
"com.ibm.ws.query.entities.objectgrid.annotated.TypeTestBean.obytes" 
efficiently.  It is of an unsupported type. The field value will be 
serialized to a BLOB by default.
156  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "AddressBean".
156  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
156  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, ADDRESSBEAN, null
156  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Customerparttab".
156  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
156  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, CUSTOMERPARTTAB, null
172  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "DeptBean".
172  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
172  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, DEPTBEAN, null
172  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "EmpBean".
172  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
172  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, EMPBEAN, null
187  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "LineItemparttab".
187  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
187  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, LINEITEMPARTTAB, null
203  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Orderparttab".
203  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
203  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, ORDERPARTTAB, null
219  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "parttab".
219  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
219  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, PARTTAB, null
219  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Productparttab".
219  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
219  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, PRODUCTPARTTAB, null
219  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "ProjectBean".
219  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
219  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, PROJECTBEAN, null
234  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Supplierparttab".
234  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
234  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, SUPPLIERPARTTAB, null
234  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Supplierparttab_parttab".
234  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
234  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, SUPPLIERPARTTAB_PARTTAB, null
234  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "TaskBean".
234  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
234  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, TASKBEAN, null
250  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "TaskBean_EmpBean".
250  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
250  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, TASKBEAN_EMPBEAN, null
250  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "TypeTestBean".
250  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
250  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, TYPETESTBEAN, null
265  mdd  INFO   [main] openjpa.jdbc.Schema - Reading table information 
for schema name "null", table name "Usageparttab".
265  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
265  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getColumns: null, null, USAGEPARTTAB, null
281  mdd  INFO   [main] openjpa.jdbc.Schema - Reading sequence information 
for schema "null", sequence name "null".
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] commit
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, ADDRESSBEAN
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, CUSTOMERPARTTAB
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, DEPTBEAN
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
281  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, EMPBEAN
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, LINEITEMPARTTAB
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, ORDERPARTTAB
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, PARTTAB
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, PRODUCTPARTTAB
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, PROJECTBEAN
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
297  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, SUPPLIERPARTTAB
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, SUPPLIERPARTTAB_PARTTAB
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, TASKBEAN
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, TASKBEAN_EMPBEAN
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, TYPETESTBEAN
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] rollback
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
getImportedKeys: null, null, USAGEPARTTAB
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 202247182> 
[0 ms] commit
312  mdd  TRACE  [main] openjpa.jdbc.JDBC - <t 1094861122, conn 0> [0 ms] 
close






"Marc Prud'hommeaux" <mprudhom@apache.org> 
Sent by: "Marc Prud'hommeaux" <mprudhomapache@gmail.com>
12/04/2006 12:18 PM
Please respond to
open-jpa-dev@incubator.apache.org


To
open-jpa-dev@incubator.apache.org
cc
"Patrick Linskey" <plinskey@bea.com>, Ahmad Nouri/Santa Teresa/IBM@IBMUS, 
David Wisneski/Santa Teresa/IBM@IBMUS
Subject
Re: openjpa NativeQuery and NamedNativeQuery only allow select sql 
statements






George-

Can you also send the nested stack trace(s)? Those are very important 
for helping us identify the exact JDBC call that is being made.



On Dec 4, 2006, at 12:12 PM, George Hongell wrote:

> Hi Patrick,
> I am using Query.executeUpdate()for all but the queries where I am 
> trying
> to call a stored procedure where what execute I use depends on 
> whether the
> stored procedure returns a result set.
>
> Here is my "insert" example.
>             String name = "insert into DeptBean  (deptno) values 
> (?)";
>             Query q1 = _em.createNativeQuery(name);
>             q1.setParameter(1,200);
>             int inserted = q1.executeUpdate ();
>
> <4|false|0.0.0> org.apache.openjpa.persistence.InvalidStateException:
> Cannot perform an update or delete operation on select query: 
> "insert into
> DeptBean  (deptno) values  (?)".
>         at
> org.apache.openjpa.persistence.QueryImpl.executeUpdate 
> (QueryImpl.java:306)
>         at
> com.ibm.ws.query.tests.JUNamedNativeQueryTest.testInsertQuery 
> (JUNamedNativeQueryTest.java:315)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke 
> (NativeMethodAccessorImpl.java:64)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke 
> (DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:615)
>         at junit.framework.TestCase.runTest(Unknown Source)
>         at junit.framework.TestCase.runBare(Unknown Source)
>         at junit.framework.TestResult$1.protect(Unknown Source)
>         at junit.framework.TestResult.runProtected(Unknown Source)
>
> Here is my "update" example.
>             String name = "nativeUpdateDeptBudget";
>             Query q1 = _em.createNamedQuery(name);
>             q1.setParameter(1,10000);
>             int updated = q1.executeUpdate ();
>
>
> <4|false|0.0.0> org.apache.openjpa.persistence.InvalidStateException:
> Cannot perform an update or delete operation on select query: "update
> DeptBean d set d.budget = (d.budget + ?1)".
>         at
> org.apache.openjpa.persistence.QueryImpl.executeUpdate 
> (QueryImpl.java:306)
>         at
> com.ibm.ws.query.tests.JUNamedNativeQueryTest.testUpdateDeptBudget 
> (JUNamedNativeQueryTest.java:367)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke 
> (NativeMethodAccessorImpl.java:64)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke 
> (DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:615)
>         at junit.framework.TestCase.runTest(Unknown Source)
>         at junit.framework.TestCase.runBare(Unknown Source)
>         at junit.framework.TestResult$1.protect(Unknown Source)
>         at junit.framework.TestResult.runProtected(Unknown Source)
>         at junit.framework.TestResult.run(Unknown Source)
>         at junit.framework.TestCase.run(Unknown Source)
>         at junit.framework.TestSuite.runTest(Unknown Source)
>         at junit.framework.TestSuite.run(Unknown Source)
>         at
> org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run 
> (JUnit3TestReference.java:128)
>         at
> org.eclipse.jdt.internal.junit.runner.TestExecution.run 
> (TestExecution.java:38)
>         at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests 
> (RemoteTestRunner.java:460)
>         at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests 
> (RemoteTestRunner.java:673)
>         at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run 
> (RemoteTestRunner.java:386)
>         at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main 
> (RemoteTestRunner.java:196)
>
>
>
>
> "Patrick Linskey" <plinskey@bea.com>
> 12/04/2006 10:21 AM
>
> To
> <open-jpa-dev@incubator.apache.org>, George Hongell/Santa Teresa/ 
> IBM@IBMUS
> cc
> David Wisneski/Santa Teresa/IBM@IBMUS, Ahmad Nouri/Santa Teresa/ 
> IBM@IBMUS
> Subject
> RE: openjpa NativeQuery and NamedNativeQuery only allow select sql
> statements
>
>
>
>
>
>
> Hi,
>
> How are you executing the query? I'm guessing that you're using
> Query.getResultList() or Query.getSingleResult() instead of
> Query.executeUpdate().
>
> -Patrick
>
> -- 
> Patrick Linskey
> BEA Systems, Inc.
>
> ______________________________________________________________________ 
> _
> Notice:  This email message, together with any attachments, may 
> contain
> information  of  BEA Systems,  Inc.,  its subsidiaries  and 
> affiliated
> entities,  that may be confidential,  proprietary,  copyrighted 
> and/or
> legally privileged, and is intended solely for the use of the 
> individual
> or entity named in this message. If you are not the intended 
> recipient,
> and have received this message in error, please immediately return 
> this
> by email and then delete it.
>
>> -----Original Message-----
>> From: George Hongell [mailto:ghongell@us.ibm.com]
>> Sent: Monday, December 04, 2006 10:12 AM
>> To: open-jpa-dev@incubator.apache.org
>> Cc: David Wisneski; Ahmad Nouri
>> Subject: openjpa NativeQuery and NamedNativeQuery only allow
>> select sql statements
>>
>> It seems that openjpa NativeQuery and NamedNativeQuery only
>> allow "select"
>> sql statements.  When I try to
>> insert, delete, update, create table, alter table, drop
>> table, or call a
>> stored procedure, I get
>> <4|false|0.9.6-incubating-SNAPSHOT>
>> org.apache.openjpa.persistence.InvalidStateException: Cannot
>> perform an
>> update or delete operation on select query: "call out2(?, ?)".
>> Is this intentional?
>> I expected the NativeQuery to allow me to execute any valid
>> sql statement.
>>
>



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message