org.springframework.jdbc.UncategorizedSQLException from planManager

[tkhduracell]

250: PlanKey target = PlanKeys.getJobKey(chain.getPlanKey(), test.key);

251: Job job = (Job) planManager.getPlanByKey(target);

Get PlanManager cast this error:

17-aug-2012 16:51:05	org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL []; SQL state [S1009]; error code [0]; Connection is read-only. Queries leading to data modification are not allowed; nested exception is java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
17-aug-2012 16:51:05	Caused by: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
17-aug-2012 16:51:05	        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1408)
17-aug-2012 16:51:05	        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:128)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:61)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:58)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.java:111)
17-aug-2012 16:51:05	        at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:454)
17-aug-2012 16:51:05	        at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2451)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2437)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2394)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1823)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3654)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
17-aug-2012 16:51:05	        at net.sf.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:385)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.plan.PlanHibernateDao$1.doInHibernate(PlanHibernateDao.java:58)
17-aug-2012 16:51:05	        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
17-aug-2012 16:51:05	        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.plan.PlanHibernateDao.getPlanByKey(PlanHibernateDao.java:54)
17-aug-2012 16:51:05	        at sun.reflect.GeneratedMethodAccessor193.invoke(Unknown Source)
17-aug-2012 16:51:05	        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
17-aug-2012 16:51:05	        at java.lang.reflect.Method.invoke(Unknown Source)
17-aug-2012 16:51:05	        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
17-aug-2012 16:51:05	        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
17-aug-2012 16:51:05	        at $Proxy17.getPlanByKey(Unknown Source)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.plan.PlanManagerImpl.getPlanByKey(PlanManagerImpl.java:89)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.plan.PlanManagerImpl.getPlanByKey(PlanManagerImpl.java:83)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.plan.PlanManagerImpl.getPlanByKey(PlanManagerImpl.java:136)
17-aug-2012 16:51:05	        at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
17-aug-2012 16:51:05	        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
17-aug-2012 16:51:05	        at java.lang.reflect.Method.invoke(Unknown Source)
17-aug-2012 16:51:05	        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
17-aug-2012 16:51:05	        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
17-aug-2012 16:51:05	        at $Proxy21.getPlanByKey(Unknown Source)
17-aug-2012 16:51:05	        at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
17-aug-2012 16:51:05	        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
17-aug-2012 16:51:05	        at java.lang.reflect.Method.invoke(Unknown Source)
17-aug-2012 16:51:05	        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.security.acegi.intercept.aopalliance.AuthorityOverrideMethodSecurityInterceptor.invoke(AuthorityOverrideMethodSecurityInterceptor.java:29)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.security.acegi.intercept.aopalliance.AuthorityOverrideMethodSecurityInterceptor.invoke(AuthorityOverrideMethodSecurityInterceptor.java:29)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
17-aug-2012 16:51:05	        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
17-aug-2012 16:51:05	        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
17-aug-2012 16:51:05	        at $Proxy21.getPlanByKey(Unknown Source)
17-aug-2012 16:51:05	        at tasks.testcreatortask.TestCreatorTask.addJobs(TestCreatorTask.java:251)
17-aug-2012 16:51:05	        at tasks.testcreatortask.TestCreatorTask.execute(TestCreatorTask.java:89)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.task.TaskExecutorImpl.executeTasks(TaskExecutorImpl.java:183)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.task.TaskExecutorImpl.execute(TaskExecutorImpl.java:91)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.build.pipeline.tasks.ExecuteBuildTask.call(ExecuteBuildTask.java:84)
17-aug-2012 16:51:05	        at sun.reflect.GeneratedMethodAccessor449.invoke(Unknown Source)
17-aug-2012 16:51:05	        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
17-aug-2012 16:51:05	        at java.lang.reflect.Method.invoke(Unknown Source)
17-aug-2012 16:51:05	        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
17-aug-2012 16:51:05	        at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
17-aug-2012 16:51:05	        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
17-aug-2012 16:51:05	        at $Proxy667.call(Unknown Source)
17-aug-2012 16:51:05	        at sun.reflect.GeneratedMethodAccessor449.invoke(Unknown Source)
17-aug-2012 16:51:05	        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
17-aug-2012 16:51:05	        at java.lang.reflect.Method.invoke(Unknown Source)
17-aug-2012 16:51:05	        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
17-aug-2012 16:51:05	        at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:117)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
17-aug-2012 16:51:05	        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
17-aug-2012 16:51:05	        at $Proxy668.call(Unknown Source)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.v2.build.agent.DefaultBuildAgent.build(DefaultBuildAgent.java:204)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl.waitAndPerformBuild(BuildAgentControllerImpl.java:103)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.v2.build.agent.DefaultBuildAgent$1.run(DefaultBuildAgent.java:109)
17-aug-2012 16:51:05	        at com.atlassian.bamboo.build.pipeline.concurrent.NamedThreadFactory$2.run(NamedThreadFactory.java:50)
17-aug-2012 16:51:05	        at java.lang.Thread.run(Unknown Source)

[tkhduracell · Accepted solution]

This was due to a bug in the MySql-connector, problem was avoided bu changing to MsSql.