Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC and Database Upgrade

Andres Delrotti
Ranch Hand
Posts: 178
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Right now we're currently planning to upgrade our oracle database from 9i Enterprise to 11g Standard. We were asked to asses if this upgrade would have any impact on our current java applications. Its an upgrade to a higher version of oracle but to a Standard edition. I actually got hold of a table which lists the detailed differences between Standard and Enterprise editions and most of them I am not familiar with since I'm not really a database guy.

In our application, we make use of the oracle.jdbc.pool.OracleDataSource and set its values in Spring like this:

<bean id="myappDataSource" class="net.myapp.dao.OraDataSource">
<property name="url" value="${db.myapp.url}" />
<property name="user" value="${db.myapp.user}" />
<property name="password" value="${db.myapp.password}" />
<property name="initialLimit" value="2" />
<property name="minLimit" value="2" />
<property name="maxLimit" value="20" />
<property name="connectionWaitTimeout" value="10" />
<property name="inactivityTimeout" value="1800" />

Should I worry about this stuff when our Database is upgraded? This is since one advantage of the Enterprise edition of Oracle is connection pooling. I just want to know if this would have any effects if we changed it to a Standard edition instead of an Enterprise edition.

  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic