Urgent: connection not made using JDBC Thin Drivers

Thread view:

Ramji - 04 May 2006 06:37 GMT

Dear friends:
following code just prints
Connecting to Oracle... & it doesnt prints ....Connected to oracle
statement.
I've given the code in try catch block but also it doesn't print any
exception
why??

System.out.println("connencting to Oracle....");

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn=
DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION
=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = testserver.com)(PORT
= 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME =
testdb)))","test","test");

System.out.println(".....connencted to Oracle");

I've tried the above code with some changes for the database on the
same machine it works fine. But when I tries it for the db on the other
server it not works.

waiting for reply.....

Reply to this Message

stixwix - 04 May 2006 09:27 GMT

> Dear friends:
> following code just prints
[quoted text clipped - 21 lines]
>
> waiting for reply.....

Could it be simply that the code is throwing an exception? Wrap it in
a try-catch block...

Reply to this Message

stixwix - 04 May 2006 09:50 GMT

> Could it be simply that the code is throwing an exception? Wrap it in
> a try-catch block...

Sorry - i didn't read the question properly!

Reply to this Message

Bjorn Abelli - 04 May 2006 10:12 GMT

"Ramji" wrote...

> following code just prints
> Connecting to Oracle... & it doesnt prints ....Connected to oracle
> statement.
> I've given the code in try catch block but also it doesn't
> print any exception
> why??

What do you do with the exception you catch?

When caught, the exception doesn't "print itself".

If it happens that you catch an exception, but don't do anything with it
(e.g. print out the stacktrace), you'll not see anything.

Could that be the case here?

> System.out.println("connencting to Oracle....");
>
[quoted text clipped - 5 lines]
> = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME =
> testdb)))","test","test");

This seems a bit overkill to supply the whole Net8 configuration file when
working with the thin driver... ;-)

It should suffice with:

DriverManager.getConnection(
"jdbc:oracle:thin:@testserver.com:1521:testdb",
"test", "test");

// Bjorn A

Reply to this Message

Urgent: connection not made using JDBC Thin Drivers

Free Magazines