Hallo,
Quick answer, the statement is in the context of a database connection.
cheers,
M
[EMAIL PROTECTED] wrote:
> hi all!
> is there anyone who can quickly answer the following question for me
> (otherwise I will have to dig into JDBC implementation details...)
> in one of my servlets I would like to keep PreparedStatement objects over
> numerous calls to the same pages and just update the parameters every time.
> e.g.
> Connection con = ... //obtain connection, perhaps from connection pool
> PreparedStatement pstmt = con.prepareStatement("SELECT * FROM any WHERE
> some=?");
> I keep the reference pstmt (e.g. inside the session object) for later use.
> the connection, on the other hand, is released again (because it came from a
> connection pool or the like, not closed!)
> now my question is:
> when I call something like
> pstmt.setInt(1,10);
> ResultSet rs = pstmt.executeQuery();
> later, is it of any relevance if the connection-object that was used for the
> creation of the PreparedStatement is back in the pool, or even used by
> someone else in the meantime?
> thanx & greetings to all
>
> --
> GMX - Die Kommunikationsplattform im Internet.
> http://www.gmx.net
>
> To change your membership options, refer to:
> http://www.sys-con.com/java/list.cfm
To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
