openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andreas Tomik (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-1853) iSeries DB2 problem with using @GeneratedValue(strategy=GenerationType.IDENTITY)
Date Tue, 26 Oct 2010 05:35:23 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-1853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12924844#action_12924844
] 

Andreas Tomik commented on OPENJPA-1853:
----------------------------------------

Yes, i use the VM argument "javaagent" for entity enhancement.
I tried the workaround with "db2(supportsGetGeneratedKeys=false)", it resolve the problem.
Thank you Jeremy

Enclosed the desired trace output:

Toolbox for Java - Open Source Software, JTOpen 7.1, codebase 5770-SS1 V7R1M0.02
Di Okt 26 07:15:58:247 MESZ 2010  as400: Properties  (3786945) : access = "all".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : block size = "32".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : block criteria = "2".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : date format = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : date separator = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : decimal separator = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : errors = "basic".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : extended dynamic = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : libraries = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : naming = "sql".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : package = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : package add = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : package cache = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : package clear = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : package error = "warning".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : package library = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : password = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : prefetch = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : prompt = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : remarks = "system".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : sort = "hex".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : sort language = "ENU".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : sort table = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : sort weight = "shared".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : time format = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : time separator = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : trace = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : transaction isolation = "read
uncommitted".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : translate binary = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : user = "m0006289".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : package criteria = "default".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : lob threshold = "32768".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : secure = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : data truncation = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : proxy server = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : secondary URL = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : data compression = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : big decimal = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : thread used = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : cursor hold = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : lazy close = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : driver = "toolbox".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : bidi string type = "5".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : key ring name = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : key ring password = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : full open = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : server trace = "0".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : database name = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : extended metadata = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : cursor sensitivity = "asensitive".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : behavior override = "0".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : package ccsid = "13488".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : minimum divide scale = "0".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : maximum precision = "31".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : maximum scale = "31".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : translate hex = "character".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : toolbox trace = "jdbc".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : qaqqinilib = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : login timeout = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : true autocommit = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : bidi implicit reordering
= "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : bidi numeric ordering = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : hold input locators = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : hold statements = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : rollback cursor hold = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : variable field compression
= "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : query optimize goal = "0".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : keep alive = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : receive buffer size = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : send buffer size = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : XA loosely coupled support
= "0".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : translate boolean = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : metadata source = "-1".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : query storage limit = "-1".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : decfloat rounding mode =
"half even".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : autocommit exception = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : auto commit = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : ignore warnings = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : secure current user = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : concurrent access resolution
= "0".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : jvm16 synchronize = "true".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : socket timeout = "".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : use block update = "false".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Properties  (3786945) : maximum blocked input rows
= "32000".
Di Okt 26 07:15:58:262 MESZ 2010  as400: Driver AS/400 Toolbox for Java JDBC Driver (11867140)
: Using IBM Toolbox for Java JDBC driver implementation.
Di Okt 26 07:15:58:403 MESZ 2010  as400: Properties  (3786945) : metadata source = "0".
Di Okt 26 07:15:58:403 MESZ 2010  as400: Toolbox for Java - Open Source Software, JTOpen 7.1,
codebase 5770-SS1 V7R1M0.02
Di Okt 26 07:15:58:403 MESZ 2010  as400: JDBC Level: 40
Di Okt 26 07:15:58:403 MESZ 2010  as400: Properties  (3786945) : package ccsid = "13488".
Di Okt 26 07:15:58:403 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Client CCSID
= 13488.
Di Okt 26 07:15:58:403 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Setting server
NLV = 2929.
Di Okt 26 07:15:58:403 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Client functional
level = V7R1M01   .
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Data compression
= RLE.
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : ROWID supported
= true.
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : True auto-commit
supported = true.
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : 128 byte column
names supported = true.
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Maximum decimal
precision = 31.
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Maximum decimal
scale = 31.
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Minimum divide
scale = 0.
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Translate hex
= character.
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : query optimize
goal = 0.
Di Okt 26 07:15:58:419 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Using extended
datastreams.
Di Okt 26 07:15:58:434 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : JDBC driver
major version = 9.
Di Okt 26 07:15:58:434 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : IBM i VRM =
V5R4M0.
Di Okt 26 07:15:58:434 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Server CCSID
= 273.
Di Okt 26 07:15:58:434 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Server functional
level = V5R4M00014 (14).
Di Okt 26 07:15:58:434 MESZ 2010  as400: Connection 172.25.1.210 (29616570) : Server job identifier
= 056769/QUSER/QZDASOINIT.
Di Okt 26 07:15:58:434 MESZ 2010  as400: Properties  (3786945) : decimal separator = ".".
Di Okt 26 07:15:58:434 MESZ 2010  as400: Properties  (3786945) : date format = "dmy".
Di Okt 26 07:15:58:434 MESZ 2010  as400: Properties  (3786945) : date separator = ".".
Di Okt 26 07:15:58:434 MESZ 2010  as400: Properties  (3786945) : time format = "hms".
Di Okt 26 07:15:58:434 MESZ 2010  as400: Properties  (3786945) : time separator = ":".
Di Okt 26 07:15:58:450 MESZ 2010  as400: Connection JLMTEST (29616570)  open.
Di Okt 26 07:15:58:450 MESZ 2010  as400: Connection JLMTEST (29616570) : Auto commit = "true".
Di Okt 26 07:15:58:450 MESZ 2010  as400: Connection JLMTEST (29616570) : Read only = "false".
Di Okt 26 07:15:58:450 MESZ 2010  as400: Connection JLMTEST (29616570) : Transaction isolation
= "1".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923)  open. Parent: Connection
JLMTEST (29616570) .
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Escape processing
= "true".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Fetch direction =
"1000".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Fetch size = "0".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Max field size = "0".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Max rows = "0".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Query timeout = "0".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Result set concurrency
= "1007".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Result set holdability
= "1".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Result set type =
"1003".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Behavior Override
= "0".
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Data to correlate
statement with cursor Cursor CRSR0001 (18423897) .
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Query timeout = "0".
547  pu.entwicklung_fertigung  TRACE  [main] openjpa.jdbc.SQL - <t 16658781, conn 29616570>
executing stmnt 9110923 SELECT CURRENT SCHEMA FROM SYSIBM.SYSDUMMY1
Di Okt 26 07:15:58:466 MESZ 2010  as400: Statement STMT0001 (9110923) : Executing query, SQL
Statement -->[SELECT CURRENT SCHEMA FROM SYSIBM.SYSDUMMY1].
Di Okt 26 07:15:58:762 MESZ 2010  as400: Statement STMT0001 (9110923) : Prepared STMT0001*,
SQL Statement -->[SELECT CURRENT SCHEMA FROM SYSIBM.SYSDUMMY1].
Di Okt 26 07:15:58:778 MESZ 2010  as400: Cursor CRSR0001 (18423897)  open.
Di Okt 26 07:15:58:794 MESZ 2010  as400: ResultSet CRSR0001 (17165167)  open. Parent: Statement
STMT0001 (9110923) .
Di Okt 26 07:15:58:794 MESZ 2010  as400: ResultSet CRSR0001 (17165167) : Conncurrency = "1007".
Di Okt 26 07:15:58:794 MESZ 2010  as400: ResultSet CRSR0001 (17165167) : Fetch direction =
"1000".
Di Okt 26 07:15:58:794 MESZ 2010  as400: ResultSet CRSR0001 (17165167) : Fetch size = "0".
Di Okt 26 07:15:58:794 MESZ 2010  as400: ResultSet CRSR0001 (17165167) : Max rows = "0".
Di Okt 26 07:15:58:794 MESZ 2010  as400: ResultSet CRSR0001 (17165167) : Type = "1003".
Di Okt 26 07:15:58:794 MESZ 2010  as400: Statement STMT0001 (9110923) : Executed STMT0001*,
SQL Statement --> [SELECT CURRENT SCHEMA FROM SYSIBM.SYSDUMMY1].
Di Okt 26 07:15:58:794 MESZ 2010  as400: Statement STMT0001 (9110923) : Update count = -1.
Di Okt 26 07:15:58:794 MESZ 2010  as400: Statement STMT0001 (9110923) : Result set = true.
Di Okt 26 07:15:58:794 MESZ 2010  as400: Statement STMT0001 (9110923) : Number of result sets
= 0.
Di Okt 26 07:15:58:794 MESZ 2010  as400: Statement STMT0001 (9110923) : Row count estimate
= 1.
875  pu.entwicklung_fertigung  TRACE  [main] openjpa.jdbc.SQL - <t 16658781, conn 29616570>
[328 ms] spent
Di Okt 26 07:15:58:794 MESZ 2010  as400: Cursor CRSR0001 (18423897) : Closing with reuse flag
= 241.
Di Okt 26 07:15:58:794 MESZ 2010  as400: Cursor CRSR0001 (18423897)  closed.
Di Okt 26 07:15:58:794 MESZ 2010  as400: ResultSet CRSR0001 (17165167)  closed.
Di Okt 26 07:15:58:794 MESZ 2010  as400: Statement STMT0001 (9110923)  closed.
Di Okt 26 07:15:58:794 MESZ 2010  as400: Connection JLMTEST (29616570) : Transaction isolation
= "2".
Di Okt 26 07:15:58:809 MESZ 2010  as400: Connection JLMTEST (29616570)  closed.
EntityManager LaborprobeBean: 1094
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : access = "all".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : block size = "32".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : block criteria = "2".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : date format = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : date separator = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : decimal separator = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : errors = "basic".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : extended dynamic = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : libraries = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : naming = "sql".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : package = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : package add = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : package cache = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : package clear = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : package error = "warning".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : package library = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : password = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : prefetch = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : prompt = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : remarks = "system".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : sort = "hex".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : sort language = "ENU".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : sort table = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : sort weight = "shared".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : time format = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : time separator = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : trace = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : transaction isolation =
"read uncommitted".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : translate binary = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : user = "m0006289".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : package criteria = "default".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : lob threshold = "32768".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : secure = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : data truncation = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : proxy server = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : secondary URL = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : data compression = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : big decimal = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : thread used = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : cursor hold = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : lazy close = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : driver = "toolbox".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : bidi string type = "5".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : key ring name = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : key ring password = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : full open = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : server trace = "0".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : database name = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : extended metadata = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : cursor sensitivity = "asensitive".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : behavior override = "0".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : package ccsid = "13488".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : minimum divide scale = "0".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : maximum precision = "31".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : maximum scale = "31".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : translate hex = "character".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : toolbox trace = "jdbc".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : qaqqinilib = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : login timeout = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : true autocommit = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : bidi implicit reordering
= "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : bidi numeric ordering =
"false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : hold input locators = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : hold statements = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : rollback cursor hold = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : variable field compression
= "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : query optimize goal = "0".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : keep alive = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : receive buffer size = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : send buffer size = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : XA loosely coupled support
= "0".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : translate boolean = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : metadata source = "-1".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : query storage limit = "-1".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : decfloat rounding mode =
"half even".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : autocommit exception = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : auto commit = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : ignore warnings = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : secure current user = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : concurrent access resolution
= "0".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : jvm16 synchronize = "true".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : socket timeout = "".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : use block update = "false".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Properties  (20578834) : maximum blocked input rows
= "32000".
Di Okt 26 07:15:59:091 MESZ 2010  as400: Driver AS/400 Toolbox for Java JDBC Driver (11867140)
: Using IBM Toolbox for Java JDBC driver implementation.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Properties  (20578834) : metadata source = "0".
Di Okt 26 07:15:59:106 MESZ 2010  as400: Toolbox for Java - Open Source Software, JTOpen 7.1,
codebase 5770-SS1 V7R1M0.02
Di Okt 26 07:15:59:106 MESZ 2010  as400: JDBC Level: 40
Di Okt 26 07:15:59:106 MESZ 2010  as400: Properties  (20578834) : package ccsid = "13488".
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Client CCSID
= 13488.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Setting server
NLV = 2929.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Client functional
level = V7R1M01   .
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Data compression
= RLE.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : ROWID supported
= true.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : True auto-commit
supported = true.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : 128 byte column
names supported = true.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Maximum decimal
precision = 31.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Maximum decimal
scale = 31.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Minimum divide
scale = 0.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Translate hex
= character.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : query optimize
goal = 0.
Di Okt 26 07:15:59:106 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Using extended
datastreams.
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : JDBC driver
major version = 9.
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : IBM i VRM =
V5R4M0.
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Server CCSID
= 273.
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Server functional
level = V5R4M00014 (14).
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection 172.25.1.210 (23802395) : Server job identifier
= 056769/QUSER/QZDASOINIT.
Di Okt 26 07:15:59:137 MESZ 2010  as400: Properties  (20578834) : decimal separator = ".".
Di Okt 26 07:15:59:137 MESZ 2010  as400: Properties  (20578834) : date format = "dmy".
Di Okt 26 07:15:59:137 MESZ 2010  as400: Properties  (20578834) : date separator = ".".
Di Okt 26 07:15:59:137 MESZ 2010  as400: Properties  (20578834) : time format = "hms".
Di Okt 26 07:15:59:137 MESZ 2010  as400: Properties  (20578834) : time separator = ":".
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection JLMTEST (23802395)  open.
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection JLMTEST (23802395) : Auto commit = "true".
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection JLMTEST (23802395) : Read only = "false".
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection JLMTEST (23802395) : Transaction isolation
= "1".
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection JLMTEST (23802395) : Transaction isolation
= "2".
Di Okt 26 07:15:59:137 MESZ 2010  as400: Connection JLMTEST (23802395) : Auto commit = "false".
Di Okt 26 07:15:59:153 MESZ 2010  as400: Connection JLMTEST (23802395) : Throwing exception,
sqlState: IM001 reason: The driver does not support this function. vendor code -99999.java.sql.SQLException:
The driver does not support this function.
	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
	at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:2210)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.invokeJDBC3(DelegatingConnection.java:593)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:577)
	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:571)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:571)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:571)
	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:563)
	at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:287)
	at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:112)
	at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81)
	at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99)
	at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87)
	at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
	at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
	at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
	at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
	at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
	at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
	at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
	at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2139)
	at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2037)
	at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1955)
	at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
	at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1479)
	at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:925)
	at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:560)
	at de.meyerwerft.qs.laborpruef.laborprobe.dbaccess.LaborprobeBean.crtTest(LaborprobeBean.java:38)
	at de.meyerwerft.test.JSE_Client.jlm_run(JSE_Client.java:35)
	at de.meyerwerft.test.JSE_Client.<init>(JSE_Client.java:10)
	at de.meyerwerft.test.JSE_Client.main(JSE_Client.java:17)

