This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Spring and the fly likes Database Upgrade and Spring Framework's JMS capability Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "Database Upgrade and Spring Framework Watch "Database Upgrade and Spring Framework New topic
Author

Database Upgrade and Spring Framework's JMS capability

Andres Delrotti
Ranch Hand

Joined: Aug 11, 2005
Posts: 136
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.

The critical function I can see that I think might be affected by this upgrade is the use of message queueing (JMS). We basically make use of the Spring Framework's JMS capability. Do you think this would be affected when we upgrade our database from 9i Enterprise to 11g Standard?

I initially taught this should be posted in the Database forum but since I want to know if the use of Spring JMS would be affected by it, I placed it here. Any help would be appreciated.


Thanks,
Andres
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

I guess it depends on how you're using JMS--if messages are persisted in the database I suppose it's possible. Without the reference material you're referring to, or any information regarding your JMS setup, I don't see any way to help, though.

Normally JMS would be affected only by whatever you're using to implement JMS (usually a JEE container or library like ActiveMQ).
Andres Delrotti
Ranch Hand

Joined: Aug 11, 2005
Posts: 136
David Newton wrote:I Without the reference material you're referring to, or any information regarding your JMS setup, I don't see any way to help, though.


Thanks for the help David. Here's a link to our Spring-context.xml file. I removed some parts though.

http://pastie.org/979443
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

My answer is the same--I suppose it's possible. Since (I think?) you're persisting JMS messages in the DB, a DB change could potentially affect JMS operations. *Would* it? Meh--I don't know. I doubt it. Can't you just test it?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database Upgrade and Spring Framework's JMS capability
 
Similar Threads
Oracle JMS's AQjmsQueueConnectionFactory on Oracle Standard Edition
Oracle 10g installtion and configuartion guide
upgrade database from ORACLE 8i to ORACLE 9i.
JDBC and Database Upgrade
Jboss JMS API question