JDBC connection problem:

The name of the database is HR.
The server is localhost
The default port is 1521 (or so I'm told).
The user name is SYSTEM.
The password is wgb1454.
The driver classname is: oracle.jdbc.OracleDriver
The connection URL is: jdbcracle:thin:@localhost:1521:HR


The error message is:
"Error while trying to login to datbase;
Listener refused the connection with the
following error:
ORA-12505, TNS:listener does not currently
know of SID given in connect descriptor.
The connection descriptor used by the client
was: localhost:1521:HR"

What is TNS:listener? Where is it located?
What is SID? Where is it defined?
How are they related and how can you make them recognize each other
in Win XP Pro?

The Oracle product is Oracle 10g Express. The database I'm trying to
hit is
the default demo database that comes with the product.

The connection is NOT written in Java, it's created through a GUI in
Eclipse 3.2.

Any help would be GREATLY appreciated!

On Nov 10, 2:24 pm, "ddog" <wgblack... (AT) yahoo (DOT) com> wrote:
ddog,
If this is Oracle XE than your connection string should be:
jdbcracle:thin:@localhost:1521:XE
assuming this is standard installation.
where XE is an instance/service name.
In Oracle you connect to the instance, not "database" (IN MS terms).
Then use schema name like HR to make queries
Example:
If connected as system (You should not do this)
select * from HR.<table name> ...
You should read "Oracle® Database Express Edition Getting Started
Guide"
Oracle is different from the database you are familiar with.

HTH
Thomas