Professional Web Applications Themes

newbie to java oracle - Oracle Server

I need to make a jdbc connection to oracle, I was wondering what are the initial steps. I have the oracle 9 client installed, I have yet to set any classpaths. Should I have to install the jdbc drivers? Also will I have to do any thing different to connect to oracle through a servlet. I assume, all I have to do is set the classpath to the jdbc drivers I read the docs, they are not leading me any where....

  1. #1

    Default newbie to java oracle

    I need to make a jdbc connection to oracle, I was wondering what are
    the initial steps. I have the oracle 9 client installed, I have yet
    to set any classpaths. Should I have to install the jdbc drivers?
    Also will I have to do any thing different to connect to oracle
    through a servlet.

    I assume, all I have to do is set the classpath to the jdbc drivers

    I read the docs, they are not leading me any where.
    bigbinc Guest

  2. #2

    Default Re: newbie to java oracle

    bigbinc wrote:
     
    When you say you "read the docs" exactly what did you read? And where?

    --
    Daniel Morgan
    http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
    http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
    damorganx.washington.edu
    (replace 'x' with a 'u' to reply)

    Daniel Guest

  3. #3

    Default Re: newbie to java oracle

    Your client install should have included the JDBC drivers. To verify,
    make sure that they are in %ORACLE_HOME%\jdbc\lib. Then, add the
    appropriate driver(s) to your CLASSPATH environment variable. There
    really isn't any difference if this is a servlet or not. What makes big
    difference is if this is an applet that uses the thin drivers or can you
    use the thick drivers.

    HTH,
    Brian

    bigbinc wrote: 

    --
    ================================================== =================

    Brian Peasland
    peasland.com

    Remove the "remove_spam." from the email address to email me.


    "I can give it to you cheap, quick, and good. Now pick two out of
    the three"
    Brian Guest

  4. #4

    Default Re: newbie to java oracle

    com (bigbinc) wrote in message news:<google.com>... 

    Oracle's JDBC Developer's Guide and Reference and Java Developer's
    Guide should have plenty of information to get going on.
    At $ORACLE_HOME/jdbc/demo is a demo.tar. Expand this and check out
    JdbcCheckup.java under the generic folder. If you look at the included
    Makefile, it will show you how to set up the classpath. Basically,
    javac -classpath $ORACLE_HOME/jdbc/lib/classes12.jar:.
    JdbcCheckup.java and then java -classpath
    $ORACLE_HOME/jdbc/lib/classes12.jar:. JdbcCheckupup (for Java 1.2).
    Joe Guest

  5. #5

    Default Re: newbie to java oracle

    com (Joe) wrote in message news:<google.com>... 
    >
    > Oracle's JDBC Developer's Guide and Reference and Java Developer's
    > Guide should have plenty of information to get going on.
    > At $ORACLE_HOME/jdbc/demo is a demo.tar. Expand this and check out
    > JdbcCheckup.java under the generic folder. If you look at the included
    > Makefile, it will show you how to set up the classpath. Basically,
    > javac -classpath $ORACLE_HOME/jdbc/lib/classes12.jar:.
    > JdbcCheckup.java and then java -classpath
    > $ORACLE_HOME/jdbc/lib/classes12.jar:. JdbcCheckupup (for Java 1.2).[/ref]

    That is why I love java, I knew the answer, but sometimes you have to ask.
    bigbinc Guest

Similar Threads

  1. Oracle Ultrasearch Java API
    By chris8oz in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: June 2nd, 04:19 AM
  2. Replies: 4
    Last Post: October 28th, 10:53 PM
  3. Replies: 7
    Last Post: October 21st, 12:44 PM
  4. Replies: 1
    Last Post: January 13th, 10:13 PM
  5. Replies: 15
    Last Post: January 8th, 09:35 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139