Fascinating: JDBCR4 "JDBC_ConnProp" defaults to 'naming' = 'sql'

["James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>]

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