This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
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,
jQuery in Action, 2nd edition
subject: jdbc timed out
Similar Threads
JGoodies Binding Framework
Hibernate: save and retrieve immediately
JTable setAutoCreateRowSorter method and getting key from maps