Discuss How to connect Oracle with Java program in the Oracle Development forum on Dev Shed. How to connect Oracle with Java program Oracle Development forum discussing administration, Oracle queries, and other Oracle-related topics. Oracle is known as one of the most robust multi-platform relational databases available.
Posts: 95
Time spent in forums: 16 h 10 m 28 sec
Reputation Power: 5
How to connect Oracle with Java program
HI,
I am asking a very basic thing. So please help me.
I have installed Oracle 9i on my system. I want to access the Oracle Database ( create table, access tabeles etc.) from my java program using JDBC API.
I don't know what to give in DriverManager.getConnection.
DriverManager.getConnection("what here ?" , "username","pwd")
Do we need to give System IP address or anything else.
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by asty
I have installed Oracle 9i on my system. I want to access the Oracle Database ( create table, access tabeles etc.) from my java program using JDBC API.
I don't know what to give in DriverManager.getConnection.
DriverManager.getConnection("what here ?" , "username","pwd")
Asty
The value of "what here" (called URL) depends on the type of JDBC driver you use, "Thin" or "OCI" - both ship with Oracle 9i.
OCI:
jdbc:oracle:oci8:@<db_name from init.ora OR tnsnames.ora entry>
example: jdbc:oracle:oci8:@globaldb
SEE:
- Attached java example (connects to database and displays some database metadata) to confirm Db connectivity via JDBC (rename from .txt to .java). Note to run this example, the appropriate Oracle JDBC driver needs to be in the CLASSPATH. I can run this successfully using the 'classes12.jar' from the 'jdbc/lib' folder under the 9i installation.
- 'jdbc/demo' folder under 9i installation for lots of Oracle/JDBC examples.
- Google with the search values 'oracle jdbc'.
Dev Shed Forums Sponsor:
November 7th, 2004, 02:35 AM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
