Re: Serializing PreparedStatement, or: how do create a database history?
- From: Vova Reznik <byRequest@xxxxxxxxxxxx>
- Date: Fri, 02 Sep 2005 18:38:31 GMT
Chris wrote:
Hi,If you don't have Connection - how can you get PreparedStatement?
I want to do the following and I hope you can give me hints on how to do this:
We have a Database (MS SQL over JDBC) which is not always necessary accessible. But this fact has to be transparent for the application which uses the db. If the db is not available, all updates/inserts and deletes must be saved (persistent on the harddisk!) and later be executed on the database (SQL select is not needed).
I first thought about serializing the PreparedStatement, but first of
all it is not serializable, second, all status about the database is lost.
Simply saving the SQL string does not help, as there can be binary objects in the query which are set using the PerparedStatement.
What objects - just parameters?
Serialize parameters and SQL string and reuse it later.
Kind of:
class SavedStatement{
private String sql;
private Object[]params;
....
}
As this is an extension to an existing program, and PreparedStatement is used there all over, building something around the PreparedStatement seems like the only solution.
If you have only the slightest suggestion on how this can be done, thanks a lot!
Regards, Chris
.
- Prev by Date: Re: how to display / get that query ?
- Next by Date: Re: Serializing PreparedStatement, or: how do create a database history?
- Previous by thread: how to display / get that query ?
- Next by thread: Re: Serializing PreparedStatement, or: how do create a database history?
- Index(es):
Relevant Pages
|
|
