Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.

View Poll Results: error saying "Type named oracle.jdbc.driver.OracleDriver is not defined."

Voters
0. You may not vote on this poll
  • Oracle Class Missing? Where do I fine these classes.

    0 0%
  • Java SQLJ Oracle error

    0 0%
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Dec 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post Error "Type named oracle.jdbc.driver.OracleDriver is not defined."

    I have installed oracle on my pc(win2000 os) with version below:

    Personal Oracle8i Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production



    Here is few lines from file TNSNAMES.ORA

    TNSNAMES.ORA Configuration File:E:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora
    Generated by Oracle Enterprise Manager V2
    Date..........: Sat May 11 17:22:02 CDT 2002

    LINK2HR2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = pria)(PORT = 1521))
    )
    (CONNECT_DATA = (SERVICE_NAME = link2hr2))
    )




    I have installed VisualAge for Java 4.0 with JDK 1.2.2 that is offered for free by IBM.

    I did the following sqlj setup in VAJ workbench:

    1. workbench--->Tools--->SQLJ--->Properties

    Perform online semantics checking is checked
    JDBC Driver: oracle.jdbc.driver.OracleDriver
    Default URL: jdbcracle:thin:@pria:1521:link2hr2

    Default URL: jdbcracle:thin:@pria:1521:link2hr2
    User: hrdb
    Password: ????????

    2. Window--->Options--->Resources. I have the following in Workspace classpath I typed the following:
    "E:\oracle\ora81\jdbc\lib\classes12.zip;" w/o quotes.

    3. I have many Projects in my workspace along with "Java class libraries", "SQLJ Runtime Libraries".


    My Problem is:

    When I try to load and register JDBC driver with statement below:

    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

    I get compile error saying "Type named oracle.jdbc.driver.OracleDriver is not defined."

    My questions are:

    Do I need to have any "oracle" Projects in my workspace. If so Where do I get it from??.

    I think I am missing some oracle classes.

    P L E A S E H E L P !!
    Last edited by mokhter; 12-21-2002 at 08:53 PM.

  • #2
    Senior Coder Mhtml's Avatar
    Join Date
    Jun 2002
    Location
    Sydney, Australia
    Posts
    3,531
    Thanks
    0
    Thanked 1 Time in 1 Post
    Why did you post a poll?
    Omnis mico antequam dominus Spookster!


  •  

    Posting Permissions

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