Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Oracle Express DB connection URL in Eclipse 3.2 via Database Profile - how?

Reply
Thread Tools

Oracle Express DB connection URL in Eclipse 3.2 via Database Profile - how?

 
 
ddog
Guest
Posts: n/a
 
      11-10-2006
Hi,
I'm trying to connect to a newly downloaded and installed Oracle 10g
Express database via MyEclipse. I need to define a connection URL. The
name of the database I want to connect
to is 'HR' (the sample that comes with the installation). The username
is 'SYSTEM' and the password is 'wgb1454'. I'm assuming the driver is a
'thin' driver (see the URL below). The driver's
package is oracle.jdbc.OracleDriver found in the ojdbc14.jar.

jdbcracle:thin@//localhost:1521:HR,SYSTEM,wgb1454

I'm also unable to connect via port 8080. The database is up and
running. Any help would be greatly appreciated!

 
Reply With Quote
 
 
 
 
Manish Pandit
Guest
Posts: n/a
 
      11-10-2006
Not sure why you are trying to connect via port 8080. Assuming you
installed oracle with defaults, the port will be 1521. Try this:

DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

Connection conn = DriverManager.getConnection
("jdbcracle:thin:@localhost:1521:hr", "system",
"wgb1454");

System.out.println("Connected ? " + (conn != null ));

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Database Database Database scott93727@gmail.com Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase scott93727@gmail.com Computer Information 0 09-26-2012 09:40 AM
Building DBD::Oracle with the new Oracle Express product. ethandbrown@gmail.com Perl Misc 0 11-07-2005 08:19 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
how to load a picture to an oracle database with theLoad a pictureto Oracle with DBI perl module Vincent Le-Texier Perl Misc 1 12-03-2004 03:29 PM



Advertisments