You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@archiva.apache.org by Brett Porter <br...@apache.org> on 2011/10/06 04:09:12 UTC
Re: javax.jdo.JDODataStoreException:
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
brett@apache.org
http://brettporter.wordpress.com/
http://au.linkedin.com/in/brettporter
Re: javax.jdo.JDODataStoreException:
Posted by Harish Sharma <ha...@yahoo-inc.com>.
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
brett@apache.org<ma...@apache.org>
http://brettporter.wordpress.com/
http://au.linkedin.com/in/brettporter
T&R
Harish Sharma