Re: Serializing PreparedStatement, or: how do create a database history?
- From: yakovfain@xxxxxxxxx
- Date: 2 Sep 2005 12:48:06 -0700
Look at the disconnected JDBC RowSet:
http://today.java.net/pub/a/today/2004/10/15/jdbcRowsets.html
Yakov Fain
http://www.weekendwithexperts.com
Chris wrote:
> Hi,
> 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.
> 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: Serializing PreparedStatement, or: how do create a database history?
- Next by Date: Re: Serializing PreparedStatement, or: how do create a database history?
- Previous by thread: Re: Serializing PreparedStatement, or: how do create a database history?
- Next by thread: Re: Serializing PreparedStatement, or: how do create a database history?
- Index(es):
Relevant Pages
|
