No source code provided for ofbiz-minerva.jar?

[jonwimp]

The fix to support validationQuery could be done in ofbiz-minerva.jar. Is the source code
provided, or do we have to roll our own if we want things fixed or enhanced?

The validationQuery feature refreshes timed out connections in a DBCP. Timing out inactive
connections in a DBCP is common and correct behavior in RDBMSes, to prevent resource hogs.

This issue is related to any RDBMS that times out inactive connections after a set interval of
inactivity, not just MySQL.

OT: Does PostgreSQL not time out inactive connections?

Jonathon

[David E Jones]

Because of licensing issues we can't include the minerva source code  
in the ASF repository for OFBiz. It is, however, in the old SVN  
repository that is now hosted by Contegix and Hotwax. For details on  
that repo see the SVN details page here:

http://docs.ofbiz.org/x/mgM

Our real hope is that eventually we'll find a stand alone (or plug-
able) TX aware connection pool and replace Minerva. There aren't any  
that we've found yet in the open source world with a compatible  
license. The last time research was done on this was last summer when  
I did the work to replace the transaction manager (JTA impl). At that  
time I also researched and tried out a few connection pools with no  
good results.

-David


On Apr 12, 2007, at 10:34 PM, Jonathon -- Improov wrote:

> The fix to support validationQuery could be done in ofbiz-
> minerva.jar. Is the source code provided, or do we have to roll our  
> own if we want things fixed or enhanced?
>
> The validationQuery feature refreshes timed out connections in a  
> DBCP. Timing out inactive connections in a DBCP is common and  
> correct behavior in RDBMSes, to prevent resource hogs.
>
> This issue is related to any RDBMS that times out inactive  
> connections after a set interval of inactivity, not just MySQL.
>
> OT: Does PostgreSQL not time out inactive connections?
>
> Jonathon

[jonwimp]

David,

So the XAPoolDatasource is not OFBiz code? (Along with XAConnectionImpl and such.)

How feasible do you think it'll be to implement our own? After all, the XAPoolDatasource seems to
be quite small.

I've done DBCPs before, multi-threaded. Do you think I can do it, or is there something more about
DBCPs I'm not yet aware of?

Jonathon

David E. Jones wrote:

>
> Because of licensing issues we can't include the minerva source code in
> the ASF repository for OFBiz. It is, however, in the old SVN repository
> that is now hosted by Contegix and Hotwax. For details on that repo see
> the SVN details page here:
>
> http://docs.ofbiz.org/x/mgM
>
> Our real hope is that eventually we'll find a stand alone (or plug-able)
> TX aware connection pool and replace Minerva. There aren't any that
> we've found yet in the open source world with a compatible license. The
> last time research was done on this was last summer when I did the work
> to replace the transaction manager (JTA impl). At that time I also
> researched and tried out a few connection pools with no good results.
>
> -David
>
>
> On Apr 12, 2007, at 10:34 PM, Jonathon -- Improov wrote:
>
>> The fix to support validationQuery could be done in ofbiz-minerva.jar.
>> Is the source code provided, or do we have to roll our own if we want
>> things fixed or enhanced?
>>
>> The validationQuery feature refreshes timed out connections in a DBCP.
>> Timing out inactive connections in a DBCP is common and correct
>> behavior in RDBMSes, to prevent resource hogs.
>>
>> This issue is related to any RDBMS that times out inactive connections
>> after a set interval of inactivity, not just MySQL.
>>
>> OT: Does PostgreSQL not time out inactive connections?
>>
>> Jonathon
>

[David E Jones]

There is a little bit more to it than multi-threaded... the tough  
parts are usually the transaction aware connection pool, especially  
supporting distributed transactions and two phase commits and such.

Still, all of the source code is there on the other server. It's not  
technically part of Apache OFBiz, but it is code that we maintain  
over on the svn.ofbiz.org server.

-David


On Apr 13, 2007, at 8:48 PM, Jonathon -- Improov wrote:

