× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.