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 >
