how to know the url is whether correct or not

[bhagya raavi]

i am using
Connection con = DriverManager.getConnection("jdbcracle:thin:@localhost:1521:xe", "scott", "tiger");
in this jdbc--->connection
oracle--->database name
thin--->user
localhost:1521:xe--->url
in this how to know the user and url is correct

[Akhilesh Trivedi]

Originally posted by bhagya raavi:
i am using
Connection con = DriverManager.getConnection("jdbcracle:thin:@localhost:1521:xe", "scott", "tiger");
in this jdbc--->connection
oracle--->database name
thin--->user
localhost:1521:xe--->url
in this how to know the user and url is correct

thin--->driver
scott-->user
tiger-->password

[Rajkamal Pillai]

Hi,

From what I know :-

"jdbcracle:thin:@localhost:1521:xe", "scott", "tiger"

'jdbcracle:thin' specifies the Oracle JDBC thin driver.
'localhost:1521:xe' specifies the host and port number and the database name.
'scott' specifies the user.
'tiger' specifies the password.

And all are welcome to correct in case I made any mistake.

The connection wont be made if the URL Mentioned is not correct. I am not sure whether the type of error in that case can be ascertained from what is returned though.

Cheers,
Raj.
[ August 26, 2008: Message edited by: Raj Kamal ]