File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes jdbc timed out Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
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: 1121

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
Similar Threads
JGoodies Binding Framework
Hibernate: save and retrieve immediately
JTable setAutoCreateRowSorter method and getting key from maps