RE: JDBC no suitable driver

["Peter Anderson @home" <peteranderson2@xxxxxxxx>]

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
+---