I have no idea where to start with this. To lower the timeout in your my.ini add the line
max_timeout=integer in seconds if this isn't specified, mysql assumes 28800 (60 seconds * 60 minutes* 8 hours) --- Andrew Sykes <[EMAIL PROTECTED]> wrote: > Chris, Jonathon, > > Thanks for the info. > > Is there a Jira issue for this? this definitely needs fixed, if > someone > can give thorough instructions for reproducing (without waiting 8 > hours) > and any thoughts on a solution in Jira, I'll try to look at this next > week. > > - Andrew > > > On Fri, 2007-03-02 at 23:17 +0800, Jonathon -- Improov wrote: > > Chris is right, it's deprecated. > > > > I was mistaken, autoReconnect didn't solve my problems. I used > attribute "validationQuery". Works > > even with autoCommit false. Does OFBiz have something similar? Or > is it too MySQL-specific? > > > > Jonathon > > > > Chris Howe wrote: > > > Autoreconnect was marked deprecated in mysql's Connector/J (jdbc) > in > > > 3.2 and removed in 3.3 > > > > > > Jonathon is likely using 3.1.14 > > > > > > I have very little interest or experience in database features > and > > > couldn't tell you if what comes along in Connector/J 5 is worth > the > > > change or necessary or anything else, except to tell you that > > > Connector/J 5 is recommended to use with MySql 5. This is > another > > > reason I'm switching to Postgres (at least for the ERP work). > There > > > seems to be more people that might have an interest/experience in > these > > > details using Postgres around in the OFBiz community, so any > issues > > > will likely be uncovered before my deployment is affected by it > :) > > > > > > --- Jonathon -- Improov <[EMAIL PROTECTED]> wrote: > > > > > >> Andrew, > > >> > > >> I can confirm 2 things: > > >> > > >> 1. I tested "autoReconnect=true" to work in Tomcat deployment > (not > > >> OFBiz); will > > >> get "Communication link failure" after timeout (8 hours in > my > > >> setup) > > >> otherwise. > > >> > > >> 2. I have never had a similar timeout incident with OFBiz; I'm > using > > >> "autoReconnect=true" and MySQL. > > >> > > >> Jonathon > > >> > > >> Andrew Sykes wrote: > > >>> Chris, > > >>> > > >>> I thought the timeout issue was resolved by adding the "? > > >>> autoReconnect=true" to the jdbc-uri? > > >>> > > >>> Interested to hear more... > > >>> > > >>> - Andrew > > >>> > > >>> On Thu, 2007-03-01 at 15:43 -0800, Chris Howe wrote: > > >>>> Hey Eric, > > >>>> > > >>>> The only technical reason so far was the issue with > max_timeout. > > >> A > > >>>> default installation connection will timeout after 8 hours of > > >>>> inactivity and may cause some problems with misses after that > 8 > > >> hours. > > >>>> You can change this to up to 24 days which should alleviate > some > > >>>> issues, but I'm not sure how extensive a test I can do to see > if > > >> there > > >>>> are any repercussions from doing that. I'm also not sure > there's > > >> much > > >>>> momentum to address the issue any time soon. I know I don't > have > > >> any > > >>>> momentum in learning about it. Issues that pop up regarding > > >> Postgres > > >>>> specifically, I think would garner a bit more attention. > > >>>> > > >>>> Licensing issues were the main driving force though. After > > >> reading up > > >>>> a bit there just seems to be quite a bit of uncertainty > > >> surrounding > > >>>> MySql licensing most of it can be gleaned by reading: > > >>>> http://en.wikipedia.org/wiki/MySQL#License_issues > > >>>> I'd prefer to not worry about what Oracle and SAP are doing to > > >> each > > >>>> other. > > >>>> > > >>>> Postgres being BSD and originating from University of > California > > >> seems > > >>>> a bit safer on the legal front. We've see a lot of > opportunity > > >> using > > >>>> OFBiz in our industry and may wish to do something in the > future > > >> and > > >>>> want to expand our knowledge in areas that keep our options > open. > > >>>> > > >>>> ,Chris > > >>>> > > >>>> --- Eric Crawford <[EMAIL PROTECTED]> wrote: > > >>>> > > >>>>> Chris, just out of curiosity, what made you decide to move > from > > >> mysql > > >>>>> to postgres? > > >>>>> > > >>>>> On 3/1/07, Chris Howe <[EMAIL PROTECTED]> wrote: > > >>>>>> The error is most likely on this side of the keyboard, but > the > > >>>>>> dummy-fks didn't work for me going from mysql to postgres. > Even > > >>>>> with > > >>>>>> it ticked, postgres got mad about referential integrity. I > > >> didn't > > >>>>> dig > > >>>>>> into it any further, that's going to be one of the things I > do > > >> look > > >>>>>> into when i set aside some time. > > >>>>>> > > >>>>>> I'm just thinking abstractly, wouldn't something like the > > >> following > > >>>>>> work for writing to the correct order > > >>>>>> > > >>>>>> Start with a HashSet > > >>>>>> > > >>>>>> Get Record > > >>>>>> If has parent > > >>>>>> get parent > > >>>>>> Is parent in Hashset? > > >>>>>> yes->write record > > >>>>>> no-> does parent have parent? > > >>>>>> ..etc > > >>>>>> If does not have parent > > >>>>>> write record > > >>>>>> > > >>>>>> > > >>>>>> --- "David E. Jones" <[EMAIL PROTECTED]> wrote: > > >>>>>> > > >>>>>>> On Mar 1, 2007, at 1:57 PM, Chris Howe wrote: > > >>>>>>> > > >>>>>>>> 2. Data write/load order for hierarchy fk integrity > (parent*Id > > >>>>> -> > > >>>>>>> *Id) > > >>>>>>> > > >>>>>>>> I think 2 can be addressed pretty well (of course not 100% > > >> fool > > >>>>>>> proof) > > >>>>>>>> if the output file is written in the right order. > > >>>>>>> This is actually not possible to do, ie sorting a graph > with > > >>>>> loops is > > >>>>>>> NP-hard. > > >>>>>>> > > >>>>>>> That is why we have the dummy-fks thing, which of course > should > > >>>>> ONLY > > >>>>>>> be used for a case like this where you are sure that there > are > > >> no > > >>>>> bad > > >>>>>>> fk records. > > >>>>>>> > > >>>>>>> -David > > >>>>>>> > > >>>>>>> > > >> > > > > > > > > > -- > Kind Regards > Andrew Sykes <[EMAIL PROTECTED]> > === message truncated ===