Re: Oracle database calling the web app?

2009-01-15 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bill, Bill Davidson wrote: Mark Thomas wrote: 1. JMS? I thought Tomcat didn't support JMS. Am I wrong about this? Tomcat doesn't /provide/ JMS. You can add any JSM-compatible library to Tomcat (really, your own application) that you want. -

RE: Oracle database calling the web app?

2009-01-15 Thread Martin Gainty
: ch...@christopherschultz.net To: users@tomcat.apache.org Subject: Re: Oracle database calling the web app? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bill, Bill Davidson wrote: Mark Thomas wrote: 1. JMS? I thought Tomcat didn't support JMS. Am I wrong about this? Tomcat

Re: Oracle database calling the web app?

2009-01-07 Thread Juha Laiho
Bill Davidson wrote: Is it possible to set up a callback like situation so that a trigger in an Oracle 10g database can call a method in a currently running webapp that's running in Tomcat 6? Yes, there's UTL_HTTP PL/SQL package available in Oracle, which provides HTTP client functionality. AQ

Re: Oracle database calling the web app?

2009-01-07 Thread Bill Davidson
Juha Laiho wrote: However, have you actually measured how much load it would put to various pieces of your system to not cache this data, but just fetch it from the DB more or less each time it is needed? We currently have the ability to turn the caching on or off. We generally only turn

Re: Oracle database calling the web app?

2009-01-07 Thread Bill Davidson
Ken Bowen wrote: Whoops, hold that. This is ok for outbound. For inbound, it seems Jboss is needed: http://activemq.apache.org/jboss-integration.html I'm not sure I understand how that says JBoss is needed to do inbound communications. There is a page on configuring Tomcat:

Re: Oracle database calling the web app?

2009-01-06 Thread Edward Dowgiallo
Support for what you want to do is actually a feature in Oracle 11g. For Oracle 10g, you want to look at the publish/subscribe support which is part of advanced queueing. The documentation is available online at http://otn.oracle.com. Ed On Tue, Jan 6, 2009 at 5:22 PM, Bill Davidson

Re: Oracle database calling the web app?

2009-01-06 Thread Mark Thomas
Bill Davidson wrote: Is it possible to set up a callback like situation so that a trigger in an Oracle 10g database can call a method in a currently running webapp that's running in Tomcat 6? My situation is that I want to cache some infrequently changed database data in memory but when

Re: Oracle database calling the web app?

2009-01-06 Thread Youssef Mohammed
you can also have your trigger call a java package where you can simply call a web service (SOAP or RESTful). Regards, Youssef On Wed, Jan 7, 2009 at 12:26 AM, Edward Dowgiallo eddowgia...@gmail.comwrote: Support for what you want to do is actually a feature in Oracle 11g. For Oracle 10g,

Re: Oracle database calling the web app?

2009-01-06 Thread Edward Dowgiallo
It is not necessary to poll an Oracle database. Advanced queueing in combination with triggers provide an event driven framework. Ed On Tue, Jan 6, 2009 at 5:28 PM, Mark Thomas ma...@apache.org wrote: Bill Davidson wrote: Is it possible to set up a callback like situation so that a trigger

Re: Oracle database calling the web app?

2009-01-06 Thread Edward Dowgiallo
This is also highly inefficient. You are taking on all the additional overhead of a web service call for no reason. Ed On Tue, Jan 6, 2009 at 5:31 PM, Youssef Mohammed youssef.moham...@gmail.com wrote: you can also have your trigger call a java package where you can simply call a web

Re: Oracle database calling the web app?

2009-01-06 Thread Youssef Mohammed
an asynchronous solution is definitely a better solution but either ways, you have to call some web services at the end to notify the web app , no ? Regards, Youssef On Wed, Jan 7, 2009 at 12:35 AM, Edward Dowgiallo eddowgia...@gmail.comwrote: This is also highly inefficient. You are

Re: Oracle database calling the web app?

2009-01-06 Thread Bill Davidson
Mark Thomas wrote: 1. JMS? I thought Tomcat didn't support JMS. Am I wrong about this? 2. Call an reload servlet from the database? Sounds slightly painful but at least it's event driven. 3. Drop the immediate update requirement and poll a data changed flag in the db every x seconds?

Re: Oracle database calling the web app?

2009-01-06 Thread Bill Davidson
Edward Dowgiallo wrote: Support for what you want to do is actually a feature in Oracle 11g. For Oracle 10g, you want to look at the publish/subscribe support which is part of advanced queueing. The documentation is available online at http://otn.oracle.com. Is this the book I should be

Re: Oracle database calling the web app?

2009-01-06 Thread Bill Davidson
Bill Davidson wrote: Oracle Streams Advanced Queuing User's Guide and Reference Looking through that, it looks like it uses JMS to send a message back to Java. Being on Tomcat, that's a problem. Some searching shows I may be able to use OpenJMS or ActiveMQ to get JMS in Tomcat.

Re: Oracle database calling the web app?

2009-01-06 Thread Ken Bowen
It's possible to integrate Tomcat and ActiveMQ (a JMS superset): http://activemq.apache.org/tomcat.html On Jan 6, 2009, at 6:08 PM, Bill Davidson wrote: Bill Davidson wrote: Oracle Streams Advanced Queuing User's Guide and Reference Looking through that, it looks like it uses JMS to

Re: Oracle database calling the web app?

2009-01-06 Thread Ken Bowen
Whoops, hold that. This is ok for outbound. For inbound, it seems Jboss is needed: http://activemq.apache.org/jboss-integration.html On Jan 6, 2009, at 6:51 PM, Ken Bowen wrote: It's possible to integrate Tomcat and ActiveMQ (a JMS superset): http://activemq.apache.org/tomcat.html On