• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

'Oracle 11g Express Edition' and Java and Eclipse

 
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I just learned a few days ago what I had to do to get Java to work with MySQL when I am using ECLIPSE.
But now I want to try out 'Oracle 11g Express Edition' as the company I will be joining in the near future is using Oracle and PL/SQL.
They use Java too but note sure if their Java code ever uses the PL/SQL.

That said, while I am learning Java I might as well be using Oracle rather than MySQL.

So I am hoping the process is the same. Down load a Java JAR file for Oracle and place it in the Java Build Path libraries. Any one know of any issue?
Eclipse-Java-Build-Path-Library.jpg
[Thumbnail for Eclipse-Java-Build-Path-Library.jpg]
 
Java Cowboy
Posts: 16084
88
Android Scala IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
From the Java viewpoint, it will be pretty much the same.

Java's database access API, JDBC, is database-independent, and it uses drivers to connect to specific brands of databases. So if you use MySQL, you need the JDBC driver for MySQL, and for Oracle, you use the JDBC driver for Oracle. Oracle has a page where you can download JDBC drivers.

From the programming side, you shouldn't have to modify your Java code at all to work with a different brand of database.
 
Bartender
Posts: 2407
36
Scala Python Oracle Postgres Database Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If you're working with Oracle, you should definitely download SQL Developer. This is a powerful IDE for working with the Oracle database, with good support for SQL, PL/SQL, data modelling etc. It's free to download and use, and is much better than any generic Eclipse database plugins I've ever used. Even if you will be working mainly with Java, SQL Developer gives you excellent tools for exploring your database or trying out your SQL to make sure it works before you put it into your Java code, for example.
 
Rod Hittle
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Well I went to Oracle and installed 'Oracle Database Express Edition 11g Release 2(11.1)
Then I went download the JDBC driver(s) as Jesper suggested.
Well that stumped me as I have no idea which of these many JAR files I need.
Keep in mind this is just for learning and I am using Eclipse to run my JAVA classes.


Oracle-Database-11g-JDBC-Drivers.jpg
[Thumbnail for Oracle-Database-11g-JDBC-Drivers.jpg]
 
Ranch Hand
Posts: 624
9
BSD Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
ojdbc6.jar will do
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic