Results 1 to 7 of 7
  1. #1
    ljustiniano is offline Member
    Join Date
    Aug 2007
    Posts
    4
    Rep Power
    0

    Default java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

    Hi everybody

    I'm new in java Platform and i have problems trying to load a JDBC driver using Class.forname, but JVM can not find it. I configured classpath enviroment path pointig to libraries

    OS: Windows XP
    Java Version 1.6
    IDE Eclipse 3.2.2

    classpath = .;C:\Program Files\Altova\xmlspy\XMLSpyInterface.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;D:\oracle\ora92\jdbc\lib\ classes12.zip


    java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at bpos.Db.Conectar(Db.java:20)
    at bpos.Process.main(Process.java:19)


    Can anybody help me about this? It will appreciate.

    Leo

  2. #2
    netrista is offline Member
    Join Date
    Aug 2007
    Posts
    4
    Rep Power
    0

    Default

    Hello Leo,

    Try putting the full path to the Oracle classes12.zip file at the front of the CLASSPATH. Also remove the extra space between the \ and classes12.zip.

    Before you test with an app, ensure the driver returns version information by running this command on the command line:

    java oracle.jdbc.driver.OracleDriver

    If that command does not work, you still have environment problems and need to revisit before you test with the app.

    Best regards,
    Netrista Khatam
    Technical Services Manager
    OpenLink Product Support

  3. #3
    ljustiniano is offline Member
    Join Date
    Aug 2007
    Posts
    4
    Rep Power
    0

    Default it doesn't work yet...

    Hi Netrista.. thank you for your help.. I checked my enviroment variables and i didn't find problems. I think that was copy paste mistake. I put first the oracle driver library reference into the classpath enviroment variable

    C:\>echo %classpath%
    .;D:\oracle\ora92\jdbc\lib\classes12.zip;C:\Progra m Files\Altova\xmlspy\XMLSpyInterface.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;c:\program files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar

    I performed your suggested command and i couldn't get the version of each class i'm trying to use

    C:\>java oracle.jdbc.driver.OracleDriver
    Exception in thread "main" java.lang.NoSuchMethodError: main

    C:\>java com.microsoft.jdbc.sqlserver.SQLServerDriver
    null

    any other thing that it could be used? thanks!

    Leo

  4. #4
    netrista is offline Member
    Join Date
    Aug 2007
    Posts
    4
    Rep Power
    0

    Default

    Hello Leo,

    This is what I would recommend:

    1. Verify that the following path is correct:

    D:\oracle\ora92\jdbc\lib\classes12.zip

    2. Insure no permissions issues exist on that file or directory structure, which is unlikely since it is Windows.

    3. Run this command to get your java version:

    java -version

    4. Insure that the java version of the JVM/JDK that you have installed on Windows is compatible with the requirements of the driver.

    Can you state whether or not you can use the other JDBC drivers to get a connection using the application, even though they error on the commandline with DOS. I've seen that before, so it's important to ascertain whether the app connectivity issue is specific to Oracle or generalized to all JDBC connections.


    Best regards,
    Netrista Khatam
    Technical Services Manager
    OpenLink Product Support

  5. #5
    ljustiniano is offline Member
    Join Date
    Aug 2007
    Posts
    4
    Rep Power
    0

    Default Fixed!

    Thank you very much.

    The classpath was correct. I proved on command line and it worked correctly. So i have to change my approach looking for into my IDE project definition parameters. I' m using Eclipse and i found that i have to define a classpath for the project.

    Ups! I'm new in Eclipse too.. and i forgot mention it. Your description of the solution helped me to find the final solution. Thank you!

    Leo

  6. #6
    adkan11 is offline Member
    Join Date
    Mar 2009
    Posts
    1
    Rep Power
    0

    Default

    Quote Originally Posted by netrista View Post
    Hello Leo,

    Try putting the full path to the Oracle classes12.zip file at the front of the CLASSPATH. Also remove the extra space between the \ and classes12.zip.

    Before you test with an app, ensure the driver returns version information by running this command on the command line:

    java oracle.jdbc.driver.OracleDriver

    If that command does not work, you still have environment problems and need to revisit before you test with the app.

    Best regards,
    Netrista Khatam
    Technical Services Manager
    OpenLink Product Support
    Hi netrista,

    I'm using oracle 10g express edition. And using myeclipse 7.0
    Right now the same error is being thrown here. Can you tel somthng abt it.??? I mean What should i do abt it..???

    Waiting for reply... Will be appreciable...
    Thnx.

  7. #7
    j2me64's Avatar
    j2me64 is offline Senior Member
    Join Date
    Sep 2009
    Location
    Zurich, Switzerland
    Posts
    962
    Rep Power
    6

    Default

    Quote Originally Posted by adkan11 View Post
    Waiting for reply... Will be appreciable...
    Thnx.

    I had the same problem in eclipse with mysql-driver. But then I tried this: right-click the project that need the db-driver and select "Run As" then "Run Configuration". in the classpath-tab select "Add External JARs" and then navigate to the folder where the db-jar file is and select it. compile and let me know ... good luck.

Similar Threads

  1. Replies: 4
    Last Post: 03-31-2010, 01:08 PM
  2. Replies: 0
    Last Post: 03-21-2008, 02:13 PM
  3. Replies: 1
    Last Post: 03-14-2008, 03:51 PM
  4. Jdbc Driver For Oracle
    By Swamipsn in forum New To Java
    Replies: 0
    Last Post: 08-14-2007, 05:31 AM
  5. Replies: 1
    Last Post: 06-27-2007, 06:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •