RE: No suitable Driver error when running Java on AS400

As Magne pointed out, you need the missing ":" in the jdbc url:
Connection con =
DriverManager.getConnection("jdbc:as400://mldev400/SPANAND");

This is why it's not finding the driver, even though it's on the classpath.

Regards,
Chris.


-----Original Message-----
From: Colin Williams [mailto:colin.williams@xxxxxxxxxxxx]
Sent: 27 June 2005 13:31
To: Java Programming on and around the iSeries / AS400
Subject: RE: No suitable Driver error when running Java on AS400


Anand,

I usually just point to the jt400 file that comes with the OS

Also

Try replacing your

        DriverManager.registerDriver(new
com.ibm.as400.access.AS400JDBCDriver());

With

        Class.forName("com.ibm.as400.access.AS400JDBCDriver");

That's the way I usually do it anyway.

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 13:03
To: Java Programming on and around the iSeries / AS400
Subject: RE: No suitable Driver error when running Java on AS400


        Colin,

        This is my classpath before calling the app....I copied the
jt400.jar file in /java folder..

         export -s

        
CLASSPATH=.:/java/xml/jdom/build/jdom.jar:/java/xml/jdom/lib/xerces.jar:
/java/xml/jdom/lib/xml- apis.jar:/java/xml/jdom    
        /lib/saxpath.jar:/java/xml/jdom/lib/jaxen-
jdom.jar:/java/xml/jdom/lib/xalan.jar:/java/jt400.jar:/java/xml/jdom/lib
/jaxen- 
        core.jar


        Does the jt400.jar needs to be in the root directory.

        rgds,

Rajesh Anand
Email:Rajesh_anand@xxxxxx


-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Colin Williams
Sent: 27 June 2005 12:55
To: Java Programming on and around the iSeries / AS400
Subject: 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/
--------------------------------------------------------