Return-Path: 
 <dev-return-67493-apmail-cocoon-dev-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-dev-archive@www.apache.org
Received: (qmail 3699 invoked from network); 8 Nov 2004 13:55:18 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 8 Nov 2004 13:55:18 -0000
Received: (qmail 47135 invoked by uid 500); 8 Nov 2004 13:55:13 -0000
Delivered-To: apmail-cocoon-dev-archive@cocoon.apache.org
Received: (qmail 47069 invoked by uid 500); 8 Nov 2004 13:55:13 -0000
Mailing-List: contact dev-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:dev-help@cocoon.apache.org>
list-unsubscribe: <mailto:dev-unsubscribe@cocoon.apache.org>
list-post: <mailto:dev@cocoon.apache.org>
Reply-To: dev@cocoon.apache.org
Delivered-To: mailing list dev@cocoon.apache.org
Received: (qmail 47055 invoked by uid 99); 8 Nov 2004 13:55:13 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (hermes.apache.org: local policy)
Received: from [213.133.34.195] (HELO panacea.is.nl) (213.133.34.195)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 08 Nov 2004 05:55:12 -0800
Received: from hai01.hippo.local ([213.133.51.241]) by panacea.is.nl with
 Microsoft SMTPSVC(5.0.2195.4905);
	 Mon, 8 Nov 2004 14:56:00 +0100
Received: from [10.10.100.212] ([10.10.100.212]) by hai01.hippo.local with
 Microsoft SMTPSVC(5.0.2195.6713);
	 Mon, 8 Nov 2004 14:55:09 +0100
Message-ID: <418F7ABD.3040904@hippo.nl>
Date: Mon, 08 Nov 2004 14:55:09 +0100
From: Unico Hommes <unico@hippo.nl>
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: dev@cocoon.apache.org
Subject: Re: Problems with Quartz JobStore
References: <49FC3093-3180-11D9-827A-000D9336FCE4@media.demon.co.uk>
In-Reply-To: <49FC3093-3180-11D9-827A-000D9336FCE4@media.demon.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 08 Nov 2004 13:55:09.0175 (UTC)
 FILETIME=[8F395070:01C4C59A]
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

What if, instead of using the short names <datasources> and <jdbc>, you 
declare the datasource like so:

<component 
role="org.apache.avalon.excalibur.datasource.DataSourceComponent/quartz"
  
class="org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource">
      <pool-controller max="10" min="5"/>
      <dburl>jdbc:postgresql://localhost/quartz</dburl>
      <user>cocoon</user>
      <password>*************</password>
</component>

I was under the impression that ECM would transparently map the short 
name form and the above form to the same lookup semantics. 
(serviceManager.lookup(DataSourceComponent.ROLE + "/quartz")) Perhaps I 
was wrong and it is only Fortress that does that.

--
Unico


Jeremy Quinn wrote:

> Hi All
>
> Has anyone got any experience using a persistable JobStore with Quartz ?
>
> I am trying to use Postgresql to persist Quartz jobs across restarts 
> of  Cocoon.
>
> I have the following setup :
>
> 1) Using the script in docs/dbTables/tables_postgres.sql that comes  
> with Quartz 1.4.2 distribution, create a database called 'quartz',  
> grant privileges on the tables, confirm that I can connect with user:  
> 'cocoon', using an external client (PostMan Query.app).
>
> 2) Add the postgres driver to :  
> BRANCH_2_1_X/build/webapp/WEB-INF/lib/postgresql.jar
>
> 3) Add the config to load the driver to web.xml:
>
>     <init-param>
>       <param-name>load-class</param-name>
>       <param-value>org.postgresql.Driver</param-value>
>     </init-param>
>
> 4) Add the datasource to cocoon.xconf :
>
>   <datasources>
>     <jdbc logger="core.datasources.quartz" name="quartz">
>       <pool-controller max="10" min="5"/>
>       <dburl>jdbc:postgresql://localhost/quartz</dburl>
>       <user>cocoon</user>
>       <password>*************</password>
>     </jdbc>
>     . . .
>   </datasources>
>
> 5) Adjust the Quartz setup in cocoon.xconf :
>
>       <!--<store type="ram"/>-->
>
>       <store type="tx"  
> delegate="org.quartz.impl.jdbcjobstore.PostreSQLDelegate">
>         <datasource provider="excalibur">quartz</datasource>
>       </store>
>
>
> When I start Cocoon, I get the following exception in cron.log :
>
> ERROR   (2004-11-08) 11:50.10:449   [core.manager] (Unknown-URI)  
> Unknown-thread/ExcaliburComponentManager: Caught an exception trying 
> to  initialize the component handler.
> org.apache.avalon.framework.configuration.ConfigurationException: No  
> datasource available by that name: quartz
>     at  
> org.apache.cocoon.components.cron.DataSourceComponentConnectionProvider. 
> <init>(DataSourceComponentConnectionProvider.java:42)
>     at  
> org.apache.cocoon.components.cron.QuartzJobScheduler.createJobStore(Quar 
> tzJobScheduler.java:738)
>     at  
> org.apache.cocoon.components.cron.QuartzJobScheduler.initialize(QuartzJo 
> bScheduler.java:321)
>     at  
> org.apache.avalon.framework.container.ContainerUtil.initialize(Container 
> Util.java:283)
>     at  
> org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstanc 
> e(DefaultComponentFactory.java:277)
>     at  
> org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initial 
> ize(ThreadSafeComponentHandler.java:108)
>     at  
> org.apache.avalon.excalibur.component.ExcaliburComponentManager.initiali 
> ze(ExcaliburComponentManager.java:522)
>     at  
> org.apache.cocoon.components.CocoonComponentManager.initialize(CocoonCom 
> ponentManager.java:541)
>     at  
> org.apache.avalon.framework.container.ContainerUtil.initialize(Container 
> Util.java:283)
>     at org.apache.cocoon.Cocoon.initialize(Cocoon.java:314)
>     at  
> org.apache.avalon.framework.container.ContainerUtil.initialize(Container 
> Util.java:283)
>     at  
> org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonServlet.java: 
> 1382)
>     at 
> org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:480)
>     at  
> org.mortbay.jetty.servlet.ServletHolder.start(ServletHolder.java:220)
>     at  
> org.mortbay.jetty.servlet.ServletHandler.initializeServlets(ServletHandl 
> er.java:445)
>     at  
> org.mortbay.jetty.servlet.WebApplicationHandler.initializeServlets(WebAp 
> plicationHandler.java:150)
>     at  
> org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationCont 
> ext.java:458)
>     at org.mortbay.http.HttpServer.start(HttpServer.java:663)
>     at org.mortbay.jetty.Server.main(Server.java:429)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at  
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav 
> a:39)
>     at  
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor 
> Impl.java:25)
>     at java.lang.reflect.Method.invoke(Method.java:324)
>     at Loader.invokeMain(Unknown Source)
>     at Loader.run(Unknown Source)
>     at Loader.main(Unknown Source)
>
> DataSourceComponentConnectionProvider cannot find the specified  
> datasource.
>
> What have I done wrong?
>
> Thanks for any help
>
> regards Jeremy
>
>
> --------------------------------------------------------
>
>                   If email from this address is not signed
>                                 IT IS NOT FROM ME
>
>                         Always check the label, folks !!!!!
> --------------------------------------------------------
>