• 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
Posts: 21975
36
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
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!