• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Tim Cooke
  • Bear Bibeault
  • paul wheaton
Saloon Keepers:
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Mikalai Zaikin
  • Piet Souris

Performace of Updatable resultset

Posts: 3
Hibernate Eclipse IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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)....
The only cure for that is hours of television radiation. And this tiny ad:
Low Tech Laboratory
    Bookmark Topic Watch Topic
  • New Topic