Yes, this sort of approach should work out fine. If there is an error
with getting them all at once then you can try getting them for each
table, just count on rather slow execution times.
-David
On Nov 2, 2006, at 4:16 PM, Jason Lane wrote:
Ok, I've run into another DB2 issue. It seems that the
getPrimaryKeys call made in the DatabaseUtil class first tries to
get the PrimaryKeys with a 'null' for the tablename. DB2 does not
support those (it throws any error) and instead of the code
catching it and continuing on to the block where it should process
the keys by each table name, it just fails that whole block.
Would it be ok, if I worked on modifying that code slightly to
check for an Exception on that block and then if it does fail just
set the resultSet to null, then on the next block where it's trying
to do a !resultSet.next() just insert resultSet == null || !
resultSet.next()?
Forgive me on this, I'm guessing I probably need to post these kind
of questions to the dev list, but I'm still not super familiar with
all of the various config options in the entityengime.xml so I
might be missing something simple on these primary keys.