dbTalk Databases Forums  

JDBC DB Connection with Eclipse 3.2 and Oracle 10g Express

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss JDBC DB Connection with Eclipse 3.2 and Oracle 10g Express in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dshitzu
 
Posts: n/a

Default JDBC DB Connection with Eclipse 3.2 and Oracle 10g Express - 11-10-2006 , 12:31 PM






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
  #2  
Old   
sybrandb
 
Posts: n/a

Default Re: JDBC DB Connection with Eclipse 3.2 and Oracle 10g Express - 11-10-2006 , 03:15 PM







dshitzu wrote:
Quote:
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!
HR is the *schema* name, not something identifying the database.
For the thin driver you need the *SID* of the database.
The SID of any XE database is XE.
All of which of course is documented in the XE documentation up at
http://otn.oracle.com, including a 'Getting Started' Manual, which you
obviously didn't bother to read.
The username is obviously als NOT SYSTEM, but HR.

--
Sybrand Bakker
Senior Oracle DBA



Reply With Quote
Reply




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.