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 database can not be accessed -- Please help ! 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 "database can not be accessed -- Please help !" Watch "database can not be accessed -- Please help !" New topic

database can not be accessed -- Please help !

lily zou
Ranch Hand

Joined: Jan 15, 2002
Posts: 50
Hi, there
I encountered a quite strang problem with my table in oracle. I have a process to write to a database all the time. And also I have a cron process to read from this table once a day at 00:11:00. But every midnight around 00:01:40, first process starts to throw me exception saying can't update the table and repeats this message untill cron job starts. Therefore I lost all the data sent in between. After that every thing is normal but next day the same thing happens again.
I am wondering what is the most likely cause to block a table to be accessed or updated ?
Any advice is highly appreciated .
Peter den Haan
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
Surely the exception that's being thrown has more information? In any case, I would suspect some type of overnight database maintenance -- the database taken offline or even rebooted to do a backup or somesuch. Talk to your DBA.
- Peter
I agree. Here's the link:
subject: database can not be accessed -- Please help !
It's not a secret anymore!