This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara 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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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: 137
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: 137
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