You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Amy Yang (JIRA)" <ji...@apache.org> on 2008/03/31 20:12:24 UTC
[jira] Created: (OPENJPA-549) Get NPE when running mappingtool
against DB2 database
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
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.
[jira] Resolved: (OPENJPA-549) Get NPE when running mappingtool
against DB2 database
Posted by "Catalina Wei (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Assigned: (OPENJPA-549) Get NPE when running mappingtool
against DB2 database
Posted by "Catalina Wei (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OPENJPA-549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Catalina Wei reassigned OPENJPA-549:
------------------------------------
Assignee: Catalina Wei
I
> 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.