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]> Sykes Development Ltd http://www.sykesdevelopment.com