Solved

Connectivity to Oracle

Posted on 2004-09-06
3
196 Views
Last Modified: 2010-04-01
Hi all, i have expereicen in conecting to IBM Db2, but not oracle,

Can anyone share me the way to connect to oraacle databse.

TQ.

try {

Class.forName("what is the name").newInstance();
Connection conn = DriverManager.getConnection("what is the path");

}

thank you
0
Comment
Question by:spiderman19
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 92

Accepted Solution

by:
objects earned 250 total points
ID: 11987958
0
 
LVL 11

Expert Comment

by:sompol_kiatkamolchai
ID: 11987975
Here is another example

>>Class.forName("what is the name").newInstance();
oracle.jdbc.driver.OracleDriver
>>Connection conn = DriverManager.getConnection("what is the path");
jdbc:oracle:thin:@(description=(address=(host=database_ip)(protocol=tcp)(port=1521))(connect_data=(sid=database_instance_name)))

But make sure you have OracleDriver include to classpath.
0
 
LVL 92

Expert Comment

by:objects
ID: 11992783
thanks mate :)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is a lot to be said for protecting yourself and your accounts with 2 factor authentication.  I found to my own chagrin, that there is a big downside as well.
In this blog we highlight approaches to managed security as a service.  We also look into ConnectWise’s value in aiding MSPs’ security management and indicate why critical alerting is a necessary integration.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question