[hbozic]

I am having problems reverse engineering hibernate using a jdbc connection to an AS/400 (iSeries)
MyEclispe always assumes that every column in the table is part of a composite key — However In reality, only one column is a primary key

it generates artifacts like:
<hibernate-mapping>
<class name=”com.lsuc.test.LCMIOD30″ table=”LCMIOD30″ schema=”xxxxx” catalog=”xxxxxxx”>
<comment>Member Information Online Details – Download file</comment>
<composite-id name=”id” class=”com.lsuc.test.LCMIOD30Id”>
<key-property name=”mimbnb” type=”java.lang.String”>
<column name=”MIMBNB” length=”6″ />
</key-property>
<key-property name=”mifnam” type=”java.lang.String”>
<column name=”MIFNAM” length=”35″ />
</key-property>
<key-property name=”mimnam” type=”java.lang.String”>
<column name=”MIMNAM” length=”35″ />
</key-property>
<key-property name=”milnam” type=”java.lang.String”>
<column name=”MILNAM” length=”35″ />
</key-property>
etc….

THe database explorer connects properly to the database and seems to function just fine. Also the reverse engineering functions seem to generate code OK.

Can you help to determine what is happening? What tracing/debugging can I turn on to see why it is doing this?

Hank

BTW, if I go ahead and properly refactor(fix) the code that is generated by MyEclispe, and test it for CRUD, it works fine .

myeclipse 6.5
jdbc jar jt400.jar (version 6)
hibernate 3.2

[hbozic]

It seem that no primary key was reported back:

Rev.eng. strategy did not report any primary key columns for LRRFRL01

