Maximum PreparedStatements per connection

[Paul Doherty]

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]

yes, there is a limit. I know for oracle it's equal to maximum open cursors allowed.

[Jamie Robertson]

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