JDBC DB Connection with Eclipse 3.2 and Oracle 10g Express - 11-10-2006 , 12:31 PM
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.
I'm also unable to connect via port 8080. The database is up and
running. Any help would be greatly appreciated!
Re: JDBC DB Connection with Eclipse 3.2 and Oracle 10g Express - 11-10-2006 , 03:15 PM
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.
Senior Oracle DBA