Re: Cocoon Connection Pooling and Database Shutdown

[Bobby Mitchell]

Hunsberger, Peter wrote:

>>>Why should I use carriage returns in my messages, Berin?
>>>  
>>>
>>So that we don't have to scroll on forever in one direction, and it makes
>>
>>
>it
>  
>
>>alot easier to interpose comments throughout your message--adding context
>>
>>
>to
>  
>
>>other people's response.
>>
>>
>
>Berin, what mail client are you using?  Most have a configurable setting to
>tell them when to wrap long lines.  I for one only put in CR/LF when
>starting new paragraphs; I've been using e-mail for some 20 years now
>(showing my age! ;-) and never had anyone complain...
>
I'm trying to forget about age, but I'm forgetting parts of everything. 
I've even forgotten how old I am at times.

>
>
>-
>Please check that your question  has not already been answered in the
>FAQ before posting. 
>
>To unsubscribe, e-mail: <[EMAIL PROTECTED]>
>For additional commands, e-mail:   <[EMAIL PROTECTED]>
>  
>


-- 
Robert J. (Bobby) Mitchell
Systems Administrator
NASA Institute for Advanced Concepts
555A 14th St Atlanta, Ga. 30318
Phone: (404)347-9633 Fax: (404)347-9638





-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Cocoon Connection Pooling and Database Shutdown

[Steven Noels]

Berin Loritsch wrote:

> I've had other people complain to me about the same thing.
> 
> When you *respond* using Mozilla, what was once a auto-wrapped line is now
> one long line that goes on forever.

In the message composition menu: Options > Rewrap.

I use it all the time - dunnow if my mails are well received at the 
other side however.


-- 
Steven Noelshttp://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
[EMAIL PROTECTED]  [EMAIL PROTECTED]


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Cocoon Connection Pooling and Database Shutdown

[Berin Loritsch]

Hunsberger, Peter wrote:
>>>Why should I use carriage returns in my messages, Berin?
>>
>>So that we don't have to scroll on forever in one direction, and it makes
> 
> it
> 
>>alot easier to interpose comments throughout your message--adding context
> 
> to
> 
>>other people's response.
> 
> 
> Berin, what mail client are you using?  Most have a configurable setting to
> tell them when to wrap long lines.  I for one only put in CR/LF when
> starting new paragraphs; I've been using e-mail for some 20 years now
> (showing my age! ;-) and never had anyone complain...

I've had other people complain to me about the same thing.

When you *respond* using Mozilla, what was once a auto-wrapped line is now
one long line that goes on forever.


-- 

"They that give up essential liberty to obtain a little temporary safety
  deserve neither liberty nor safety."
 - Benjamin Franklin


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

RE: Cocoon Connection Pooling and Database Shutdown

[Hunsberger, Peter]

>> Why should I use carriage returns in my messages, Berin?
>
> So that we don't have to scroll on forever in one direction, and it makes
it
> alot easier to interpose comments throughout your message--adding context
to
> other people's response.

Berin, what mail client are you using?  Most have a configurable setting to
tell them when to wrap long lines.  I for one only put in CR/LF when
starting new paragraphs; I've been using e-mail for some 20 years now
(showing my age! ;-) and never had anyone complain...


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Cocoon Connection Pooling and Database Shutdown

[Berin Loritsch]

Michael Edge wrote:
> Why should I use carriage returns in my messages, Berin?

So that we don't have to scroll on forever in one direction, and it makes it
alot easier to interpose comments throughout your message--adding context to
other people's response.

-- 

"They that give up essential liberty to obtain a little temporary safety
  deserve neither liberty nor safety."
 - Benjamin Franklin


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Cocoon Connection Pooling and Database Shutdown

[Michael Edge]

Why should I use carriage returns in my messages, Berin?

Michael


- Message from Berin Loritsch <[EMAIL PROTECTED]> on Wed, 16 Oct 2002 09:01:01 
-0400 -
  
  To: [EMAIL PROTECTED] 
  
 Subject: Re: Cocoon Connection Pooling and Database  
  Shutdown
  



 please use carriage returns in your messages 




--

This e-mail may contain confidential and/or privileged information. If you are not the 
intended recipient (or have received this e-mail in error) please notify the sender 
immediately and destroy this e-mail. Any unauthorized copying, disclosure or 
distribution of the material in this e-mail is strictly forbidden.



-
Please check that your question  has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Cocoon Connection Pooling and Database Shutdown

[Antonio Gallardo Rivera]

I forgot: See below 




El Miércoles, 16 de Octubre de 2002 06:51, Michael Edge escribió:
> Could anyone shed some light on what happens to the Cocoon connection pool
> when the database it depends on is shutdown and then restarted. I expect an
> exception to be thrown as the connections are invalid, and though I don't
> explicitly catch it using esql:error-results in my XSP page, I expect that
> this exception should appear somewhere; perhaps in a log file or returned
> as part of the XML generated by the XSP. However, if my database has been
> shutdown and then restarted, the XSP below returns Sorry, no
> trading book results!. I have to restart Tomcat to get it
> working again.
>
> 
> 
> mosaic
> 
> SELECT distinct
> vm_tradingbook_id as tradingbook_code, tradingbookname FROM
> V_TRADINGBOOK_VM order by 2 
> 
>
>  column="tradingbook_code"/>  column="tradingbookname"/> 
> 
> 
> Sorry, no
> trading book results! 

The erro is: 

> 
> 
> 
>
> Regards
>
> Michael
>
> ---
> Michael Edge
> Global Markets Technology
> Institutional Client Group
>
> Phone:  +44  (0) 20 7545 3204
> Fax :   +44  (0) 20 7545 1559
> Internet email:[EMAIL PROTECTED]

-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Cocoon Connection Pooling and Database Shutdown

[Berin Loritsch]

Michael Edge wrote:
> Could anyone shed some light on what happens to the Cocoon connection pool when the 
>database it depends on is shutdown and then restarted. I expect an exception to be 
>thrown as the connections are invalid, and though I don't explicitly catch it using 
>esql:error-results in my XSP page, I expect that this exception should appear 
>somewhere; perhaps in a log file or returned as part of the XML generated by the XSP. 
>However, if my database has been shutdown and then restarted, the XSP below returns 
>Sorry, no trading book results!. I have to restart Tomcat 
>to get it working again.

 please use carriage returns in your messages 

The way the connection pooling works is that when the connections are set
with a specific Keep-Alive query that works, the connection will try to
be reestablished when the Keep-Alive fails.  If the Pool cannot return
a valid connection, then it will throw an exception.  You may experience
a long timeout while it is waiting to get a valid connection.

The ESQL logicsheet swollows *alot* of error messages.  It is very possible
that ESQL is your problem.


-- 

"They that give up essential liberty to obtain a little temporary safety
  deserve neither liberty nor safety."
 - Benjamin Franklin


-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Re: Cocoon Connection Pooling and Database Shutdown

[Antonio Gallardo Rivera]

Try this tag:


The error is: 


Antonio Gallardo

El Miércoles, 16 de Octubre de 2002 06:51, Michael Edge escribió:
> Could anyone shed some light on what happens to the Cocoon connection pool
> when the database it depends on is shutdown and then restarted. I expect an
> exception to be thrown as the connections are invalid, and though I don't
> explicitly catch it using esql:error-results in my XSP page, I expect that
> this exception should appear somewhere; perhaps in a log file or returned
> as part of the XML generated by the XSP. However, if my database has been
> shutdown and then restarted, the XSP below returns Sorry, no
> trading book results!. I have to restart Tomcat to get it
> working again.
>
> 
> 
> mosaic
> 
> SELECT distinct
> vm_tradingbook_id as tradingbook_code, tradingbookname FROM
> V_TRADINGBOOK_VM order by 2 
> 
>
>  column="tradingbook_code"/>  column="tradingbookname"/> 
> 
> 
> Sorry, no
> trading book results! 
> 
> 
> 
>
> Regards
>
> Michael
>
> ---
> Michael Edge
> Global Markets Technology
> Institutional Client Group
>
> Phone:  +44  (0) 20 7545 3204
> Fax :   +44  (0) 20 7545 1559
> Internet email:[EMAIL PROTECTED]

-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Cocoon Connection Pooling and Database Shutdown

[Michael Edge]

Could anyone shed some light on what happens to the Cocoon connection pool when the 
database it depends on is shutdown and then restarted. I expect an exception to be 
thrown as the connections are invalid, and though I don't explicitly catch it using 
esql:error-results in my XSP page, I expect that this exception should appear 
somewhere; perhaps in a log file or returned as part of the XML generated by the XSP. 
However, if my database has been shutdown and then restarted, the XSP below returns 
Sorry, no trading book results!. I have to restart Tomcat 
to get it working again.



mosaic

SELECT distinct vm_tradingbook_id 
as tradingbook_code, tradingbookname FROM V_TRADINGBOOK_VM order by 2








Sorry, no trading book 
results!





Regards

Michael

---
Michael Edge
Global Markets Technology
Institutional Client Group

Phone:  +44  (0) 20 7545 3204
Fax :   +44  (0) 20 7545 1559
Internet email:[EMAIL PROTECTED]


--

This e-mail may contain confidential and/or privileged information. If you are not the 
intended recipient (or have received this e-mail in error) please notify the sender 
immediately and destroy this e-mail. Any unauthorized copying, disclosure or 
distribution of the material in this e-mail is strictly forbidden.



-
Please check that your question  has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>