[
https://issues.apache.org/jira/browse/OPENJPA-549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Catalina Wei resolved OPENJPA-549.
----------------------------------
Resolution: Won't Fix
In connection-less situation, we don't know the back-end DB2 version. so we
cannot generate "Create Index" DDL unconditionally in connection-less
situations.
The rational is that index on the primary key column is auto-created by DB2
NT/Linux version 8 or later and DB2 ZOS version 9.
A manual "create index "on primary key column results in following error on
DB2NT/Linux (but tolerated by DB2 ZOS version 9):
SQL0605W The index was not created because an index
"SYSIBM.SQL080327142322600" with a matching definition already exists.
SQLSTATE=01550
Index on primary key column is required in DB2 ZOS version 8 or earlier
versions, the method createIndexIfNecessary() in DB2Dictionary is for this
purpose.
We think the DDL generated by the MappingTool is likely needing modification
for DB2 ZOS back-ends.
DDLs for table space creation, Auxiliary table creation required for BLOB/CLOB
columns, are the examples that require user interventions.
In connection-less situations, we think it is OK not generating the Create
Index DDL.
Since the NullPointerException problem is fixed in OPENJPA-555, no more fix
will be done to this issue.
Catalina
> Get NPE when running mappingtool against DB2 database
> -----------------------------------------------------
>
> Key: OPENJPA-549
> URL: https://issues.apache.org/jira/browse/OPENJPA-549
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 1.1.0
> Environment: os.name: Windows XP
> os.version: 5.1
> os.arch: x86
> java.version: 1.6.0_02
> java.vendor: BEA Systems, Inc.
> Reporter: Amy Yang
> Assignee: Catalina Wei
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> When running mappintool aginast DB2, under certain case NPE will be thrown:
> java.lang.NullPointerException
> at
> org.apache.openjpa.jdbc.sql.DB2Dictionary.isDB2ZOSV8xOrLater(DB2Dictionary.java:392)
> at
> org.apache.openjpa.jdbc.sql.DB2Dictionary.createIndexIfNecessary(DB2Dictionary.java:784)
> at
> org.apache.openjpa.jdbc.kernel.TableJDBCSeq.addSchema(TableJDBCSeq.java:244)
> at
> org.apache.openjpa.jdbc.meta.MappingTool.addSequenceComponents(MappingTool.java:609)
> at
> org.apache.openjpa.jdbc.meta.MappingTool.addSequenceComponents(MappingTool.java:591)
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:477)
> at org.apache.openjpa.jdbc.meta.MappingTool.run(MappingTool.java:1075)
> at
> org.apache.openjpa.jdbc.ant.MappingToolTask.executeOn(MappingToolTask.java:197)
> at
> org.apache.openjpa.lib.ant.AbstractTask.execute(AbstractTask.java:172)
> at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
> at org.apache.tools.ant.Task.perform(Task.java:364)
> at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:64)
> at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
> at org.apache.tools.ant.Task.perform(Task.java:364)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
