Hi James
That call might also take care of an issue in another thread, about the
default database in mySql and how to do that in IBM i - there is a
property called 'libraries', that could be set for the IBM i - another
property, maybe 'database', could be used for a different RDBMS.
Nice!
Vern
On 2/6/2013 4:33 PM, James H. H. Lampert wrote:
I got JDBCTEST[C]3 running today, using a familiar DB2/400 file
(AQUESTVIEW/VIEWCUS, of course), and discovered that until I added the call:
JDBC_setProp(prop: 'naming' : 'system')
it would blow sky-high, as soon as it tried to jdbc_GetMetaData,
throwing dumps to both STDOUT and several spool files, and tying up the
job for a good minute or so before abending without releasing all its
resources.
Then, I found out that if I checked the result set before attempting to
retrieve the meta-data, to verify that it wasn't null, it would abort
cleanly if the naming property wasn't set properly.
You learn something new every day. And the biggest surprise I've had in
this project is that the pleasant surprises have outnumbered the
unpleasant ones.
--
JHHL
