[
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.
