Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reusing PreparedStatement as Statement

 
Justin Chu
Ranch Hand
Posts: 209
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
With regular statement we can easily reuse the same Statement object to execute a series of unique queries/updates.



It is apparently not the case for PreparedStatement, as the creation requires a SQL String as argument, and there's no API to reset a PreparedStatement instance to a different SQL template.

But, is it possible to keep reusing PreparedStatement as if it as a Statement?

 
Paul Clapham
Sheriff
Pie
Posts: 20758
30
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It seems to me you should be able to write a little test program to see if that code does what you expect it to do. Why not try that?
 
Justin Chu
Ranch Hand
Posts: 209
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
True. Thanks. It doesn't work. The PreparedStatement cannot be reused as general Statement.

In oracle the following error is caused on subsequent execute:
ORA-01006: bind variable does not exist
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic