Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC and Database Upgrade

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

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" />
</bean>

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.



Thanks,
Andres
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic