Return-Path: 
 <dev-return-67494-apmail-cocoon-dev-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-dev-archive@www.apache.org
Received: (qmail 4198 invoked from network); 8 Nov 2004 13:56:03 -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:56:03 -0000
Received: (qmail 48650 invoked by uid 500); 8 Nov 2004 13:55:55 -0000
Delivered-To: apmail-cocoon-dev-archive@cocoon.apache.org
Received: (qmail 48578 invoked by uid 500); 8 Nov 2004 13:55:55 -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 48553 invoked by uid 99); 8 Nov 2004 13:55:55 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from [217.160.230.41] (HELO mout.perfora.net) (217.160.230.41)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 08 Nov 2004 05:55:55 -0800
Received: from minotaur.apache.org[209.237.227.194] (helo=[127.0.0.1])
	by mrelay.perfora.net with ESMTP (Nemesis),
	id 0MKz5u-1CR9zr1Fb2-0000MO; Mon, 08 Nov 2004 08:55:51 -0500
X-Provags-ID: perfora.net abuse@perfora.net
 login:e2e4156964dfbcc4c642ec658fa7f9b9
Message-ID: <418F7AE4.2090800@reverycodes.com>
Date: Mon, 08 Nov 2004 08:55:48 -0500
From: Vadim Gritsenko <vadim@reverycodes.com>
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-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

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.
...
> What have I done wrong?

Works for me with j2ee datasource:

     <store type="tx">
       <datasource>java:comp/env/jdbc/MyJobStoreDS</datasource>
     </store>

Declared in webapp's tomcat's context xml file:

<Context docBase="webapp" path="/url">
   <Resource auth="Container" name="jdbc/MyJobStoreDS" type="javax.sql.DataSource"/>

   <ResourceParams name="jdbc/MyJobStoreDS">
     ... etc ...
   </ResourceParams>
</Context>


Have not tried yet Excalibur's datasource.

Vadim