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

NoNoClassDefFoundError: oracle/security/o3logon/O3LoginClientHelper

The following error occured attempting to connect with Oracle 8.1.7 and driver classes12_g.zip with Java 1.4.2.  Is the driver compatable with 8.1.7 and 1.4.2? What could be the problem?
Loading Database Driver..........
Connecting to Database:RM2000 Development using Oracle i2d2 at port:1531
Connect String:jdbc:oracle:thin:@
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/security/o3logon/O3LoginClientHelper
     at oracle.jdbc.ttc7.O3log.<init>(O3log.java:262)
     at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:249)
     at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:265)
     at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
     at java.sql.DriverManager.getConnection(DriverManager.java:512)
     at java.sql.DriverManager.getConnection(DriverManager.java:171)
     at DatabaseUtil.getDbConnect(DatabaseUtil.java:153)
     at DatabaseUtil.<init>(DatabaseUtil.java:67)
     at DatabaseUtil.main(DatabaseUtil.java:443)
Code Snippet
public int getDbConnect()


   // set class members with configuration

   // information read from the properties file

   host          = System.getProperty("host");

   userName      = System.getProperty("user");

   url           = System.getProperty("url");

   passWord      = System.getProperty("password");

   port          = System.getProperty("port");

   sid           = System.getProperty("sid");

   databaseName  = System.getProperty("databaseName");

   maxSelectRows = System.getProperty("maxSelectRows");

   // Determine which system we are on

   // the MySql driver is for Linux *

   // Oracle this is for Oracle Driver

   String connectString = null;  

   if(url.compareTo("jdbc:mysql//") == 0)

     {// MySql Database

     connectString = url + host + ":"

                                + port + "/" + sid

                                + "?user=" + userName

                                + "&password=" + passWord;



     if(url.compareTo("jdbc:oracle:thin:@") == 0)

       {// Oracle Database


//       connectString =  url + host + ":" + port + ":" + sid+

//                        ", " +  userName +", " + passWord;

       connectString =  url + host + ":" + port + ":" + sid;



     System.out.println("Unsupported URL for this application:" + url);                                



     System.out.println("Connecting to Database:" + databaseName

                         + " " + sid + " at port:"+ port);

     System.out.println("Connect String:" + connectString);

     connection = DriverManager.getConnection(connectString, userName, passWord);

     System.out.println("Connection established for:" + databaseName);



  • 4
2 Solutions
I would guess that either

a. classes12_g.zip has to be unzipped to reveal a contained jar.
b. classes12_g.zip has to be renamed to classes12_g.jar

All jars should be in your lib/ext dirs
Think I've got your answer:

classes12_g.zip is the debug version for use with jdk1.2 and jdk1.3 and to connect to a 9i database.  I would suggest getting hold of classes12.zip from the link below:

Worth renaming it to classes12_g.jar anyway to see what happens. Make sure it's in your classpath or in all jre/lib/ext
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

> Worth renaming it to classes12_g.jar anyway to see what happens

Not necessary.
It certainly would be if he's put it into the extensions directory - it wouldn't work otherwise
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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