JPA problem with connection

[ddevore]

I think I have solved my problem but I wanted to check on the solution to make sure I was doing it right and to see if there is a better solution. I was having a problem with my JDBC connections. The problem is that if I lose connectivity with the DB the connections all die which is expected but they don't seem to recover for an extended period of time.

What I have done to solve the problem:
I turned on Connection Validation using table validation (because I could go hours without any commits) and On Any Failure Close All connections.

Once I made these changes seems to work the way I need it to, solving the problem.

So my question now is am I doing this right or is there a better way of doing connection recovery with EJB3?

Can I do it from the persistence.xml?

[Marina Vatkina]

This is the right thing to do if you use GlassFish connection pool.

Regards,
-marina

Dru Devore wrote:

> I think I have solved my problem but I wanted to check on the solution
> to make sure I was doing it right and to see if there is a better
> solution. I was having a problem with my JDBC connections. The problem
> is that if I lose connectivity with the DB the connections all die which
> is expected but they don't seem to recover for an extended period of time.
>
> What I have done to solve the problem:
> I turned on Connection Validation using table validation (because I
> could go hours without any commits) and On Any Failure Close All
> connections.
>
> Once I made these changes seems to work the way I need it to, solving
> the problem.
>
> So my question now is am I doing this right or is there a better way of
> doing connection recovery with EJB3?
>
> Can I do it from the persistence.xml?
>
> --------------------------------------------------------------------- To
> unsubscribe, e-mail: users-unsubscribe@... For
> additional commands, e-mail: users-help@...

[djclarke]

My google login is: douglas.clarke@...

Doug

-----Original Message-----
From: Marina Vatkina [mailto:Marina.Vatkina@...]
Sent: Thursday, October 02, 2008 1:33 PM
To: users@...
Cc: persistence@...
Subject: Re: JPA problem with connection


This is the right thing to do if you use GlassFish connection pool.

Regards,
-marina

Dru Devore wrote:

> I think I have solved my problem but I wanted to check on the solution
> to make sure I was doing it right and to see if there is a better
> solution. I was having a problem with my JDBC connections. The problem
> is that if I lose connectivity with the DB the connections all die which
> is expected but they don't seem to recover for an extended period of time.
>
> What I have done to solve the problem:
> I turned on Connection Validation using table validation (because I
> could go hours without any commits) and On Any Failure Close All
> connections.
>
> Once I made these changes seems to work the way I need it to, solving
> the problem.
>
> So my question now is am I doing this right or is there a better way of
> doing connection recovery with EJB3?
>
> Can I do it from the persistence.xml?
>
> --------------------------------------------------------------------- To
> unsubscribe, e-mail: users-unsubscribe@... For
> additional commands, e-mail: users-help@...

[ddevore]

Running this solution has been working until I redeploy the application from NetBeans. If I redeploy the application all the values are set back to the default.

Anyone know why this is happening or how I can fix it?

-------- Original Message --------
Subject: RE: JPA problem with connection
From: "Dru Devore" <ddevore@...>
Date: Thu, October 02, 2008 2:11 pm
To: users@...

AWESOME im validated.

Thanks for the affirmation.

---
Dru Devore
The best Christian community now online.
The Faith Haven
www.thefaithhaven.com
Come join us, bookmark us, and enjoy!

-------- Original Message --------
Subject: Re: JPA problem with connection
From: Marina Vatkina <Marina.Vatkina@...>
Date: Thu, October 02, 2008 1:33 pm
To: users@...
Cc: persistence@...

This is the right thing to do if you use GlassFish connection pool.

Regards,
-marina

Dru Devore wrote:
> I think I have solved my problem but I wanted to check on the solution
> to make sure I was doing it right and to see if there is a better
> solution. I was having a problem with my JDBC connections. The problem
> is that if I lose connectivity with the DB the connections all die which
> is expected but they don't seem to recover for an extended period of time.
>
> What I have done to solve the problem:
> I turned on Connection Validation using table validation (because I
> could go hours without any commits) and On Any Failure Close All
> connections.
>
> Once I made these changes seems to work the way I need it to, solving
> the problem.
>
> So my question now is am I doing this right or is there a better way of
> doing connection recovery with EJB3?
>
> Can I do it from the persistence.xml?
>
> --------------------------------------------------------------------- To
> unsubscribe, e-mail: users-unsubscribe@... For
> additional commands, e-mail: users-help@...


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

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

[Marina Vatkina]

Are you using sun-resources.xml? If yes, you might want to switch to a manual
creation of the resources.

Regards,
-marina

Dru Devore wrote:

