wood burning stoves 2.0*
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc timed out" Watch "jdbc timed out" New topic
Author

jdbc timed out

K Vidhyakar
Ranch Hand

Joined: Jul 10, 2005
Posts: 68
Hi,
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?

Regards,
Vidhyakar K
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1131

Vidhyakar,
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,
Avi.
 
Don't get me started about those stupid light bulbs.
 
subject: jdbc timed out