File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
It's not a secret anymore!