Thanks Jacques, I was looking for a place for it last time around and didn't want to get in the way of the moving effort.
It can be found here http://docs.ofbiz.org/x/-QM I'll be sure to update it if/when a more complete solution is found. --- Jacques Le Roux <[EMAIL PROTECTED]> wrote: > Chris, > > BTW you may put this *important* (and seemingly > reccurring) autoreconnect MySQL 5.0+ tip in the > SandBox for the moment : > http://docs.ofbiz.org/display/OFBIZ/Sandbox > > And thanks for all your great and accurate help for > users (and even devs ;o) ! > > Jacques > > ----- Original Message ----- > From: "Chris Howe" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Friday, January 12, 2007 10:19 PM > Subject: Re: Sluggish server / Minerva exception > > > > Two issues there... > > SVN: You likely checked out using > > svn.ofbiz.org/svn/ofbiz/trunk which is the old > > repository. The new svn repository is at > > http://svn.apache.org/viewvc/ofbiz/ > > > > (OFBiz SVN has been off Minerva for nearly a year > now) > > > > The second issue, if you're using MySQL 5.0+, the > auto > > reconnect attribute was deprecated as a security > > feature and so MySql will close the connection > after 8 > > hours of inactivity. For a work around please see > > this recent discussion. > > > > > http://www.nabble.com/forum/ViewPost.jtp?post=8213433&framed=y > > > > > > --- John Martin <[EMAIL PROTECTED]> wrote: > > > > > We have an ofBiz application server that is > running > > > in a staging/demo > > > environment that gets little usage. In December > I > > > updated the source code > > > via subversion from the trunk so the code is > fairly > > > up to date. The > > > application starts out around 100MB but just > sitting > > > there grows to approx > > > 300MB of memory over time under very lite loads. > It > > > is accessing a mySQL > > > database. I noticed today that when I went to > login > > > to the application it > > > was extremely slow. After restarting the ofBiz > > > application the performance > > > issue went away. > > > > > > I looked into the ofbiz.log file and noticed an > > > exception / error "There was > > > an error getting a Minerva datasource". I don't > > > know if this is the cause > > > of the performance issues or not but started > going > > > down this path since the > > > error was specific to the login: > > > > > > ========================= > > > > > > 2007-01-12 14:56:19,025 (RMI TCP > > > Connection(34512)-192.168.1.3) [ > > > ConnectionFactory.java:82 :ERROR] > > > ---- runtime exception report > > > > -------------------------------------------------- > > > There was an error getting a Minerva datasource. > > > Exception: java.lang.RuntimeException > > > Message: No ManagedConnections Available! > > > ---- stack trace > > > > > > --------------------------------------------------------------- > > > java.lang.RuntimeException: No > ManagedConnections > > > Available! > > > > > > org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:655) > > > > > > org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection( > > > XAPoolDataSource.java:355) > > > > > > org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection( > > > MinervaConnectionFactory.java:43) > > > > > > org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources( > > > ConnectionFactory.java:79) > > > > > > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection( > > > GeronimoTransactionFactory.java:97) > > > > > > ..... > > > > > > ConnectionFactory.java:71 :ERROR] ******* ERROR: > No > > > database connection > > > found for helperName "localmysql" > > > > > > 2007-01-12 14:56:19,025 (RMI TCP > > > Connection(34512)-192.168.1.3) [ > > > GenericDelegator.java:574:ERROR] > > > > > > ---- exception report > > > > > > ---------------------------------------------------------- > > > Failure in create operation for entity > > > [UserLoginHistory]: > > > org.ofbiz.entity.GenericEntityException: > Exception > > > while inserting the > > > following entity: > > > > > > [GenericEntity:UserLoginHistory][createdStamp,2007-01-12 > > > > > > 14:55:59.025(java.sql.Timestamp)][createdTxStamp,2007-01-12 > > > > > > ========================= > > > In doing some research, I found that Minerva > was > > > replaced with Geronimo > > > back in Jun 06 so I was surprised and confused > > > seeing this exception. I > > > don't know if there is some configuration in my > > > environment that is messed > > > up and therefore still using Minerva > erroneously? > > > > > > Any thoughts? > > > > > > Thanks - John > > > > >
