Did you get this resolved too? Looks like a mysql specific issue, but there is some JPOX configuration regarding read-committed that could be tweaked.
On 30/09/2011, at 7:01 PM, Harish Sharma wrote: > > Hi, > I am using archiva 1.3.5 with tomcat 6.0 and using MYSQL as database but > getting this error : > Initialization of bean failed; nested exception is > javax.jdo.JDODataStoreException: Insert request failed: INSERT INTO > `SECURITY_RESOURCES` (`PATTERN`,`PERMANENT`,`IDENTIFIER`) VALUES (?,?,?) > NestedThrowables: > java.sql.SQLException: Binary logging not possible. Message: Transaction > level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT' > at > org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:127) > at java.security.AccessController.doPrivileged(Native Method) > at > org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:116) > at > org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:91) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1288) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:275) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) > at > org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) > ... 48 more > I figured out that error is with MYSQL . > > I can not exactly what is causing this error and how to remove this. > I verified my database is good ( used DB visualizer ) > Any help is deeply appreciated . > > T&R > Harish Sharma -- Brett Porter br...@apache.org http://brettporter.wordpress.com/ http://au.linkedin.com/in/brettporter
