asked on

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() + " ");
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() + " ");

} 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() + " ");
while((e = e.getNextException()) != null)
System.out.println(e.getMessage() + " ");
}
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() + " ");
while((e = e.getNextException()) != null)
System.out.println(e.getMessage() + " ");

} finally
{
try{
oracle.close();
}catch (SQLException e)
{
System.out.println("Close Oracle SQLException: " + e.getMessage() + " ");
}
System.out.println("Test\tClosed the connection statement\n");
}
System.exit(0);
} // end of main class
} // end of entire class

CEHJ

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);
}
}
}

gdlp2004

ASKER

CEHJ,

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

Thanks

gdlp2004

ASKER

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.

ASKER CERTIFIED SOLUTION

CEHJ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gdlp2004

ASKER

CEHJ

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

CEHJ

:-)

You need to mug up on classpath btw:

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