Unknown change: #text(
)@[253, 256] (
) CHANGE
Unknown change: #text(
)@[352, 356] (
) CHANGE
Unknown change: #text(
)@[369, 374] (
) CHANGE
Unknown change: #text(
)@[414, 418] (
) CHANGE
Unknown change: #text(
)@[432, 435] (
) CHANGE
Unknown change: #text(
)@[443, 446] (
) CHANGE
Unknown change: #text(
)@[443, 445] (
) CHANGE
Wed Oct 15 15:02:00:490 EDT 2008 as400: ResultSet ImportedKeys (22996016) open.
Wed Oct 15 15:02:00:490 EDT 2008 as400: ResultSet ImportedKeys (22996016) : Conncurrency = “1007”.
Wed Oct 15 15:02:00:490 EDT 2008 as400: ResultSet ImportedKeys (22996016) : Fetch direction = “1000”.
Wed Oct 15 15:02:00:490 EDT 2008 as400: ResultSet ImportedKeys (22996016) : Fetch size = “0”.
Wed Oct 15 15:02:00:490 EDT 2008 as400: ResultSet ImportedKeys (22996016) : Max rows = “0”.
Wed Oct 15 15:02:00:490 EDT 2008 as400: ResultSet ImportedKeys (22996016) : Type = “1004”.
Wed Oct 15 15:02:00:506 EDT 2008 as400: ResultSet ExportedKeys (14109072) open.
Wed Oct 15 15:02:00:506 EDT 2008 as400: ResultSet ExportedKeys (14109072) : Conncurrency = “1007”.
Wed Oct 15 15:02:00:506 EDT 2008 as400: ResultSet ExportedKeys (14109072) : Fetch direction = “1000”.
Wed Oct 15 15:02:00:506 EDT 2008 as400: ResultSet ExportedKeys (14109072) : Fetch size = “0”.
Wed Oct 15 15:02:00:506 EDT 2008 as400: ResultSet ExportedKeys (14109072) : Max rows = “0”.
Wed Oct 15 15:02:00:506 EDT 2008 as400: ResultSet ExportedKeys (14109072) : Type = “1004”.
Wed Oct 15 15:02:02:990 EDT 2008 as400: ResultSet ImportedKeys (22996016) closed.
Wed Oct 15 15:02:02:990 EDT 2008 as400: ResultSet ExportedKeys (14109072) closed.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : access = “all”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : block size = “32”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : block criteria = “2”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : date format = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : date separator = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : decimal separator = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : errors = “basic”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : extended dynamic = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : libraries = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : naming = “sql”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : package = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : package add = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : package cache = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : package clear = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : package error = “warning”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : package library = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : password = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : prefetch = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : prompt = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : remarks = “system”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : sort = “hex”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : sort language = “ENU”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : sort table = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : sort weight = “shared”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : time format = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : time separator = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : trace = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : transaction isolation = “read uncommitted”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : translate binary = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : user = “hbozic”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : package criteria = “default”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : lob threshold = “32768”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : secure = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : data truncation = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : proxy server = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : secondary URL = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : data compression = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : big decimal = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : thread used = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : cursor hold = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : lazy close = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : driver = “toolbox”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : bidi string type = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : key ring name = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : key ring password = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : full open = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : server trace = “0”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : database name = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : extended metadata = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : cursor sensitivity = “asensitive”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : behavior override = “0”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : package ccsid = “13488”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : minimum divide scale = “0”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : maximum precision = “31”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : maximum scale = “31”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : translate hex = “character”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : toolbox trace = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : qaqqinilib = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : login timeout = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : true autocommit = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : bidi implicit reordering = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : bidi numeric ordering = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : hold input locators = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : hold statements = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : rollback cursor hold = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : variable field compression = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : query optimize goal = “0”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : keep alive = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : receive buffer size = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : send buffer size = “”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : XA loosely coupled support = “0”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : translate boolean = “true”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : metadata source = “1”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : query storage limit = “-1”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : decfloat rounding mode = “half even”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : autocommit exception = “false”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Properties (6209416) : Extra property: “autocommit”.
Wed Oct 15 15:02:03:022 EDT 2008 as400: Driver AS/400 Toolbox for Java JDBC Driver (7952623) : Using IBM Tool
box for Java JDBC driver implementation.
Wed Oct 15 15:02:03:115 EDT 2008 as400: static method: Posting warning, sqlState: 01H20 reason: Extra connect
ion property is ignored. vendor code -99999.java.sql.SQLWarning: Extra connection property is ignored.
at com.ibm.as400.access.JDError.getSQLWarning(JDError.java:300)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3063)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3035)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3028)
at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1242)
at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1105)
at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
at org.hibernate.console.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:40)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvi
der.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2005)
at com.genuitec.eclipse.hibernate.wizards.MEJDBCMetaDataConfiguration.readFromJDBC(MEJDBCMetaDataConfi
guration.java:72)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob$7.execute(GenerateArtifactsJob.java:877
)
at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:65)
at org.hibernate.console.ConsoleConfiguration.execute(ConsoleConfiguration.java:91)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.buildConfiguration(GenerateArtifactsJob
.java:858)
at com.genuitec.eclipse.hibernate.wizards.GenerateArtifactsJob.run(GenerateArtifactsJob.java:405)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Wed Oct 15 15:02:03:115 EDT 2008 as400: Toolbox for Java – Open Source Software, JTOpen 6.0, codebase 5722-JC
1 V5R4M0.6
Wed Oct 15 15:02:03:115 EDT 2008 as400: JDBC Level: 30
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Client CCSID = 13488
.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Setting server NLV =
2924.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Client functional le
vel = V5R4M01 .
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Data compression = R
LE.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : ROWID supported = tr
ue.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : True auto-commit sup
ported = true.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : 128 byte column name
s supported = true.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Maximum decimal prec
ision = 31.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Maximum decimal scal
e = 31.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Minimum divide scale
= 0.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Translate hex = char
acter.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : query optimize goal
= 0.
Wed Oct 15 15:02:03:115 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Using extended datas
treams.
Wed Oct 15 15:02:03:272 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : JDBC driver major ve
rsion = 7.
Wed Oct 15 15:02:03:272 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : i5/OS VRM = V5R4M0.
Wed Oct 15 15:02:03:272 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Server CCSID = 37.
Wed Oct 15 15:02:03:272 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Server functional le
vel = V5R4M00014 (14).
Wed Oct 15 15:02:03:272 EDT 2008 as400: Connection SYSTEMS.xxx.xxx.xxx.CA(21325020) : Server job identifie
r = 565351/QUSER/QZDASOINIT.
Wed Oct 15 15:02:03:272 EDT 2008 as400: Properties (6209416) : decimal separator = “.”.
Wed Oct 15 15:02:03:287 EDT 2008 as400: Properties (6209416) : date format = “dmy”.
Wed Oct 15 15:02:03:287 EDT 2008 as400: Properties (6209416) : date separator = “/”.
Wed Oct 15 15:02:03:287 EDT 2008 as400: Properties (6209416) : time format = “hms”.
Wed Oct 15 15:02:03:287 EDT 2008 as400: Properties (6209416) : time separator = “:”.
Wed Oct 15 15:02:03:287 EDT 2008 as400: Connection S109A12F (21325020) open.
Wed Oct 15 15:02:03:287 EDT 2008 as400: Connection S109A12F (21325020) : Auto commit = “true”.
Wed Oct 15 15:02:03:287 EDT 2008 as400: Connection S109A12F (21325020) : Read only = “false”.
Wed Oct 15 15:02:03:287 EDT 2008 as400: Connection S109A12F (21325020) : Transaction isolation = “1”.
Wed Oct 15 15:02:03:443 EDT 2008 as400: ResultSet Tables (30396536) open.
Wed Oct 15 15:02:03:443 EDT 2008 as400: ResultSet Tables (30396536) : Conncurrency = “1007”.
Wed Oct 15 15:02:03:443 EDT 2008 as400: ResultSet Tables (30396536) : Fetch direction = “1000”.
Wed Oct 15 15:02:03:443 EDT 2008 as400: ResultSet Tables (30396536) : Fetch size = “0”.
Wed Oct 15 15:02:03:443 EDT 2008 as400: ResultSet Tables (30396536) : Max rows = “0”.
Wed Oct 15 15:02:03:443 EDT 2008 as400: ResultSet Tables (30396536) : Type = “1004”.
Wed Oct 15 15:02:03:459 EDT 2008 as400: ResultSet Tables (30396536) closed.
Wed Oct 15 15:02:03:615 EDT 2008 as400: ResultSet Columns (8744362) open.
Wed Oct 15 15:02:03:615 EDT 2008 as400: ResultSet Columns (8744362) : Conncurrency = “1007”.
Wed Oct 15 15:02:03:615 EDT 2008 as400: ResultSet Columns (8744362) : Fetch direction = “1000”.
Wed Oct 15 15:02:03:615 EDT 2008 as400: ResultSet Columns (8744362) : Fetch size = “0”.
Wed Oct 15 15:02:03:615 EDT 2008 as400: ResultSet Columns (8744362) : Max rows = “0”.
Wed Oct 15 15:02:03:615 EDT 2008 as400: ResultSet Columns (8744362) : Type = “1004”.
Wed Oct 15 15:02:03:631 EDT 2008 as400: ResultSet Columns (8744362) closed.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet PrimaryKeys (29142765) open.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet PrimaryKeys (29142765) : Conncurrency = “1007”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet PrimaryKeys (29142765) : Fetch direction = “1000”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet PrimaryKeys (29142765) : Fetch size = “0”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet PrimaryKeys (29142765) : Max rows = “0”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet PrimaryKeys (29142765) : Type = “1004”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet PrimaryKeys (29142765) closed.
(617766 ms) [Worker-8] WARN : org.hibernate.cfg.reveng.JDBCReader#processPrimaryKey : The JDBC driver didn’t r
eport any primary key columns in LRRFRL01. Asking rev.eng. strategy
(617766 ms) [Worker-8] WARN : org.hibernate.cfg.reveng.JDBCReader#processPrimaryKey : Rev.eng. strategy did no
t report any primary key columns for LRRFRL01
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet IndexInfo (8420284) open.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet IndexInfo (8420284) : Conncurrency = “1007”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet IndexInfo (8420284) : Fetch direction = “1000”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet IndexInfo (8420284) : Fetch size = “0”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet IndexInfo (8420284) : Max rows = “0”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet IndexInfo (8420284) : Type = “1004”.
Wed Oct 15 15:02:03:647 EDT 2008 as400: ResultSet IndexInfo (8420284) closed.
Wed Oct 15 15:02:03:662 EDT 2008 as400: ResultSet ExportedKeys (20679024) open.
Wed Oct 15 15:02:03:662 EDT 2008 as400: ResultSet ExportedKeys (20679024) : Conncurrency = “1007”.
Wed Oct 15 15:02:03:662 EDT 2008 as400: ResultSet ExportedKeys (20679024) : Fetch direction = “1000”.
Wed Oct 15 15:02:03:662 EDT 2008 as400: ResultSet ExportedKeys (20679024) : Fetch size = “0”.
Wed Oct 15 15:02:03:662 EDT 2008 as400: ResultSet ExportedKeys (20679024) : Max rows = “0”.
Wed Oct 15 15:02:03:662 EDT 2008 as400: ResultSet ExportedKeys (20679024) : Type = “1004”.
Wed Oct 15 15:02:03:662 EDT 2008 as400: ResultSet ExportedKeys (20679024) closed.
Wed Oct 15 15:02:03:662 EDT 2008 as400: Connection S109A12F (21325020) closed.

[hbozic]

I think that we understand what the issue is.
It seem that the DB2/400 will not report (primary) keys when tables are created using native AS/400 methods such as DDS. However creating tables and keys using SQL DDL will work just fine.

Hank

[hbozic]

Also this problem is detailed in the hibernate JIRA

http://opensource.atlassian.com/projects/hibernate/browse/HBX-428

[Author]

Posts