Cocoon + postgresSQL

[beyaRecords - The home Urban music <uz...@beya-records.com>]

Hi,
is anybody using cocoon and postgresql to query a stored procedure? I 
am trying to return a resultset:
select * from tablename, and am having problems writing the procedure.


regards

Uzo

p.s. I know that this could be considered to be more of a postgresql 
forum question, but I thought it would be better to ask people who were 
using the same development platform as me ;-)
On 2 Jan 2004, at 15:51, enrico.maccias@free.fr wrote:

> Selon Upayavira <uv...@upaya.co.uk>:
>
>> enrico.maccias@free.fr wrote:
>>
>>> Selon Geoff Howard <co...@leverageweb.com>:
>>>
>>>
>>>
>>>> enrico.maccias@free.fr wrote:
>>>>
>>>>
>>>>> Hi there and happy new year!
>>>>>
>>>>>
>>>>>   Does anyone know a way to trigger a sitemap pipeline in response 
>>>>> to a
>>>>>
>>>>>
>>>> JMS
>>>>
>>>>
>>>>> notification (onMessage()) ?
>>>>>
>>>>>
>>>> A general solution for this has been discussed before but never
>>>> implemented (here at least).  Still, this is certainly possible 
>>>> today
>>>> with a custom component - but could be a lot of work because you'd 
>>>> need
>>>> to create a full request environment on your own.
>>>>
>>>> But first, I should ask - why?  Do you need the response back from 
>>>> the
>>>> pipeline re-sent as a followup message, or something?  Or do you 
>>>> simply
>>>> need to fire off some business logic which is also done by firing 
>>>> off a
>>>> pipeline?
>>>>
>>>> Geoff
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>> Actually, I don't need to re-send a followup message. Anyway, I 
>>> think JMS is
>>
>>> not important here. I just need to know if there's a way to fire off 
>>> a
>>> pipeline without an HTTP request (even if cocoon is used as a 
>>> servlet)?
>>>
>>>
>> Why do you want to fire off a pipeline? Because of some kind of
>> side-effect of the pipeline? What do you want to do with the output of
>> the pipeline?
>>
>> There are ways, but it depends upon what you're trying to achieve.
>>
>> Regards, Upayavira
>>
>>
>
>
> I need to "prepare" some static XML files (mainly XSLTransformations) 
> to be
> later processed/served by a Cocoon-based webapp. Those XML files are 
> dropped
> on an FTP server and I get notified of their arrival... Since I use 
> cocoon (as
> a servlet) I don't want to write an independant Xalan piece of code :)
>
> Enrico
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: Cocoon + postgresSQL

[Geoff Howard <co...@leverageweb.com>]

beyaRecords - The home Urban music wrote:

> Hi,
> is anybody using cocoon and postgresql to query a stored procedure? I am 
> trying to return a resultset:
> select * from tablename, and am having problems writing the procedure.

I've noticed that you (and others) appear to be using "reply-to" on the 
latest message as a short cut to starting a new discussion thread 
(asking a new question).  This is probably causing many of your 
questions to be ignored because many threaded email clients will show 
your post as part of an unrelated thread even though the subject line 
has changed.

When posting a new question you will get noticed more, help archive 
searches, and frustrate people less if you create a new message to 
users@cocoon.apache.org instead of using "reply-to" on an unrelated message.

Geoff

> On 2 Jan 2004, at 15:51, enrico.maccias@free.fr wrote:
> 
>> Selon Upayavira <uv...@upaya.co.uk>:
>>> enrico.maccias@free.fr wrote:
>>>> Selon Geoff Howard <co...@leverageweb.com>:
>>>>> enrico.maccias@free.fr wrote:
>>>>>
>>>>>> Hi there and happy new year!
>>>>>>   Does anyone know a way to trigger a sitemap pipeline in response 
>>>>>> to a
>>>>> JMS
>>>>>> notification (onMessage()) ?



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org