Solved

ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver

Posted on 2004-09-10
6
1,632 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
triangle challenge 4 79
array220 challenge 8 48
Eclipse IDE - Cannot copy/paste from console output 8 71
unix in java example 9 43
For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
The viewer will learn how to implement Singleton Design Pattern in Java.

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now