Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Performace of Updatable resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Performace of Updatable resultset" Watch "Performace of Updatable resultset" New topic
Author

Performace of Updatable resultset

manvendra singh
Greenhorn

Joined: Feb 05, 2011
Posts: 3

Hi All,
I had a requirement to morph CreditCard information present in a legacy Database for last 14 years.

I tried to do it in java and have written following code for that.
based upon updatable resultset.
But its performance is very poor.



Class DB Access looks like



Can somebody please tell some optimization in it without writing a stored procedure.......

And even above rs.updateString() method throws an obvious exception Internal (Error: Unable to construct a Datum from the specified input) when operating with clob.
So can anyone please tell that how to create a clob object to pass to rs.updateClob(1,txtClob)....
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Performace of Updatable resultset
 
Similar Threads
I hot error time of file uploading in servlet/jsp
CachedRowSet.acceptChanges();
How to update clob field in oracle
Problem with Oracle Query
how to use large objects,images blob