View Feed
group-icon
Java Developers
Community of Java Developers: Get Java Programming Help from fellow Java Developers across the world.
648 Members
Join this group to post and comment.
keerthi22
keerthi22 • May 29, 2010

java oracle connectivity

hi friends did anybody know java with oracle connectivity.. please help.. did i need to change any modification in control panel for java oracle connectivity like other connectivity
please give full details
sookie
sookie • May 31, 2010
Hi keerthi22,

As far as I know, you need to import ojdbc14.jar into your java application and then using JDBC, you can directly connect to Oracle Database.

STEP 1: Download ojdbc14.jar file from Oracle JDBC Drivers release 10.2.0.1.0 Downloads

STEP 2: Add ojdbc14.jar to the build path of you project.

STEP 3: Create a Java Program JDBCConnectDemo.java like following

[​IMG]

STEP 4: Output like following will be shown when above program will be run

[​IMG]

In above program,
URL= Connection String including HOSTNAME, PORT NO, SID.
DRIVER = Name of the driver used.

Note: In above case OracleDriver is used. You can connect to any other driver also in similar way.
Username = username used to connect to the database
Password = password used to connect to the database

Share this content on your social channels -