The problem still persists with version 3.1.1 2 case2 TRACE [main] openjpa.Runtime - Setting the following properties from "file:/home/patrice/workspace/OpenJPA1/target/classes/META-INF/persistence.xml" into configuration: {openjpa.BrokerFactory=jdbc, openjpa.DynamicEnhancementAgent=false, javax.persistence.jdbc.url=jdbc:postgresql://localhost/test, javax.persistence.jdbc.user=test, openjpa.jdbc.SynchronizeMappings=buildSchema, javax.persistence.jdbc.driver=org.postgresql.Driver, javax.persistence.jdbc.password=test, openjpa.Log=DefaultLevel=TRACE, openjpa.Id=case2, PersistenceVersion=2.0, openjpa.MetaDataFactory=jpa(Resources=META-INF/case2.xml)} 10 case2 TRACE [main] openjpa.Runtime - Trying to load javax.validation APIs based on the ValidationMode=AUTO 11 case2 TRACE [main] openjpa.Runtime - Could not create the optional validation provider. Reason returned: "No available javax.validation APIs" 17 case2 TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.PersistenceProviderImpl@1e730495 creating org.apache.openjpa.persistence.EntityManagerFactoryImpl@7d3a22a9 for PU case2. 20 case2 INFO [main] openjpa.Runtime - Starting OpenJPA 3.1.1 21 case2 TRACE [main] openjpa.Runtime - Properties: javax.persistence.jdbc.driver: org.postgresql.Driver javax.persistence.jdbc.password: ****** javax.persistence.jdbc.url: jdbc:postgresql://localhost/test javax.persistence.jdbc.user: test javax.persistence.lock.timeout: 0 javax.persistence.query.timeout: 0 javax.persistence.schema-generation.create-source: 0 javax.persistence.schema-generation.database.action: 0 javax.persistence.schema-generation.drop-source: 0 javax.persistence.schema-generation.scripts.action: 0 javax.persistence.sharedCache.mode: UNSPECIFIED javax.persistence.validation.group.pre-persist: javax.validation.groups.Default javax.persistence.validation.group.pre-update: javax.validation.groups.Default openjpa.AutoClear: 0 openjpa.AutoDetach: [] openjpa.BrokerFactory: jdbc openjpa.BrokerImpl: default openjpa.CacheDistributionPolicy: default openjpa.Callbacks: default openjpa.ClassResolver: default openjpa.Compatibility: default openjpa.ConnectionFactoryMode: false openjpa.ConnectionRetainMode: 0 openjpa.DataCache: false openjpa.DataCacheManager: default openjpa.DataCacheTimeout: -1 openjpa.DetachState: loaded openjpa.DynamicDataStructs: false openjpa.DynamicEnhancementAgent: false openjpa.EntityManagerFactory: default openjpa.FetchBatchSize: -1 openjpa.FetchGroups: [default] openjpa.FlushBeforeQueries: 0 openjpa.Id: case2 openjpa.IgnoreChanges: false openjpa.InitializeEagerly: false openjpa.InstrumentationManager: default openjpa.InverseManager: false openjpa.LifecycleEventManager: default openjpa.LockManager: mixed openjpa.Log: true(DefaultLevel=TRACE) openjpa.ManagedRuntime: auto openjpa.MaxFetchDepth: -1 openjpa.MetaDataFactory: jpa(Resources=META-INF/case2.xml) openjpa.MetaDataRepository: default openjpa.Multithreaded: false openjpa.NontransactionalRead: true openjpa.NontransactionalWrite: true openjpa.Optimistic: true openjpa.OptimizeIdCopy: false openjpa.OrphanedKeyAction: log openjpa.PostLoadOnMerge: false openjpa.ProxyManager: default openjpa.QueryCache: false openjpa.QueryCompilationCache: true openjpa.ReadLockLevel: 10 openjpa.RefreshFromDataCache: false openjpa.RestoreState: 1 openjpa.RetainState: true openjpa.RetryClassRegistration: false openjpa.RuntimeUnenhancedClasses: 1 openjpa.SavepointManager: in-mem openjpa.Sequence: table openjpa.TransactionMode: false openjpa.UseTCCLinSelectNew: false openjpa.WriteLockLevel: 20 openjpa.jdbc.DriverDataSource: auto openjpa.jdbc.EagerFetchMode: 2 openjpa.jdbc.FetchDirection: 1000 openjpa.jdbc.FinderCache: true openjpa.jdbc.IdentifierUtil: default openjpa.jdbc.LRSSize: 2 openjpa.jdbc.MappingDefaults: jpa openjpa.jdbc.QuerySQLCache: true openjpa.jdbc.ResultSetType: 1003 openjpa.jdbc.SQLFactory: default openjpa.jdbc.SchemaFactory: dynamic openjpa.jdbc.Schemas: [] openjpa.jdbc.SubclassFetchMode: 1 openjpa.jdbc.SynchronizeMappings: buildSchema openjpa.jdbc.TransactionIsolation: -1 openjpa.jdbc.UpdateManager: default 24 case2 TRACE [main] openjpa.Runtime - No cache marshaller found for id org.apache.openjpa.conf.MetaDataCacheMaintenance. 43 case2 TRACE [main] openjpa.MetaData - Using metadata factory "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@5e82df6a". 54 case2 INFO [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.PostgresDictionary". 73 case2 TRACE [main] openjpa.jdbc.JDBC - createConnectionFactory: connectionFactory not created yet, attempt JNDI lookup... 73 case2 TRACE [main] openjpa.jdbc.JDBC - createConnectionFactory: JNDI lookup failed, attempt DataSource properties... 89 case2 TRACE [main] openjpa.jdbc.JDBC - createConnectionFactory: DataSource=org.apache.openjpa.jdbc.schema.AutoDriverDataSource@54d9d12d 91 case2 TRACE [main] openjpa.jdbc.JDBC - DataSource connection setAutoCommit to "true" 262 case2 TRACE [main] openjpa.jdbc.JDBC - catalogSeparator: . catalogTerm: database databaseProductName: PostgreSQL databaseProductVersion: 12.2 (Debian 12.2-1+b1) driverName: PostgreSQL JDBC Driver driverVersion: 42.2.10 extraNameCharacters: identifierQuoteString: " numericFunctions: abs,acos,asin,atan,atan2,ceiling,cos,cot,degrees,exp,floor,log,log10,mod,pi,power,radians,round,sign,sin,sqrt,tan,truncate procedureTerm: function schemaTerm: schema searchStringEscape: \ sqlKeywords: abort,access,aggregate,also,analyse,analyze,attach,backward,bit,cache,checkpoint,class,cluster,columns,comment,comments,concurrently,configuration,conflict,connection,content,conversion,copy,cost,csv,current_catalog,current_schema,database,delimiter,delimiters,depends,detach,dictionary,disable,discard,do,document,enable,encoding,encrypted,enum,event,exclusive,explain,extension,family,force,forward,freeze,functions,generated,greatest,groups,handler,header,if,ilike,immutable,implicit,import,include,index,indexes,inherit,inherits,inline,instead,isnull,label,leakproof,least,limit,listen,load,location,lock,locked,logged,mapping,materialized,mode,move,nothing,notify,notnull,nowait,off,offset,oids,operator,owned,owner,parallel,parser,passing,password,plans,policy,prepared,procedural,procedures,program,publication,quote,reassign,recheck,refresh,reindex,rename,replace,replica,reset,restrict,returning,routines,rule,schemas,sequences,server,setof,share,show,skip,snapshot,stable,standalone,statistics,stdin,stdout,storage,stored,strict,strip,subscription,support,sysid,tables,tablespace,temp,template,text,truncate,trusted,types,unencrypted,unlisten,unlogged,until,vacuum,valid,validate,validator,variadic,verbose,version,views,volatile,whitespace,wrapper,xml,xmlattributes,xmlconcat,xmlelement,xmlexists,xmlforest,xmlnamespaces,xmlparse,xmlpi,xmlroot,xmlserialize,xmltable,yes stringFunctions: ascii,char,concat,lcase,left,length,ltrim,repeat,rtrim,space,substring,ucase,replace systemFunctions: database,ifnull,user timeDateFunctions: curdate,curtime,dayname,dayofmonth,dayofweek,dayofyear,hour,minute,month,monthname,now,quarter,second,week,year,timestampadd url: jdbc:postgresql://localhost/test userName: test defaultTransactionIsolation: 2 driverMajorVersion: 42 driverMinorVersion: 2 maxBinaryLiteralLength: 0 maxCatalogNameLength: 63 maxCharLiteralLength: 0 maxColumnNameLength: 63 maxColumnsInGroupBy: 0 maxColumnsInIndex: 32 maxColumnsInOrderBy: 0 maxColumnsInSelect: 0 maxColumnsInTable: 1600 maxConnections: 8192 maxCursorNameLength: 63 maxIndexLength: 0 maxProcedureNameLength: 63 maxRowSize: 1073741824 maxSchemaNameLength: 63 maxStatementLength: 0 maxStatements: 0 maxTableNameLength: 63 maxTablesInSelect: 0 maxUserNameLength: 63 isCatalogAtStart: true isReadOnly: false nullPlusNonNullIsNull: true nullsAreSortedAtEnd: false nullsAreSortedAtStart: false nullsAreSortedHigh: true nullsAreSortedLow: false storesLowerCaseIdentifiers: true storesLowerCaseQuotedIdentifiers: false storesMixedCaseIdentifiers: false storesMixedCaseQuotedIdentifiers: false storesUpperCaseIdentifiers: false storesUpperCaseQuotedIdentifiers: false supportsAlterTableWithAddColumn: true supportsAlterTableWithDropColumn: true supportsANSI92EntryLevelSQL: true supportsANSI92FullSQL: false supportsANSI92IntermediateSQL: false supportsCatalogsInDataManipulation: false supportsCatalogsInIndexDefinitions: false supportsCatalogsInPrivilegeDefinitions: false supportsCatalogsInProcedureCalls: false supportsCatalogsInTableDefinitions: false supportsColumnAliasing: true supportsConvert: false supportsCoreSQLGrammar: false supportsCorrelatedSubqueries: true supportsDataDefinitionAndDataManipulationTransactions: true supportsDataManipulationTransactionsOnly: false supportsDifferentTableCorrelationNames: false supportsExpressionsInOrderBy: true supportsExtendedSQLGrammar: false supportsFullOuterJoins: true supportsGroupBy: true supportsGroupByBeyondSelect: true supportsGroupByUnrelated: true supportsIntegrityEnhancementFacility: true supportsLikeEscapeClause: true supportsLimitedOuterJoins: true supportsMinimumSQLGrammar: true supportsMixedCaseIdentifiers: false supportsMixedCaseQuotedIdentifiers: true supportsMultipleResultSets: true supportsMultipleTransactions: true supportsNonNullableColumns: true supportsOpenCursorsAcrossCommit: false supportsOpenCursorsAcrossRollback: false supportsOpenStatementsAcrossCommit: true supportsOpenStatementsAcrossRollback: true supportsOrderByUnrelated: true supportsOuterJoins: true supportsPositionedDelete: false supportsPositionedUpdate: false 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: false usesLocalFiles: false allProceduresAreCallable: true allTablesAreSelectable: true dataDefinitionCausesTransactionCommit: false dataDefinitionIgnoredInTransactions: false doesMaxRowSizeIncludeBlobs: false supportsBatchUpdates: true 263 case2 TRACE [main] openjpa.jdbc.JDBC - Initial connection autoCommit: true, holdability: 2, TransactionIsolation: 2 263 case2 INFO [main] openjpa.jdbc.JDBC - Connected to PostgreSQL version 12.12 using JDBC driver PostgreSQL JDBC Driver version 42.2.10. 264 case2 TRACE [main] openjpa.jdbc.JDBC - <t 1784131088, conn 1986417638> [1 ms] close 277 case2 TRACE [main] openjpa.MetaData - Scanning resource "META-INF/case2.xml" for persistent types. 277 case2 TRACE [main] openjpa.MetaData - The persistent unit root url is "null" 277 case2 TRACE [main] openjpa.MetaData - The resource url is "file:/home/patrice/workspace/OpenJPA1/target/classes/META-INF/case2.xml" 277 case2 TRACE [main] openjpa.MetaData - Scan of "META-INF/case2.xml" found persistent types [model.Node2]. 277 case2 TRACE [main] openjpa.MetaData - Mapping resource location "file:/home/patrice/workspace/OpenJPA1/target/classes/META-INF/case2.xml" to persistent types "[model.Node2]". 277 case2 TRACE [main] openjpa.MetaData - Scanning resource "META-INF/orm.xml" for persistent types. 278 case2 TRACE [main] openjpa.MetaData - The persistent unit root url is "null" 278 case2 TRACE [main] openjpa.MetaData - parsePersistentTypeNames() found [model.Node2]. 278 case2 TRACE [main] openjpa.MetaData - Found 1 classes with metadata in 4 milliseconds. 281 case2 TRACE [main] openjpa.Runtime - No cache marshaller found for id org.apache.openjpa.conf.MetaDataCacheMaintenance. 281 case2 TRACE [main] openjpa.MetaData - Using metadata factory "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@2474f125". 281 case2 TRACE [main] openjpa.MetaData - Loading metadata for "class model.Node2" under mode "[META][QUERY]". 281 case2 TRACE [main] openjpa.MetaData - Scanning resource "META-INF/case2.xml" for persistent types. 281 case2 TRACE [main] openjpa.MetaData - The persistent unit root url is "null" 281 case2 TRACE [main] openjpa.MetaData - The resource url is "file:/home/patrice/workspace/OpenJPA1/target/classes/META-INF/case2.xml" 282 case2 TRACE [main] openjpa.MetaData - Scan of "META-INF/case2.xml" found persistent types [model.Node2]. 282 case2 TRACE [main] openjpa.MetaData - Mapping resource location "file:/home/patrice/workspace/OpenJPA1/target/classes/META-INF/case2.xml" to persistent types "[model.Node2]". 282 case2 TRACE [main] openjpa.MetaData - Scanning resource "META-INF/orm.xml" for persistent types. 282 case2 TRACE [main] openjpa.MetaData - The persistent unit root url is "null" 282 case2 TRACE [main] openjpa.MetaData - parsePersistentTypeNames() found [model.Node2]. 282 case2 TRACE [main] openjpa.MetaData - Found 1 classes with metadata in 1 milliseconds. 295 case2 TRACE [main] openjpa.MetaData - Parsing resource "file:/home/patrice/workspace/OpenJPA1/target/classes/META-INF/case2.xml". 296 case2 TRACE [main] openjpa.MetaData - Overriding thread context classloader from "jdk.internal.loader.ClassLoaders$AppClassLoader@55054057" to "jdk.internal.loader.ClassLoaders$AppClassLoader@55054057". 337 case2 TRACE [main] openjpa.MetaData - Parsing class "model.Node2". 341 case2 TRACE [main] openjpa.MetaData - Generating default metadata for type "model.Node2". 348 case2 TRACE [main] openjpa.MetaData - Parsing class "model.Node2". 348 case2 TRACE [main] openjpa.MetaData - Parsing package "model.Node2". 352 case2 TRACE [main] openjpa.MetaData - Finished parsing metadata resource "file:/home/patrice/workspace/OpenJPA1/target/classes/META-INF/case2.xml". 352 case2 TRACE [main] openjpa.MetaData - Restoring thread context classloader from "jdk.internal.loader.ClassLoaders$AppClassLoader@55054057" to "jdk.internal.loader.ClassLoaders$AppClassLoader@55054057". 352 case2 TRACE [main] openjpa.MetaData - Set persistence-capable superclass of "model.Node2" to "null". 353 case2 TRACE [main] openjpa.MetaData - Resolving metadata for "model.Node2@461591680". 353 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@461591680.childs". 356 case2 TRACE [main] openjpa.MetaData - Resolving field "model.no...@461591680.id". 356 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@461591680.parent". 357 case2 TRACE [main] openjpa.MetaData - Preparing mapping for "model.Node2". 358 case2 TRACE [main] openjpa.MetaData - Resolving field "model.no...@461591680.id". 362 case2 TRACE [main] openjpa.MetaData - "id" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy". 362 case2 TRACE [main] openjpa.MetaData - "model.Node2<discriminator>" has mapping strategy "none". 363 case2 TRACE [main] openjpa.MetaData - "model.Node2<version>" has mapping strategy "none". 363 case2 TRACE [main] openjpa.MetaData - Resolving mapping for "model.Node2@461591680". 363 case2 TRACE [main] openjpa.MetaData - "model.Node2" has mapping strategy "full". 363 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@461591680.childs". 365 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@461591680.parent". 368 case2 TRACE [main] openjpa.MetaData - "parent" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy". 368 case2 TRACE [main] openjpa.MetaData - "childs" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.RelationCollectionInverseKeyFieldStrategy". 370 case2 TRACE [main] openjpa.Runtime - Found datasource 2: null from config. StoreContext: null 370 case2 TRACE [main] openjpa.Runtime - Trying datasource1 370 case2 TRACE [main] openjpa.Runtime - Found datasource1: datasource 1423561005 from configuration. StoreContext: null 371 case2 TRACE [main] openjpa.Runtime - Found datasource 2: null from config. StoreContext: null 371 case2 TRACE [main] openjpa.Runtime - Trying datasource1 371 case2 TRACE [main] openjpa.Runtime - Found datasource1: datasource 1423561005 from configuration. StoreContext: null 386 case2 TRACE [main] openjpa.jdbc.Schema - Reading table information for schema name "null", table name "case2". 386 case2 TRACE [main] openjpa.jdbc.JDBC - <t 1784131088, conn 1877062907> getColumns: test, null, case2, null 390 case2 TRACE [main] openjpa.jdbc.Schema - Reading column information for table "public.case2". 390 case2 TRACE [main] openjpa.jdbc.Schema - Found existing column "child" on table "public.case2". 390 case2 TRACE [main] openjpa.jdbc.Schema - Found existing column "parent_id" on table "public.case2". 391 case2 TRACE [main] openjpa.jdbc.Schema - Reading sequence information for schema "null", sequence name "null". 394 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1877062907> executing prepstmnt 295304806 SELECT NULL AS SEQUENCE_SCHEMA, relname AS SEQUENCE_NAME FROM pg_class WHERE relkind='S' 394 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1877062907> [0 ms] spent 396 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1877062907> executing prepstmnt 2103763750 SELECT pg_get_serial_sequence(?, ?) [params=?, ?] 397 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1877062907> [1 ms] spent 399 case2 TRACE [main] openjpa.jdbc.JDBC - <t 1784131088, conn 1877062907> [2 ms] commit 399 case2 TRACE [main] openjpa.jdbc.Schema - Reading table information for schema name "null", table name "nodes". 399 case2 TRACE [main] openjpa.jdbc.JDBC - <t 1784131088, conn 1877062907> getColumns: test, null, nodes, null 402 case2 TRACE [main] openjpa.jdbc.Schema - Reading column information for table "public.nodes". 402 case2 TRACE [main] openjpa.jdbc.Schema - Found existing column "id" on table "public.nodes". 402 case2 TRACE [main] openjpa.jdbc.Schema - Reading sequence information for schema "null", sequence name "null". 402 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1877062907> executing prepstmnt 711197015 SELECT NULL AS SEQUENCE_SCHEMA, relname AS SEQUENCE_NAME FROM pg_class WHERE relkind='S' 403 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1877062907> [0 ms] spent 403 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1877062907> executing prepstmnt 1384454980 SELECT pg_get_serial_sequence(?, ?) [params=?, ?] 403 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1877062907> [0 ms] spent 403 case2 TRACE [main] openjpa.jdbc.JDBC - <t 1784131088, conn 1877062907> [0 ms] commit 403 case2 TRACE [main] openjpa.jdbc.JDBC - <t 1784131088, conn 1877062907> [0 ms] close 409 case2 TRACE [main] openjpa.Runtime - Found datasource1: datasource 1423561005 from configuration. StoreContext: org.apache.openjpa.kernel.FinalizingBrokerImpl@112f364d 416 case2 TRACE [main] openjpa.Runtime - org.apache.openjpa.persistence.EntityManagerFactoryImpl@7d3a22a9 created EntityManager org.apache.openjpa.persistence.EntityManagerImpl@112f364d. 418 case2 TRACE [main] openjpa.MetaData - Loading metadata for "class model.Node2" under mode "[META][QUERY]". 418 case2 TRACE [main] openjpa.MetaData - Parsing resource "file:/home/patrice/workspace/OpenJPA1/target/classes/META-INF/case2.xml". 419 case2 TRACE [main] openjpa.MetaData - Overriding thread context classloader from "jdk.internal.loader.ClassLoaders$AppClassLoader@55054057" to "jdk.internal.loader.ClassLoaders$AppClassLoader@55054057". 438 case2 TRACE [main] openjpa.MetaData - Parsing class "model.Node2". 438 case2 TRACE [main] openjpa.MetaData - Generating default metadata for type "model.Node2". 438 case2 TRACE [main] openjpa.MetaData - Parsing class "model.Node2". 438 case2 TRACE [main] openjpa.MetaData - Parsing package "model.Node2". 439 case2 TRACE [main] openjpa.MetaData - Finished parsing metadata resource "file:/home/patrice/workspace/OpenJPA1/target/classes/META-INF/case2.xml". 439 case2 TRACE [main] openjpa.MetaData - Restoring thread context classloader from "jdk.internal.loader.ClassLoaders$AppClassLoader@55054057" to "jdk.internal.loader.ClassLoaders$AppClassLoader@55054057". 439 case2 TRACE [main] openjpa.MetaData - Set persistence-capable superclass of "model.Node2" to "null". 439 case2 TRACE [main] openjpa.MetaData - Resolving metadata for "model.Node2@649769713". 439 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@649769713.childs". 439 case2 TRACE [main] openjpa.MetaData - Resolving field "model.no...@649769713.id". 439 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@649769713.parent". 440 case2 TRACE [main] openjpa.MetaData - Preparing mapping for "model.Node2". 445 case2 TRACE [main] openjpa.MetaData - Processing registered persistence-capable class "class model.Node2". 446 case2 TRACE [main] openjpa.MetaData - Resolving field "model.no...@649769713.id". 446 case2 TRACE [main] openjpa.MetaData - "id" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.HandlerFieldStrategy". 446 case2 TRACE [main] openjpa.MetaData - "model.Node2<discriminator>" has mapping strategy "none". 446 case2 TRACE [main] openjpa.MetaData - "model.Node2<version>" has mapping strategy "none". 446 case2 TRACE [main] openjpa.MetaData - Resolving mapping for "model.Node2@649769713". 446 case2 TRACE [main] openjpa.MetaData - "model.Node2" has mapping strategy "full". 446 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@649769713.childs". 446 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@649769713.parent". 446 case2 TRACE [main] openjpa.MetaData - "parent" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy". 446 case2 TRACE [main] openjpa.MetaData - "childs" has mapping strategy "org.apache.openjpa.jdbc.meta.strats.RelationCollectionInverseKeyFieldStrategy". 446 case2 TRACE [main] openjpa.MetaData - Initializing mapping for "model.Node2@649769713". 446 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@649769713.childs". 447 case2 TRACE [main] openjpa.MetaData - Resolving field "model.no...@649769713.id". 447 case2 TRACE [main] openjpa.MetaData - Resolving field "model.Node2@649769713.parent". 469 case2 TRACE [main] openjpa.jdbc.SQLDiag - selectPrimaryKey: oid=0 class model.Node2 483 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 79161706> executing prepstmnt 1552221437 SELECT t0.id FROM nodes t0 WHERE t0.id = ? [params=?] 483 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 79161706> [0 ms] spent 486 case2 TRACE [main] openjpa.jdbc.JDBC - <t 1784131088, conn 79161706> [1 ms] close 502 case2 TRACE [main] openjpa.jdbc.JDBC - The batch limit is set to 0. 504 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1464177809> executing prepstmnt 1563053805 INSERT INTO nodes () VALUES () 505 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1464177809> [1 ms] spent 506 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1464177809> executing prepstmnt 839771540 INSERT INTO case2 (child, PARENT_ID) VALUES (?, ?) [params=?, ?] 506 case2 TRACE [main] openjpa.jdbc.SQL - <t 1784131088, conn 1464177809> [0 ms] spent 506 case2 TRACE [main] openjpa.Runtime - An exception occurred while ending the transaction. This exception will be re-thrown.<openjpa-3.1.1-r1440702 fatal store error> org.apache.openjpa.util.StoreException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: model.Node2@33aeca0b at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116) at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600) at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669) at test.TestNode.bootstrapNode2(TestNode.java:35) at test.TestNode.testCase2(TestNode.java:47) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:542) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:770) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:464) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:210) Caused by: <openjpa-3.1.1-r1440702 fatal store error> org.apache.openjpa.util.StoreException: ERREUR: erreur de syntaxe sur ou près de « ) » Position : 20 {prepstmnt 1563053805 INSERT INTO nodes () VALUES ()} [code=0, state=42601] FailedObject: model.Node2@33aeca0b at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5250) at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:361) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:353) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:101) at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) ... 32 more Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERREUR: erreur de syntaxe sur ou près de « ) » Position : 20 {prepstmnt 1563053805 INSERT INTO nodes () VALUES ()} [code=0, state=42601] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) ... 43 more NestedThrowables: <openjpa-3.1.1-r1440702 fatal store error> org.apache.openjpa.util.StoreException: ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction {prepstmnt 839771540 INSERT INTO case2 (child, PARENT_ID) VALUES (?, ?) [params=?, ?]} [code=0, state=25P02] FailedObject: model.Node2@33aeca0b at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5250) at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:361) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:353) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:101) at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116) at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600) at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669) at test.TestNode.bootstrapNode2(TestNode.java:35) at test.TestNode.testCase2(TestNode.java:47) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:542) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:770) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:464) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:210) Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction {prepstmnt 839771540 INSERT INTO case2 (child, PARENT_ID) VALUES (?, ?) [params=?, ?]} [code=0, state=25P02] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1856) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) ... 43 more NestedThrowables: org.postgresql.util.PSQLException: ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2510) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2245) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:311) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:125) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1186) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1856) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:361) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:353) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:101) at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116) at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600) at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669) at test.TestNode.bootstrapNode2(TestNode.java:35) at test.TestNode.testCase2(TestNode.java:47) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:542) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:770) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:464) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:210) Caused by: org.postgresql.util.PSQLException: ERREUR: erreur de syntaxe sur ou près de « ) » Position : 20 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2510) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2245) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:311) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:125) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1186) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) ... 45 more
508 case2 TRACE [main] openjpa.jdbc.JDBC - <t 1784131088, conn 1464177809> [0 ms] rollback 509 case2 TRACE [main] openjpa.jdbc.JDBC - <t 1784131088, conn 1464177809> [1 ms] close 509 case2 TRACE [main] openjpa.Runtime - An exception occurred while ending the transaction. This exception will be re-thrown.<openjpa-3.1.1-r1440702 fatal store error> org.apache.openjpa.util.StoreException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: model.Node2@33aeca0b at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116) at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600) at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669) at test.TestNode.bootstrapNode2(TestNode.java:35) at test.TestNode.testCase2(TestNode.java:47) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:542) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:770) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:464) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:210) Caused by: <openjpa-3.1.1-r1440702 fatal store error> org.apache.openjpa.util.StoreException: ERREUR: erreur de syntaxe sur ou près de « ) » Position : 20 {prepstmnt 1563053805 INSERT INTO nodes () VALUES ()} [code=0, state=42601] FailedObject: model.Node2@33aeca0b at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5250) at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:361) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:353) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:101) at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) ... 32 more Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERREUR: erreur de syntaxe sur ou près de « ) » Position : 20 {prepstmnt 1563053805 INSERT INTO nodes () VALUES ()} [code=0, state=42601] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) ... 43 more NestedThrowables: <openjpa-3.1.1-r1440702 fatal store error> org.apache.openjpa.util.StoreException: ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction {prepstmnt 839771540 INSERT INTO case2 (child, PARENT_ID) VALUES (?, ?) [params=?, ?]} [code=0, state=25P02] FailedObject: model.Node2@33aeca0b at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5250) at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:361) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:353) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:101) at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116) at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600) at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669) at test.TestNode.bootstrapNode2(TestNode.java:35) at test.TestNode.testCase2(TestNode.java:47) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:542) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:770) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:464) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:210) Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction {prepstmnt 839771540 INSERT INTO case2 (child, PARENT_ID) VALUES (?, ?) [params=?, ?]} [code=0, state=25P02] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1856) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) ... 43 more NestedThrowables: org.postgresql.util.PSQLException: ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2510) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2245) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:311) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:125) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1186) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1856) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:361) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flushGraph(ConstraintUpdateManager.java:353) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:101) at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116) at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600) at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669) at test.TestNode.bootstrapNode2(TestNode.java:35) at test.TestNode.testCase2(TestNode.java:47) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:542) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:770) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:464) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:210) Caused by: org.postgresql.util.PSQLException: ERREUR: erreur de syntaxe sur ou près de « ) » Position : 20 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2510) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2245) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:311) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:125) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1186) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) ... 45 more -- Sent from: http://openjpa.208410.n2.nabble.com/OpenJPA-Developers-f210739.html