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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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!