aspose file tools*
The moose likes JDBC and the fly likes Unable to connect using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Unable to connect using JDBC" Watch "Unable to connect using JDBC" New topic
Author

Unable to connect using JDBC

Ashwin Sridhar
Ranch Hand

Joined: Jul 09, 2011
Posts: 272

Hi ,

I am connecting to Oracle 11g from JDBC, but I get TimedOut Exception.



Below is my Connection String



Below is my TNS entries,



But I am able to establish a connection from Sql*Plus.

Any thoughts on this exception.


Ashwin Sridhar
SCJP | SCWCD | OCA
Sai Rao
Greenhorn

Joined: Mar 23, 2007
Posts: 4

Hello Ashwin,
Is this a local database? If not can you please try entering the DB URL instead of localhost in the connection parms, or the IP address of the database
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <IP of the database>)(PORT = 1599))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Test)
)


Connection conn = DriverManager.getConnection("jdbcracle:thin:@<IP/URL of database>:1599:TEST",USERNAME,PASSWORD);
Ashwin Sridhar
Ranch Hand

Joined: Jul 09, 2011
Posts: 272

Hi Sai,

The DB Url also throws me the same exception. I tried to do a tnsping, I am able to retreive the some bytes. I am planning to re-install Oracle.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to connect using JDBC