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 <mailto: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 <mailto: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
>>
>>
>>
>
>