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

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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