?
Solved

ClassNotFoundException: com.ibm.as400.access.AS400JDBCDriver

Posted on 2004-09-10
6
Medium Priority
?
1,848 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 86

Accepted Solution

by:
CEHJ earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
Suggested Courses

719 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