Help with jdbc install please. Oracle 817 on XP

From: Roger Redford (dba_222_at_yahoo.com)
Date: 08/10/04

  • Next message: ohaya: "Re: jdbc connection problem" 
    Date: 9 Aug 2004 18:19:16 -0700

    Dear experts,

    I'm very new to jdbc, so please forgive the seemingly
    dumb questions.

    I've got to get java and jdbc working with oracle on
    a machine running Oracle 8.1.7 on XP. I don't have
    any CDs to install with.

    I downloaded and installed the sdk/jdk: j2sdk1.4.2_05
    from:

    http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html

    Since I have the latest SDK, I chose the drivers:

    ojdbc14_g.jar - JDBC classes with debug and trace(1,391,860 bytes)
    Oracle9i 9.2.0.3 JDBC Drivers
    For use with JDK 1.4

    The 8.1.7 drivers were supposed to be for an earlier version of
    the sdk, For use with JDK 1.2, according to oracle's webpage:
    http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc817.html

    Question 1)
    It is correct to sync the JDBC drivers to the SDK?
    As opposed to the version of Oracle?

    ------------------

    The next issue is installing them. I double clicked in Explorer,
    but I got a message:

    Failed to load main-class manifest attribute from <filename.jar>.

    So, I extracted the files with:
    jar -xvf *.jar

    C:\jdbctemp>dir
     Volume in drive C has no label.
     Volume Serial Number is F07E-CFC9

     Directory of C:\jdbctemp

    08/09/2004 09:02 PM <DIR> .
    08/09/2004 09:02 PM <DIR> ..
    08/09/2004 09:02 PM <DIR> META-INF
    08/09/2004 09:02 PM <DIR> oracle
    08/09/2004 08:57 PM 1,391,860 ojdbc14_g.jar
                   1 File(s) 1,391,860 bytes
                   4 Dir(s) 5,890,023,424 bytes free

    Total Files Listed:
            440 File(s) 4,628,334 bytes
            119 Dir(s) 5,889,978,368 bytes free

    So, I've got lots of files here now.

    question 2)
    Are they just supposed to be unzipped like this? Or, do I
    need to do more to install them? Is there a standard or
    default directory to install them in, or anywhere you like?

    Thanks a lot!

  • Next message: ohaya: "Re: jdbc connection problem"

    Relevant Pages

    • Re: Help with jdbc install please. Oracle 817 on XP
      ... > I'm very new to jdbc, ... > a machine running Oracle 8.1.7 on XP. ... > the sdk, For use with JDK 1.2, according to oracle's webpage: ... Full syncing of the JDBC drivers is probably not needed, though it is possible that the ...
      (comp.lang.java.databases)
    • Re: Help with jdbc install please. Oracle 817 on XP
      ... >>I'm very new to jdbc, ... >>a machine running Oracle 8.1.7 on XP. ... >>It is correct to sync the JDBC drivers to the SDK? ... > drivers for JDK 1.4 may require features only available in the later JDK. ...
      (comp.lang.java.databases)
    • Re: Is perl better? :(((
      ... >> That's what the spec says, but I think that closing resultsets is needed for some ... > cause a normal and correct JDBC application to cause severe problems on ... Do you really think Oracle gives a fig about compatibility with specs? ... a fairly large number of other JDBC drivers, including more than one for some DBMSs and ...
      (comp.lang.java.databases)
    • Re: Is perl better? :(((
      ... >> That's what the spec says, but I think that closing resultsets is needed for some ... > cause a normal and correct JDBC application to cause severe problems on ... Do you really think Oracle gives a fig about compatibility with specs? ... a fairly large number of other JDBC drivers, including more than one for some DBMSs and ...
      (comp.lang.java.programmer)
    • Re: Access Oracle Objects via PLSQL from JDBC
      ... In oracle demos I couldn't find a such examples.... ... This example uses a JDBC thin client to call a PLSQL stored ... test.java - this calls the plsql and displays the resultset ... // JDBC Implementation specific connect string ...
      (comp.lang.java.programmer)