> David,
>
> So the XAPoolDatasource is not OFBiz code? (Along with  
> XAConnectionImpl and such.)
>
> How feasible do you think it'll be to implement our own? After all,  
> the XAPoolDatasource seems to be quite small.
>
> I've done DBCPs before, multi-threaded. Do you think I can do it,  
> or is there something more about DBCPs I'm not yet aware of?
>
> Jonathon
>
> David E. Jones wrote:
>> Because of licensing issues we can't include the minerva source  
>> code in the ASF repository for OFBiz. It is, however, in the old  
>> SVN repository that is now hosted by Contegix and Hotwax. For  
>> details on that repo see the SVN details page here:
>> http://docs.ofbiz.org/x/mgM
>> Our real hope is that eventually we'll find a stand alone (or plug-
>> able) TX aware connection pool and replace Minerva. There aren't  
>> any that we've found yet in the open source world with a  
>> compatible license. The last time research was done on this was  
>> last summer when I did the work to replace the transaction manager  
>> (JTA impl). At that time I also researched and tried out a few  
>> connection pools with no good results.
>> -David
>> On Apr 12, 2007, at 10:34 PM, Jonathon -- Improov wrote:
>>> The fix to support validationQuery could be done in ofbiz-
>>> minerva.jar. Is the source code provided, or do we have to roll  
>>> our own if we want things fixed or enhanced?
>>>
>>> The validationQuery feature refreshes timed out connections in a  
>>> DBCP. Timing out inactive connections in a DBCP is common and  
>>> correct behavior in RDBMSes, to prevent resource hogs.
>>>
>>> This issue is related to any RDBMS that times out inactive  
>>> connections after a set interval of inactivity, not just MySQL.
>>>
>>> OT: Does PostgreSQL not time out inactive connections?
>>>
>>> Jonathon
>

[jonwimp]

David,

Ok, I'll try to pull the source codes from that server and fix it up instead.

I suppose the XAPoolDatasource is transaction-aware? Does the XAPoolDatasource do distributed
transactions? Yes, that is hard to test, let alone implement.

Jonathon

David E. Jones wrote:

>
> There is a little bit more to it than multi-threaded... the tough parts
> are usually the transaction aware connection pool, especially supporting
> distributed transactions and two phase commits and such.
>
> Still, all of the source code is there on the other server. It's not
> technically part of Apache OFBiz, but it is code that we maintain over
> on the svn.ofbiz.org server.
>
> -David
>
>
> On Apr 13, 2007, at 8:48 PM, Jonathon -- Improov wrote:
>
>> David,
>>
>> So the XAPoolDatasource is not OFBiz code? (Along with
>> XAConnectionImpl and such.)
>>
>> How feasible do you think it'll be to implement our own? After all,
>> the XAPoolDatasource seems to be quite small.
>>
>> I've done DBCPs before, multi-threaded. Do you think I can do it, or
>> is there something more about DBCPs I'm not yet aware of?
>>
>> Jonathon
>>
>> David E. Jones wrote:
>>> Because of licensing issues we can't include the minerva source code
>>> in the ASF repository for OFBiz. It is, however, in the old SVN
>>> repository that is now hosted by Contegix and Hotwax. For details on
>>> that repo see the SVN details page here:
>>> http://docs.ofbiz.org/x/mgM
>>> Our real hope is that eventually we'll find a stand alone (or
>>> plug-able) TX aware connection pool and replace Minerva. There aren't
>>> any that we've found yet in the open source world with a compatible
>>> license. The last time research was done on this was last summer when
>>> I did the work to replace the transaction manager (JTA impl). At that
>>> time I also researched and tried out a few connection pools with no
>>> good results.
>>> -David
>>> On Apr 12, 2007, at 10:34 PM, Jonathon -- Improov wrote:
>>>> The fix to support validationQuery could be done in
>>>> ofbiz-minerva.jar. Is the source code provided, or do we have to
>>>> roll our own if we want things fixed or enhanced?
>>>>
>>>> The validationQuery feature refreshes timed out connections in a
>>>> DBCP. Timing out inactive connections in a DBCP is common and
>>>> correct behavior in RDBMSes, to prevent resource hogs.
>>>>
>>>> This issue is related to any RDBMS that times out inactive
>>>> connections after a set interval of inactivity, not just MySQL.
>>>>
>>>> OT: Does PostgreSQL not time out inactive connections?
>>>>
>>>> Jonathon
>>
>