Results 1 to 4 of 4

Thread: Oracle and JDBC

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

    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?


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


    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 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


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


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

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


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

    Thumbs up 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 file in the web-inf/lib folder of ma web application.

    and it worked fine.

    Thanx n Regards

Similar Threads

  1. Replies: 6
    Last Post: 02-19-2010, 02:57 PM
  2. Replies: 0
    Last Post: 03-21-2008, 02:13 PM
  3. Replies: 1
    Last Post: 03-14-2008, 03:51 PM
  4. Using JDBC to connect to ORACLE database
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-10-2008, 12:27 PM
  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