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 jdbc timed out Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc timed out" Watch "jdbc timed out" New topic

jdbc timed out

K Vidhyakar
Ranch Hand

Joined: Jul 10, 2005
Posts: 68
I am using jdbc to connect to oracle.
Its working fine when i fetch the record on a table. But its getting timedout when i fetch data from view.

Actually the tables used in the view is getting bulk update.
So is it possible to get huge delay while fetching record on view?

Vidhyakar K
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

You asked:

is it possible to get huge delay while fetching record on view?

A database view is the result of a [SQL] query.
It can take the database several hours before returning the results of a query.
So the answer to your question is yes, it is possible to get a huge delay while fetching a record on a view.

Good Luck,
I agree. Here's the link:
subject: jdbc timed out
It's not a secret anymore!