• 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).]
 
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!