yes i got it resolved too and thanks for these links they are pretty useful .
T&R Harish Sharma On Oct 6, 2011, at 7:39 AM, Brett Porter wrote: 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<mailto:br...@apache.org> http://brettporter.wordpress.com/ http://au.linkedin.com/in/brettporter T&R Harish Sharma
