RE: JDBC no suitable driver

Thanks Fred. It's working now. It was a combination of incorrect classpath
and bad coding (on my part).

-----Original Message-----
From: owner-java400-l@midrange.com
[mailto:owner-java400-l@midrange.com]On Behalf Of Fred Kulack
Sent: Thursday, June 21, 2001 1:59 PM
To: JAVA400-L@midrange.com
Subject: RE: JDBC no suitable driver



Stop using the jdbc.drivers property. Its confusing you because
its likely that the classpath is not set correctly and instead of giving
an error, the jdbc.drivers property causes that situation just to be
ignored.

So, for now, SKIP the jdbc.drivers property, and load the driver in the
source code this way:
  DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver());

If this compiles, then, GUARANTEED, you have the classpath set correctly.
Keep the CLASSPATH the same when you run it.

If this doesn't compiled, then GUARANTEED, you have the classpath set
incorrectly.

Download jtopen from http://www.as400.ibm.com/toolbox, to your PC.
Binary FTP jt400.jar to your AS/400 in your IFS directory (lets assume you
put it at /home/kulack/jt400.jar)
Before you do the 'javac' command do this command in Qshell.
export -s CLASSPATH=/home/kulack/jt400.jar:$CLASSPATH

Once you get this working, change the load of the driver
to be jdbc.drivers property or the Class.forName
("com.ibm.as400.AS400JDBCDriver")




"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  -  AS/400e  Java and Java DB2 access, Jdbc, JTA, etc...
IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
mailto:kulack@us.ibm.com   Personal: mailto:kulack@bresnanlink.net
AOL Instant Messenger: Home:FKulack  Work:FKulackWrk


"Peter Anderson @home" <peteranderson2@home.com>@midrange.com on 06/21/2001
10:54:37 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   <JAVA400-L@midrange.com>
cc:
Subject:  RE: JDBC no suitable driver



I've tried various combinations and either it doesn't find the class or I
get the no suitable driver message. Here is the source and how I'm
compiling/running. As I am new at this, there is probably something I'm
missing. When I use the for.name as in Class.forName(AS400JDBCDriver), i
get
the message: java.lang.ClassNotFoundException: AS400JDBCDriver.

I am trying to run this in QSHELL accessing the same AS400.
----------------------------------------------------------------------------

---
import java.util.*;
import java.io.*;
import java.sql.*;

public class TestAS400 {

  public static void main (String[] arg) {
  Connection conn = null;
    try {
      String JDBCDriver ="AS400JDBCDriver";
      String url ="jdbc:as400:sysname";
      String user ="user";
      String password="password";

      conn = DriverManager.getConnection(url,user,password);
      System.out.println("Connected?");

      }
    catch (Exception e) {
      if (e instanceof SQLException)
         System.out.println(((SQLException)e).getSQLState());
      System.out.println(e);
    }
    finally {
      try { conn.close(); } catch (Exception e) {}
      }
  }
}
----------------------------------------------------------------------------

-------
To compile and run, I used QSHELL, enter commands below:

javac TestAS400.java
$
java TestAS400 -Djdbc.drivers=com.ibm.as400.access.AS400JDBCDriver
08001
java.sql.SQLException: No suitable driver
$
----------------------------------------------------------------------------

-------

-----Original Message-----
From: owner-java400-l@midrange.com
[mailto:owner-java400-l@midrange.com]On Behalf Of Fred Kulack
Sent: Tuesday, June 19, 2001 1:58 PM
To: JAVA400-L@midrange.com
Subject: Re: JDBC no suitable driver



Actually, using DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver()); is perfectly reasonable.
Class.forName() is generally better simply because the JDBC driver doesn't
have to be in your classpath to compile.
In either case, since you're not getting a ClassNotFound exception, you've
got your classpath set correctly.
You have the URL wrong? Toolbox uses jdbc:as400:systemname as the URL.


"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  -  AS/400e  Java and Java DB2 access, Jdbc, JTA, etc...
IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
mailto:kulack@us.ibm.com   Personal: mailto:kulack@bresnanlink.net
AOL Instant Messenger: Home:FKulack  Work:FKulackWrk

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---