This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes prepared stament for no of users Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "prepared stament for no of users" Watch "prepared stament for no of users" New topic
Author

prepared stament for no of users

sitaram irrinki
Ranch Hand

Joined: Feb 16, 2005
Posts: 158
If multiple users are given the same Prepared Statement, with
different Connections ( each user has one connection), then how the JDBC
driver handles the Prepared Statement.
Lars Vonk
Ranch Hand

Joined: Aug 05, 2005
Posts: 30
Hi,
How is this possible? You call prepareStatement() on your Connection object, this returns a PreparedStatement. So if each user has a different Connection then how can they have the same PreparedStatement?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: prepared stament for no of users
 
Similar Threads
what is better
Statement vs. Prepared Statement
Urgent Java interview question 6+ yrs exp.
Create DB2 database
pre-compile and prepared statement