Di Okt 26 07:15:59:153 MESZ 2010  as400: Connection JLMTEST (23802395) : Testing to see if
cursors should be held..
Di Okt 26 07:15:59:153 MESZ 2010  as400: Connection JLMTEST (23802395) : Transaction rollback.
Di Okt 26 07:15:59:153 MESZ 2010  as400: Connection JLMTEST (23802395) : Auto commit = "true".
Di Okt 26 07:15:59:153 MESZ 2010  as400: Connection JLMTEST (23802395)  closed.


> iSeries DB2 problem with using @GeneratedValue(strategy=GenerationType.IDENTITY)
> --------------------------------------------------------------------------------
>
>                 Key: OPENJPA-1853
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1853
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.0.0, 2.0.1
>         Environment: DB2 on IBM iSeries V5R4, jt400.jar (JTOpen)
>            Reporter: Andreas Tomik
>            Assignee: Jeremy Bauer
>            Priority: Critical
>         Attachments: createTable.sql, JSETest.zip
>
>
> I get the following error when I try to insert new row to a table that has a "generated
always Identity" Column.
> Exception in thread "main" <openjpa-2.0.1-r422266:989424 fatal store error> org.apache.openjpa.persistence.RollbackException:
An error occurred attempting to invoke JDBC 3 method.  Your driver or database may not support
JDBC 3 features.
> 	at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:584)
> 	at de.meyerwerft.qs.laborpruef.laborprobe.dbaccess.LaborprobeBean.crtTest(LaborprobeBean.java:38)
> 	at de.meyerwerft.test.JSE_Client.jlm_run(JSE_Client.java:35)
> 	at de.meyerwerft.test.JSE_Client.<init>(JSE_Client.java:10)
> 	at de.meyerwerft.test.JSE_Client.main(JSE_Client.java:17)
> Caused by: <openjpa-2.0.1-r422266:989424 nonfatal general error> org.apache.openjpa.persistence.PersistenceException:
An error occurred attempting to invoke JDBC 3 method.  Your driver or database may not support
JDBC 3 features.
> 	at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1963)
> 	at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
> 	at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1479)
> 	at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:925)
> 	at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:560)
> 	... 4 more
> Caused by: org.apache.commons.lang.exception.NestableRuntimeException: An error occurred
attempting to invoke JDBC 3 method.  Your driver or database may not support JDBC 3 features.
> 	at org.apache.openjpa.lib.jdbc.DelegatingConnection.invokeJDBC3(DelegatingConnection.java:597)
> 	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:577)
> 	at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:571)
> 	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:571)
> 	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:571)
> 	at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:563)
> 	at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:287)
> 	at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:112)
> 	at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81)
> 	at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99)
> 	at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87)
> 	at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
> 	at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
> 	at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> 	at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
> 	at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
> 	at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
> 	at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
> 	at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2139)
> 	at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2037)
> 	at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1955)
> 	... 8 more
> Caused by: java.lang.reflect.InvocationTargetException
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> 	at java.lang.reflect.Method.invoke(Method.java:597)
> 	at org.apache.openjpa.lib.jdbc.DelegatingConnection.invokeJDBC3(DelegatingConnection.java:593)
> 	... 28 more
> Caused by: java.sql.SQLException: The driver does not support this function.
> 	at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415)
> 	at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:2210)
> 	... 33 more
> I have the following in persistence.xml
> ...
> <property name="openjpa.jdbc.DBDictionary" value="db2"/> 
> <property name="openjpa.ConnectionDriverName" value="com.ibm.as400.access.AS400JDBCDriver"/>
> <property name="openjpa.ConnectionURL" value="jdbc:as400://myserver/myschema"/>
> ...
> In Version 1.2.3 this function works fine.
> Thank you,
> Andreas Tomik

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message