Announcement Announcement Module
Collapse
No announcement yet.
Is Oracle JDBC driver caching prepared statements? Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Is Oracle JDBC driver caching prepared statements?

    Hi,

    I use the following code to execute queries within the app

    Code:
    getSimpleJdbcTemplate().getNamedParameterJdbcOperations()
    				.query(SELECT_YADA_YADA_YADA, namedParameters, sampleRowMapper);
    ..within an Oracle 11g environment.

    The JDBC driver is an Oracle JDBC driver that (according to their documentation http://download.oracle.com/docs/cd/B...h.htm#i1069942) caches OraclePreparedStatement.

    Will spring create OraclePreparedStatement when using an Oracle JDBC driver? I guess the connection will return an OraclePreparedStatement when asked for one..

    If it doesn't and is creating PreparedStatement instead, then is it correct understanding that the Oracle JDBC driver prepared statement cache functionality is not being used at all?
    Last edited by fewtrees; Mar 17th, 2011, 06:08 AM.
Working...
X