× 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.



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.