• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1992
  • Last Modified:

ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver

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
gdlp2004
Asked:
gdlp2004
  • 3
  • 3
1 Solution
 
CEHJCommented:
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
 
gdlp2004Author Commented:
CEHJ,

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

Thanks
0
 
gdlp2004Author Commented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
CEHJCommented:
set classpath=%classpath%;.

Then compile/run
0
 
gdlp2004Author Commented:
CEHJ

That seemed to do the trick now it works on my local machine.  Thanks!!!
0
 
CEHJCommented:
:-)

You need to mug up on classpath btw:

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now