> Running this solution has been working until I redeploy the application
> from NetBeans. If I redeploy the application all the values are set back
> to the default.
>
> Anyone know why this is happening or how I can fix it?
>
>
>     -------- Original Message --------
>     Subject: RE: JPA problem with connection
>     From: "Dru Devore" <ddevore@...>
>     Date: Thu, October 02, 2008 2:11 pm
>     To: users@...
>
>     AWESOME im validated.
>
>     Thanks for the affirmation.
>
>     ---
>     Dru Devore
>     The best Christian community now online.
>     The Faith Haven
>     www.thefaithhaven.com <http://www.thefaithhaven.com>
>     Come join us, bookmark us, and enjoy!
>
>         -------- Original Message --------
>         Subject: Re: JPA problem with connection
>         From: Marina Vatkina <Marina.Vatkina@...>
>         Date: Thu, October 02, 2008 1:33 pm
>         To: users@...
>         Cc: persistence@...
>
>         This is the right thing to do if you use GlassFish connection pool.
>
>         Regards,
>         -marina
>
>         Dru Devore wrote:
>>  I think I have solved my problem but I wanted to check on the
>         solution
>>  to make sure I was doing it right and to see if there is a better
>>  solution. I was having a problem with my JDBC connections. The
>         problem
>>  is that if I lose connectivity with the DB the connections all
>         die which
>>  is expected but they don't seem to recover for an extended
>         period of time.
>>
>>  What I have done to solve the problem:
>>  I turned on Connection Validation using table validation
>         (because I
>>  could go hours without any commits) and On Any Failure Close All
>>  connections.
>>
>>  Once I made these changes seems to work the way I need it to,
>         solving
>>  the problem.
>>
>>  So my question now is am I doing this right or is there a
>         better way of
>>  doing connection recovery with EJB3?
>>
>>  Can I do it from the persistence.xml?
>>
>>
>         ---------------------------------------------------------------------
>         To
>>  unsubscribe, e-mail: users-unsubscribe@... For
>>  additional commands, e-mail: users-help@...
>
>
>         ---------------------------------------------------------------------
>         To unsubscribe, e-mail: users-unsubscribe@...
>         For additional commands, e-mail: users-help@...
>
>     ---------------------------------------------------------------------
>     To unsubscribe, e-mail: users-unsubscribe@... For
>     additional commands, e-mail: users-help@...
>
> --------------------------------------------------------------------- To
> unsubscribe, e-mail: users-unsubscribe@... For
> additional commands, e-mail: users-help@...

[ddevore]

Thank you Thank you this is just what I was looking for. I am changing the sun-resources.xml to contain the correct settings what I want.

Anyway this worked for me thanks again.

-------- Original Message --------
Subject: Re: JPA problem with connection
From: Marina Vatkina <Marina.Vatkina@...>
Date: Thu, October 02, 2008 6:01 pm
To: users@...
Cc: persistence@...

Are you using sun-resources.xml? If yes, you might want to switch to a manual
creation of the resources.

Regards,
-marina

Dru Devore wrote:
> Running this solution has been working until I redeploy the application
> from NetBeans. If I redeploy the application all the values are set back
> to the default.
>
> Anyone know why this is happening or how I can fix it?
>
>
> -------- Original Message --------
> Subject: RE: JPA problem with connection
> From: "Dru Devore" <ddevore@...>
> Date: Thu, October 02, 2008 2:11 pm
> To: users@...
>
> AWESOME im validated.
>
> Thanks for the affirmation.
>
> ---
> Dru Devore
> The best Christian community now online.
> The Faith Haven
> www.thefaithhaven.com <http://www.thefaithhaven.com>
> Come join us, bookmark us, and enjoy!
>
> -------- Original Message --------
> Subject: Re: JPA problem with connection
> From: Marina Vatkina <Marina.Vatkina@...>
> Date: Thu, October 02, 2008 1:33 pm
> To: users@...
> Cc: persistence@...
>
> This is the right thing to do if you use GlassFish connection pool.
>
> Regards,
> -marina
>
> Dru Devore wrote:
>> I think I have solved my problem but I wanted to check on the
> solution
>> to make sure I was doing it right and to see if there is a better
>> solution. I was having a problem with my JDBC connections. The
> problem
>> is that if I lose connectivity with the DB the connections all
> die which
>> is expected but they don't seem to recover for an extended
> period of time.
>>
>> What I have done to solve the problem:
>> I turned on Connection Validation using table validation
> (because I
>> could go hours without any commits) and On Any Failure Close All
>> connections.
>>
>> Once I made these changes seems to work the way I need it to,
> solving
>> the problem.
>>
>> So my question now is am I doing this right or is there a
> better way of
>> doing connection recovery with EJB3?
>>
>> Can I do it from the persistence.xml?
>>
>>
> ---------------------------------------------------------------------
> To
>> unsubscribe, e-mail: users-unsubscribe@... For
>> additional commands, e-mail: users-help@...
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@... For
> additional commands, e-mail: users-help@...
>
> --------------------------------------------------------------------- To
> unsubscribe, e-mail: users-unsubscribe@... For
> additional commands, e-mail: users-help@...