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
