| From | Sent On | Attachments |
|---|---|---|
| Nathaniel Auvil | Dec 9, 2009 9:21 am | |
| James House | Dec 9, 2009 12:04 pm | |
| Nathaniel Auvil | Dec 9, 2009 12:09 pm | |
| James House | Dec 9, 2009 12:48 pm | |
| James House | Dec 9, 2009 12:50 pm | |
| Nathaniel Auvil | Dec 9, 2009 1:12 pm | |
| James House | Dec 9, 2009 1:47 pm | |
| Nathaniel Auvil | Dec 10, 2009 6:09 am | |
| Nathaniel Auvil | Dec 10, 2009 8:44 am |
| Subject: | Re: Clustering 1.6.6 in Weblogic 10.3 | |
|---|---|---|
| From: | Nathaniel Auvil (nath...@gmail.com) | |
| Date: | Dec 9, 2009 1:12:10 pm | |
| List: | net.java.dev.quartz.users | |
hi James thanks for the response.
I guess i am a bit unclear of what the Quartz data sources are for exactly....
I set the properties to use JobStoreCMT as my use case is something like this...
1) get data inputs 2) perform calculations 3) start a transaction 4) update application tables 5) schedule a job to run 6) commit transaction
the quartz config has two datasources defined...
org.quartz.jobStore.dataSource <--- what is this used for in CMT? org.quartz.jobStore.nonManagedTXDataSource <--- used by Quartz to obtain locks for cluster?
if I am following what you are saying....you are saying to create two data sources in Weblogic for these (different from my applications data source) and use the BEA Oracle Driver for them?
I did not think you could use the BEA Oracle driver to connect to Oracle RAC? The documentation says it is not supported. I suppose you could connect to a single instance in the database cluster but that defeats the purpose of having a database cluster. Thoughts?
FYI - The BEA driver is deprecated in 10.3 ( http://download.oracle.com/docs/cd/E12840_01/wls/docs103/upgrade/compat.html#wp1128814) and they say it will be removed in the next release.
On Wed, Dec 9, 2009 at 3:50 PM, James House <jho...@revolition.net> wrote:
If you think it is too risky for your whole project to switch to that driver, why not just create a separate datasource, connecting to the same db, but with that driver, and configure only Quartz to use that datasource?
james
James House wrote:
Yes, you can, I do it all the time. You just have to use the Weblogic Oracle Driver.
james
Nathaniel Auvil wrote:
thanks James.
So if we are using Weblogic Server and Oracle RAC, we can not use clustered Quartz?
On Wed, Dec 9, 2009 at 3:05 PM, James House <jho...@revolition.net<mailto: jho...@revolition.net>> wrote:
Sorry, there's no way (that I'm aware of, and I'm quite experienced with WLS and Oracle) to make this work with the Thin Driver.
james
Nathaniel Auvil wrote:
Hi. I am trying to get quartz clustering to work in Weblogic 10.3 with the Oracle Thin Driver.
I am using the
org.quartz.jobStore.driverDelegateClass =
org.quartz.impl.jdbcjobstore.oracle.weblogic.WebLogicOracleDelegate
And i have tried the #org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
I see the scheuler start in the log, and it reads my configuration, however it appears that the database is being locked. When i kill the weblogic server, i see my job in the database, but not when the server is up.
I have changed to the Weblogic Oracle driver and that seems to work fine, however i can not change the whole project over to use the Weblogic Driver at this point as it is too risky.
--------------------------------------------------------------------- To unsubscribe, e-mail: user...@quartz.dev.java.net <mailto:user...@quartz.dev.java.net> For additional commands, e-mail: user...@quartz.dev.java.net <mailto:user...@quartz.dev.java.net>





