Solved

ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver

Posted on 2004-09-10
6
1,727 Views
Last Modified: 2008-01-09
Hello,

We are running into a strange issue when trying to run this class named Test.  We are using a program called Optimal J, and when we execute this class inside of Optimal J it works perfectly.  When we try to execute this class using java Test it does not work.  

We ran java -cp . Test and this was the output:

ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver
Exception in thread "main" java.lang.NullPointerException
        at Test.main(Test.java:83)

The classpath is as follows:
C:\Sun\AppServer\jdk\jre\lib\ext

The path to the driver is:
C:\Sun\AppServer\jdk\jre\lib\ext\jt400.jar

We are running Windows XP Professional.

Any help would be greatly appreciated thanks.

Line 83 is commented below.

_____________________________________________________________________________________________________

// this line is used for the IDE but we comment it out when we use javac
package com.gdlp.sales.application.ejb;

import java.rmi.*;
import javax.rmi.*;
import java.math.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
import javax.naming.*;
import javax.transaction.*;
import javax.sql.*;
import java.lang.*;



public class Test
{
    public static void main(String[] args)
    {
      // connection to DB2
      Connection db2 = null;
        try
        {
/*driver*/  Class.forName("com.ibm.as400.access.AS400JDBCDriver");
            db2 = DriverManager.getConnection(
/*url*/         "jdbc:as400:xxxx;translate binary=true;libraries=xxxxxxxx",
/*username*/    "xxxxx",
/*password*/    "xxxxxx");

        }
       

            catch(SQLException e)
            {
               System.out.println("DB2 Connect String SQLException: " + e.getMessage() + "<BR>");
                    while((e = e.getNextException()) != null)
                         System.out.println(e.getMessage() + "\t");
            }      
            catch(ClassNotFoundException e){
            System.out.println("ClassNotFoundException: " + e.getMessage() + "\t");
            }
     
    // code to pull the customer info from DB2
    PreparedStatement prepare     = null;
    ResultSet         result      = null;  
   
   
    ArrayList returnValue = new ArrayList();
    String name = "";
   
     
     
    try {

        String custLoadQuery =
          "select guioo from a767000a";
        prepare = db2.prepareStatement(custLoadQuery, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

        result = prepare.executeQuery();

        while (result.next())
        {  
            name = result.getString("guioo").trim();
            returnValue.add(name);                    
        }
       
           
            result.close();
            System.out.println("Test\tClosed the resultset\n");
            prepare.close();
            System.out.println("Test\tClosed the prepared statement\n");
           

    } catch (SQLException e) {
       
        System.out.println("DB2 SQLException: " + e.getMessage() + "\t");
        while((e = e.getNextException()) != null)
        System.out.println(e.getMessage() + "<BR>");        

    } finally
      {                            
           try{
! LINE 83 !            db2.close();     <<<<<<<<<<<<<<<<<<<<<<    ! LINE 83 !
           }catch (SQLException e)
            {
                System.out.println("Close DB2 SQLException: " + e.getMessage() + "\t");
            }
            System.out.println("Test\tClosed the connection statement\n");      
      }
// end of DB2 Code

/*---------------------------------------------------------------------------------------*/    

// connection to oracle
      Connection oracle = null;
        try
        {
/*driver*/  Class.forName("oracle.jdbc.driver.OracleDriver");
            oracle = DriverManager.getConnection(
/*url*/         "jdbc:oracle:thin:@xxxxxxx:####:xxxxxxx",
/*username*/    "everestuser",
/*password*/    "everest");

        }

            catch(SQLException e)
            {
               System.out.println("Ora Connect String SQLException: " + e.getMessage() + "<BR>");
                    while((e = e.getNextException()) != null)
                         System.out.println(e.getMessage() + "<BR>");
            }
            catch(ClassNotFoundException e){
            System.out.println("ClassNotFoundException: " + e.getMessage() + "\t");}
   
   
    // code to write the customer info to Oracle
    PreparedStatement prepare2     = null;
    ResultSet         result2      = null;  
   
    String name2 = "";
   
     try {

                       
                              for(int i=0; i<returnValue.size(); i++)
                              {  
                                System.out.println(i);
                                name2 = (String) returnValue.get(i);
                                System.out.println("Name : " + name2) ;        
         
                                String custAddQuery =
                                      "insert into admin (id,uniqueid,adminfname) values(admin_sequence.nextval,admin_sequence.nextval,'"+name2+"')";
                                prepare2 = oracle.prepareStatement(custAddQuery, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

                                result2 = prepare2.executeQuery();

                                result2.close();
                                System.out.println("Test\tClosed the resultset\n");
                                prepare2.close();
                                System.out.println("Test\tClosed the prepared statement\n");
                            }
                         
                       
    } catch (SQLException e) {              
       
        System.out.println("Oracle SQLException: " + e.getMessage() + "<BR>");
        while((e = e.getNextException()) != null)
        System.out.println(e.getMessage() + "<BR>");

    } finally
      {
           try{
            oracle.close();
           }catch (SQLException e)
            {
                System.out.println("Close Oracle SQLException: " + e.getMessage() + "<BR>");
            }
            System.out.println("Test\tClosed the connection statement\n");
      }    
 System.exit(0);    
    } // end of main class
} // end of entire class
0
Comment
Question by:gdlp2004
  • 3
  • 3
6 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 12029942
Put that jar in the directory revealed by running the following with the parameter "java.ext.dirs"


public class Props {

        /**
         *  The main program for the Props class
         *
         * @param  args  The command line arguments
         */
        public static void main(String[] args) {
                if (args.length > 0) {
                        for (int i = 0; i < args.length; i++) {
                                System.out.println(System.getProperty(args[0]));
                        }
                }
                else {
                        System.getProperties().list(System.out);
                }
        }
}
0
 

Author Comment

by:gdlp2004
ID: 12030050
CEHJ,

I'll try that and let you know what happens.  

Thanks
0
 

Author Comment

by:gdlp2004
ID: 12030082
CEHJ

I tired running that Props class you gave me and I get a NoSuchClassDef error, but it worked in OptimalJ because OptimalJ has it's own CLASSPATH.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 86

Accepted Solution

by:
CEHJ earned 500 total points
ID: 12030306
set classpath=%classpath%;.

Then compile/run
0
 

Author Comment

by:gdlp2004
ID: 12030392
CEHJ

That seemed to do the trick now it works on my local machine.  Thanks!!!
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 12030407
:-)

You need to mug up on classpath btw:

http://mindprod.com/jgloss/classpath.html
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question