Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Maximum PreparedStatements per connection

 
Paul Doherty
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Could anyone tell me is there a maximum number of prepared statements that can be created per connection?
Cant seem to find any info on this.
Regards,
Paul.
 
sanjay yermalkar
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
yes, there is a limit. I know for oracle it's equal to maximum open cursors allowed.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
depends on the jdbc driver you are using. The jdbc dbc bridge limits you to one Statement per connection while Oracle thin drivers allow many. So the question should be, how many Statements can be used concurrently on a single connection for your driver?(which driver are you using?)
Jamie
[This message has been edited by Jamie Robertson (edited November 14, 2001).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic