openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc Prud'hommeaux <mprud...@apache.org>
Subject Re: openjpa NativeQuery and NamedNativeQuery only allow select sql statements
Date Tue, 05 Dec 2006 00:03:24 GMT

The nested stack trace should be included when the parent stack is  
printed out.

Is it being truncated captured by your IDE or something? Maybe if you  
wrap the offending call in a try/catch block and just do  
ex.printStackTrace() you will see it in the console...


On Dec 4, 2006, at 3:05 PM, George Hongell wrote:

>
> 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.Emb 
> eddedDriver,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:tm 
> p/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,F 
> ILTER,GETCURRENTCONNECTION,INDEX,INSTANCEOF,METHOD,NEW,OFF,PROPERTIES, 
> PUBLICATION,RECOMPILE,REFRESH,RENAME,RUNTIMESTATISTICS,STATEMENT,STATI 
> STICS,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.PartComposit 
> e".
> 2844  mdd  INFO   [main] openjpa.MetaData - Parsing class  
> "com.ibm.ws.query.entities.inheritance.parttest.annotated.PartComposit 
> e".
> 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" e 
> fficiently.  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.PartComposit 
> e".
> 3703  mdd  INFO   [main] openjpa.MetaData - Parsing class  
> "com.ibm.ws.query.entities.inheritance.parttest.annotated.PartComposit 
> e".
> 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.Emb 
> eddedDriver,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:tm 
> p/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,F 
> ILTER,GETCURRENTCONNECTION,INDEX,INSTANCEOF,METHOD,NEW,OFF,PROPERTIES, 
> PUBLICATION,RECOMPILE,REFRESH,RENAME,RUNTIMESTATISTICS,STATEMENT,STATI 
> STICS,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.PartComposit 
> e".
> 125  mdd  INFO   [main] openjpa.MetaData - Parsing class  
> "com.ibm.ws.query.entities.inheritance.parttest.annotated.PartComposit 
> e".
> 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" e 
> fficiently.  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
View raw message