RE: No suitable Driver error when running Java on AS400

Anand,

The AS400JDBCDriver that you are trying to register needs to be on you
classpath. You need to add the jar file that holds it, jt400.jar to your
classpath.

On the 400 this is in /QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar

Cheers
Colin.W
http://as400blog.blogspot.com

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Anand, Rajesh
Sent: 27 June 2005 12:46
To: java400-l@xxxxxxxxxxxx
Subject: No suitable Driver error when running Java on AS400


Folks,

        I'm newbie to Java on as400. I've run into a problem,

        can someone please help???

        My java pgm compiles ok and when I run it, it gives me the
following error.

        java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at gmi.pme.ReadIntRateXML.updatetable(ReadIntRateXML.java:134)
        at gmi.pme.ReadIntRateXML.main(ReadIntRateXML.java:116)


        Here is the snippet of my code...


        try{
                        DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver());
                        Connection con =
DriverManager.getConnection("jdbc:as400//mldev400/SPANAND");
                        
                        Statement stmt = con.createStatement();
                        
                        String sqlstmt = "select PMCTN,PMRTY from
BLMINTF1 where PMVSS = " + xpvss.trim();

        Thanks in advance,

Rajesh Anand
Email:Rajesh_anand@xxxxxx
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy,
retain or redistribute it. Click here for important additional terms
relating to this e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------