The moose likes JDBC and Relational Databases and the fly likes Execution freezes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Execution freezes" Watch "Execution freezes" New topic

Execution freezes

Lubosh Bazant

Joined: Jan 15, 2002
Posts: 14
I am running jdk1.3 and I am trying to establish a JDBC connection with a Oracle7.3 database sitting on a remote machine. I have my URL and User/password set up, however everytime I run the program the there is no output. The program does not go beyond the DriverManager.getConnection() line. Not even an exception is thrown. It just freezes. Also I am using a thin driver to establish the connection.
I was wondering if this is a common behaviour in some error cases and how can it be solved.
Nitin Shivaram
Ranch Hand

Joined: Jan 17, 2001
Posts: 71
Try printing the warnings too, use Connection.getWarnings in a loop to see if something is wrong.
Are you able to connect to the database through a sqlclient?(say sqlplus).

Nitin S<br />Sun Certified Java Programmer for the Java 2 platform.<br />Tekmetrics Certified Java Programmer For the Java 2 Platform.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

I've had a similar problem in Oracle where an operation was performed in SqlPlus or similar and was not committed.
Suggested solution: Um, commit all transactions in database clients?
I agree. Here's the link:
subject: Execution freezes
jQuery in Action, 3rd edition