Underlying database and driver used by Spring JdbcTemplate

I had an issue when migrating my Spring applications to OCI (Oracle Call Interface) from Oracle JDBC. Needless to say, I found 3 different ojdbc14.jar with the same version but different file sizes. classes12.jar was in the configuration libraries too.

I used the following code to find the Database version and the Driver Name and it helped me resolve my issues.

String databaseName = (String) JdbcUtils.extractDatabaseMetaData(this.jdbcTemplate.getDataSource(),
"getDatabaseProductName");
String databaseVersion = (String) JdbcUtils.extractDatabaseMetaData(this.jdbcTemplate.getDataSource(),
"getDatabaseProductVersion");
String driverName = (String) JdbcUtils.extractDatabaseMetaData(this.jdbcTemplate.getDataSource(),
"getDriverName");
String driverVersion = (String) JdbcUtils.extractDatabaseMetaData(this.jdbcTemplate.getDataSource(),
"getDriverVersion");
log.info("Database Name: " + databaseName);
log.info("Database Version: " + databaseVersion);
log.info("Driver Name: " + driverName);
log.info("Driver Version: " + driverVersion);

The output was

2009-04-07 13:33:36,406 INFO OrderDaoJdbc:{OrderDaoJdbc.java:141} - Database Name: Oracle
2009-04-07 13:33:36,406 INFO OrderDaoJdbc:{OrderDaoJdbc.java:142} - Database Version: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
2009-04-07 13:33:36,406 INFO OrderDaoJdbc:{OrderDaoJdbc.java:143} - Driver Name: Oracle JDBC driver
2009-04-07 13:33:36,406 INFO OrderDaoJdbc:{OrderDaoJdbc.java:144} - Driver Version: 9.2.0.5.0