File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "database can not be accessed -- Please help !" Watch "database can not be accessed -- Please help !" New topic
Author

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 .
Lily
Peter den Haan
author
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: http://aspose.com/file-tools
 
subject: database can not be accessed -- Please help !
 
Similar Threads
Map 2 CMP Entity Beans to 1 table?
When does the calendar change?
Stupid people in power
Log files: Websphere
Joda DateTime