You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Jonathon -- Improov <jo...@improov.com> on 2007/04/13 06:34:18 UTC
No source code provided for ofbiz-minerva.jar?
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
Re: No source code provided for ofbiz-minerva.jar?
Posted by Jonathon -- Improov <jo...@improov.com>.
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
>>
>
Re: No source code provided for ofbiz-minerva.jar?
Posted by "David E. Jones" <jo...@hotwaxmedia.com>.
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
>
Re: No source code provided for ofbiz-minerva.jar?
Posted by Jonathon -- Improov <jo...@improov.com>.
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
>
Re: No source code provided for ofbiz-minerva.jar?
Posted by "David E. Jones" <jo...@hotwaxmedia.com>.
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