DBCP: Why is the validation query not a prepared statement

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

DBCP: Why is the validation query not a prepared statement

Gamnacke
Is there a reason for why the validation query is not a prepared statement? In the method
PoolableConnectionFactory.validateConnection(Connection conn) the validation query is executed as a normal statement (conn.createStatement()).

Would it be unsafe to use a prepared statement here instead?

Reply | Threaded
Open this post in threaded view
|

RE: DBCP: Why is the validation query not a prepared statement

wesclark
This is just a guess, but perhaps some JDBC drivers hold the prepare and
bundle it with the first execute.

-----Original Message-----
From: Gamnacke [mailto:[hidden email]]
Sent: Wednesday, February 25, 2009 1:39 AM
To: [hidden email]
Subject: DBCP: Why is the validation query not a prepared statement


Is there a reason for why the validation query is not a prepared
statement?
In the method
PoolableConnectionFactory.validateConnection(Connection conn) the
validation query is executed as a normal statement
(conn.createStatement()).

Would it be unsafe to use a prepared statement here instead?


--
View this message in context:
http://www.nabble.com/DBCP%3A-Why-is-the-validation-query-not-a-prepared
-statement-tp22199341p22199341.html
Sent from the Commons - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

RE: DBCP: Why is the validation query not a prepared statement

Gamnacke
Could that cause the validation to fail, that is, could that cause the validateConnection() to incorrectly say that a connection is valid while it is not?