This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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

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: 1138

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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: jdbc timed out
It's not a secret anymore!