Hello,
I'm trying to use jakarta ojb for database access in a web application.
For this I have to generate a object-relational mapping. There is a
tool, reversedb, that will generate this for a live database.
When I run this against my postgresql database I get the following
exception:
java.lang.NullPointerException
at
org.postgresql.jdbc1.AbstractJdbc1DatabaseMetaData.escapeQuotes(AbstractJdbc1DatabaseMetaData.java:1666)
at
org.postgresql.jdbc1.AbstractJdbc1DatabaseMetaData.getPrimaryKeys(AbstractJdbc1DatabaseMetaData.java:2899)
at
org.apache.ojb.tools.mapping.reversedb.DBMeta.read(Unknown Source)
at
org.apache.ojb.tools.mapping.reversedb.gui.JFrmMainFrame.analyzeSchema(Unknown
Source)
(...)
It fails with a npe because table was set to null. Is setting table to
null for the getPrimaryKeys illegall according to jdbc specification?
As it seems ojb is requesting primary keys for all tables when table is
set to null, and is assuming this will be legal
From line 279 i in DBMeta.read() in ojb source:
rs = this.dbMeta.getPrimaryKeys(null, null, null);
Attached is a patch which makes the getPrimaryKeys method accept the
value of null for the table parameter.
Is this the correct solution?
Anders
--
Anders Hermansen
YoYo Mobile as