RE: JDBC version vs JDK

["Gary L Peskin" <garyp@xxxxxxxxxxxx>]

Fred --

Thanks for your response.  I appreciate your statement that:

"db2_classes.jar is not JDK nor JDBC version specific. We have 
written it in such a way that for any JDK currently supported 
by the iSeries, it will work."

However, I think you'll find that the following program:

  public class Foo
  {
    public static void main(String[] argv)
    throws Exception
    {
       Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
       java.sql.Connection jdbcConnection = 
          java.sql.DriverManager.getConnection(
                 "jdbc:db2:*LOCAL/SIMBROWSE", "", "");
    }
  }
  
causes:
  
  java.lang.NoClassDefFoundError: java/sql/Savepoint

when running under J2SDK 1.3.
 
I think that this is because the Connection interface requires the
java.sql.Savepoint interface which is not present in J2 SDK 1.3. Note that
no JDBC 3.0 facilities are being used.
 
If you are able to reproduce this problem on your end, can you advise as to
a workaround?  I supposed I could always bring in a java.sql.Savepoint
interface class and put it in the bootclasspath.

Also, could this be caused by the fact that
/QIBM/ProdData/Java400/ext/db2_classes.jar is supplied with a *JVAPGM at
Optimization level 40?  I vaguely remember reading somewhere that
optimization level of 40 can cause preloading of some associated classes
even if they're not referenced in a particular application.

TIA,
Gary


> -----Original Message-----
> From: java400-l-bounces+garyp=firstech.com@xxxxxxxxxxxx 
> [mailto:java400-l-bounces+garyp=firstech.com@xxxxxxxxxxxx] On 
> Behalf Of Fred Kulack
> Sent: Friday, August 15, 2003 7:30 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: JDBC version vs JDK
> 
> 
> 
> On 08/13/2003 at 10:45:50 AM, java400-l-bounces@xxxxxxxxxxxx 
> wrote: For the interim, I have FTPd an older version of 
> db2_classes.jar to a directory and then set up 
> /QIBM/UserData/Java400/ext as a link to point there.  This 
> seems to be working.
> --- end of excerpt ---
> 
> Warning: DO NOT DO THIS.
> db2_classes.jar is a native driver that relies on C/C++ code 
> in the operating system. You're going to hit problems that 
> are not predictable by doing that.
> 
> db2_classes.jar is not JDK nor JDBC version specific. We have 
> written it in such a way that for any JDK currently supported 
> by the iSeries, it will work.
> 
> The JDBC interfaces provided with the base JDK simply end up 
> hiding the implementations of features provided for newer 
> JDBC/JDK versions.
> 
> Indeed, with some creative typecasts, you can even use some 
> of those new features in older versions of the JDK.
> 
> 
> 
> "The stuff we call "software" is not like anything that human society
>   is used to thinking about. Software is something like a machine, and
>   something like mathematics, and something like language, and
>   something like thought, and art, and information...
>   but software is not in fact any of those other things."
> Bruce Sterling - The Hacker Crackdown
> 
> Fred A. Kulack - IBM eServer iSeries - Enterprise Application 
> Solutions ERP, Java DB2 access, Jdbc, JTA, etc...
> IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
> mailto:kulack@xxxxxxxxxx   Personal: mailto:kulack@xxxxxxxxxxxxxx
> AIM Home:FKulack  AIM Work:FKulackWrk
> MSN Work: fakulack@xxxxxxxxxxx
> 
> _______________________________________________
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list To post a message email: 
> JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>