MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 2013

Re: Starting to experiment with Scott Klement's JDBCR4 -- what's the DB2/400 equivalent to MySQL "USE"



fixed

On 2/1/13 3:33 PM, Vernon Hamberg wrote:
USE sets the current database - on the i, a library is the same
thing as what MySQL and others call a database.

There is a SET OPTION DFTRDBCOL schema-name that gets you the same
thing.

Or you can set naming convention in JDBC to SQL and set the default
collection there.

Hmm.

I replaced
rc = JDBC_ExecUpd( conn : 'Use testsck' );
with
rc = JDBC_ExecUpd( conn : 'SET OPTION DFTRDBCOL TESTSCK' );

and even though by the time the exception is thrown, the TESTSCK library
does exist, I still end up with:
RPG procedure JDBC_EXECU in program JDBCR4/JDBCR4 received Java
exception "java.sql.SQLException: [SQL0204] TESTSCK in *N type *LIB
not found." when calling method "executeUpdate" with signature
"(Ljava.lang.String;)I" in class "java.sql.Statement".

followed, confusingly, by:
RPG procedure JDBC_EXECU in program JDBCR4/JDBCR4 received Java
exception "java.sql.SQLException: [SQL0104] Token TESTSCK was not
valid. Valid tokens: =." when calling method "executeUpdate" with
signature "(Ljava.lang.String;)I" in class "java.sql.Statement".

Not quite sure what to make of it.

--
JHHL





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact