CrazyEngineers V4: Early Access
We are developing the next version of CrazyEngineers. If you wish to receive latest updates and early access, click the link below.
java oracle connectivity
Question asked by keerthi22 in #Databases on May 29, 2010
keerthi22 · May 29, 2010
Rank E2 - BEGINNER
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 Posted in: #Databases
please give full details Posted in: #Databases
sookie · May 31, 2010
Rank C1 - EXPERT
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]](proxy.php?image=http%3A%2F%2Fimg176.imageshack.us%2Fimg176%2F6320%2F61487342.png&hash=a9e0a33e8b5dc21799ed60b92b2d8242)
STEP 4: Output like following will be shown when above program will be run
![[IMG]](proxy.php?image=http%3A%2F%2Fimg707.imageshack.us%2Fimg707%2F4923%2F53943035.png&hash=ecb9d487dd97560bceab76c1655c8778)
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
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
STEP 4: Output like following will be shown when above program will be run
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
