atom feed9 messages in net.java.dev.quartz.usersRe: Clustering 1.6.6 in Weblogic 10.3
FromSent OnAttachments
Nathaniel AuvilDec 9, 2009 9:21 am 
James HouseDec 9, 2009 12:04 pm 
Nathaniel AuvilDec 9, 2009 12:09 pm 
James HouseDec 9, 2009 12:48 pm 
James HouseDec 9, 2009 12:50 pm 
Nathaniel AuvilDec 9, 2009 1:12 pm 
James HouseDec 9, 2009 1:47 pm 
Nathaniel AuvilDec 10, 2009 6:09 am 
Nathaniel AuvilDec 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?

Yes, you can, I do it all the time. You just have to use the Weblogic Oracle Driver.

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>