• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JDBC and Database Upgrade

 
Ranch Hand
Posts: 178
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic