Have set 'reconnectforpools' to true?
That will help. It is under advanced settings.
Kind regards,
The out-side
Op 3 jul. 2013 om 14:31 heeft apache avro <apache.component_at_gmail.com> het volgende geschreven:
> Fails this way too.
>
> Thank You
> -M
>
>
> On Fri, Jun 28, 2013 at 5:34 PM, Marina Vatkina <marina.vatkina_at_oracle.com> wrote:
>> That's weird. May be the resource points to a different pool? Can you try naming it jdbc-test-pool (i.e. without '/')?
>>
>> thanks,
>> -marina
>>
>> On 6/27/13 8:22 AM, apache avro wrote:
>>> Problem persists even with derby database.
>>>
>>> "java.sql.SQLNonTransientConnectionException: A communications error has been detected: Software caused connection abort: recv failed."
>>>
>>> Any ideas?
>>>
>>> Thank You
>>>
>>>
>>>
>>> On Wed, Jun 26, 2013 at 9:16 PM, apache avro <apache.component_at_gmail.com> wrote:
>>>> I'll try to do it as soon as I get in tomorrow. Thanks Marina.
>>>>
>>>>
>>>> On Wed, Jun 26, 2013 at 4:52 PM, Marina Vatkina <marina.vatkina_at_oracle.com> wrote:
>>>>> Actually my last idea wasn't right - you have a non-xa resource, so tx recovery won't help (unless the same DB is indeed used as a tx resource by another app).
>>>>>
>>>>> Can you try with Derby to exclude Postgres problems?
>>>>>
>>>>> thanks,
>>>>> -marina
>>>>>
>>>>>
>>>>> On 6/26/13 12:07 PM, apache avro wrote:
>>>>>> No. No transactions in progress.
>>>>>> Is there any way to debug this?
>>>>>>
>>>>>>
>>>>>> On Wed, Jun 26, 2013 at 2:53 PM, Marina Vatkina <marina.vatkina_at_oracle.com> wrote:
>>>>>>> Are there any transaction in progress when the DB goes down? You might need to run 'recover-transactions' CLI. Otherwise it might be a DB issue.
>>>>>>>
>>>>>>> -marina
>>>>>>>
>>>>>>>
>>>>>>> On 6/26/13 5:31 AM, apache avro wrote:
>>>>>>>> Hello Marina,
>>>>>>>> Thanks for the quick suggestion.
>>>>>>>> I have already tried using the connection validation attributes but it did not help.
>>>>>>>>
>>>>>>>> This is how the connection-pool looks like
>>>>>>>>
>>>>>>>> <jdbc-connection-pool name="jdbc/test-pool"
>>>>>>>> res-type="javax.sql.DataSource"
>>>>>>>> datasource-classname="org.postgresql.ds.PGPoolingDataSource"
>>>>>>>> ping="true" pool-resize-quantity="5" max-pool-size="10"
>>>>>>>> statement-cache-size="10" is-connection-validation-required="true"
>>>>>>>> connection-validation-method="table"
>>>>>>>> validation-table-name="myschema.test">
>>>>>>>> ...
>>>>>>>> ...
>>>>>>>> </jdbc-connection-pool>
>>>>>>>>
>>>>>>>> Please suggest.
>>>>>>>>
>>>>>>>> Thank You
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Jun 25, 2013 at 4:10 PM, Marina Vatkina <marina.vatkina_at_oracle.com> wrote:
>>>>>>>>> Connection validation should help.
>>>>>>>>>
>>>>>>>>> -marina
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On 6/25/13 12:19 PM, apache avro wrote:
>>>>>>>>>> Hello All,
>>>>>>>>>> I have an application that uses JNDI to interact with postgresql. Whenever, there is a DB server restart, unless I restart glassfish I'm unable to interact with my DB. My efforts to use fail-all-connections, is-connection-validation-required and other attributes were futile.
>>>>>>>>>>
>>>>>>>>>> Please suggest a way to get my application to work with database without having to restart glassfish whenever I restart database server.
>>>>>>>>>>
>>>>>>>>>> Thank You
>>>>>>>>>> Max
>