Results 1 to 1 of 1

Thread: Is Oracle JDBC driver caching prepared statements?

  1. Mar 17th, 2011, 04:50 AM #1
    fewtrees
    fewtrees is offline Junior Member
    Join Date
    Mar 2011
    Posts
    2

    Default 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 at 05:08 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules