File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC and Database Upgrade Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC and Database Upgrade" Watch "JDBC and Database Upgrade" New topic

JDBC and Database Upgrade

Andres Delrotti
Ranch Hand

Joined: Aug 11, 2005
Posts: 164

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.

I agree. Here's the link:
subject: JDBC and Database Upgrade
It's not a secret anymore!