Results 1 to 4 of 4

Thread: Oracle and JDBC

  1. #1
    Eric is offline Senior Member
    Join Date
    Jun 2007
    Posts
    111
    Rep Power
    0

    Default Oracle and JDBC

    I'm trying to connect to an Oracle DB but have no idea where to start. I've been searching through multitudes of documentation without any luck.

    Mainly it doesn't tell you what driver you need in specific, then it goes on about which jar you need but again, without being specific.

    In fact, I haven't found any documents which give you a manual on how to do it properly, most of them just say "use the JDBC thin client" and they leave it at that.

    I've got the thin client and included it in my project in Eclipse, I still can't get anything to work. Do I need to install the client tools?

    Thanks
    Eric

  2. #2
    Marcus is offline Member
    Join Date
    Jun 2007
    Posts
    92
    Rep Power
    0

    Default

    JDBC thin driver is the one I have used to connect to Oracle in the past.

    Depending on your requirements, you can either
    • Add the JDBC Driver to your class path
    • Uncompress the contents of the jar file in your project


    Personally, I think uncompressing the contents into your project is the way to go...as that will allow portability of your application as long as the Database is accessible from other machines.

    If you are building a web app, you should include your jar file in WEB-INF/lib

    If you want to configure eclipes to connect to your database, here is an example showing a connection to MySQL

    Greetings
    Marcus:cool:

  3. #3
    Daniel is offline Member
    Join Date
    Jun 2007
    Posts
    91
    Rep Power
    0

    Default

    You have to use classes12.jar which is the jdbc driver.

    Also you can use hibernate to connect to the Oracle database.

    Greetings.
    Daniel:o

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

    Thumbs up Thanx....it worked for me..........

    Thanx a lot it worked for me.

    i was also getting the oracle connection error, as i was trying to connect my oracle database thru ma jsp application.

    i have kept the classses12.zip file in the web-inf/lib folder of ma web application.

    and it worked fine.

    Thanx n Regards
    Sam

Similar Threads

  1. Replies: 6
    Last Post: 02-19-2010, 01:57 PM
  2. Replies: 0
    Last Post: 03-21-2008, 01:13 PM
  3. Replies: 1
    Last Post: 03-14-2008, 02:51 PM
  4. Using JDBC to connect to ORACLE database
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-10-2008, 11:27 AM
  5. Jdbc Driver For Oracle
    By Swamipsn in forum New To Java
    Replies: 0
    Last Post: 08-14-2007, 04:31 AM

Posting Permissions

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