aspose file tools
The moose likes JDBC and the fly likes Maximum PreparedStatements per connection Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Maximum PreparedStatements per connection" Watch "Maximum PreparedStatements per connection" New topic
Author

Maximum PreparedStatements per connection

Paul Doherty
Greenhorn

Joined: Jan 11, 2001
Posts: 11
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

Joined: Sep 19, 2001
Posts: 23
yes, there is a limit. I know for oracle it's equal to maximum open cursors allowed.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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).]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Maximum PreparedStatements per connection
 
Similar Threads
PooledConnection maximum Limit
prepared or general statement in JDBC
Sharing Connection Object
How many statements we can open with that particular connection
i CAN'T POST TO THIS FORUM IT SAYS AS