[
https://issues.apache.org/jira/browse/SYNCOPE-232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13490735#comment-13490735
]
Colm O hEigeartaigh edited comment on SYNCOPE-232 at 11/5/12 5:09 PM:
----------------------------------------------------------------------
This bug still exists on the 1_0_X branch. My setup is a deployment in Apache
Tomcat with a MySQL DataSource. If I try to create a Synchronization task, I
get a "read-only" error.
org.quartz.JobPersistenceException: Couldn't remove trigger: Connection is
read-only. Queries leading to data modification are not allowed {prepstmnt
1004087995 DELETE FROM QRTZ_SIMPLE_TRIGGERS WHERE TRIGGER_NAME = ? AND
TRIGGER_GROUP = ?} [code=0, state=S1009]
...
at org.quartz.impl.StdScheduler.unscheduleJob(StdScheduler.java:290)
~[quartz-1.8.6.jar:na]
at
org.apache.syncope.core.init.JobInstanceLoader.unregisterJob(JobInstanceLoader.java:196)
[JobInstanceLoader.class:na]
at
org.apache.syncope.core.init.JobInstanceLoader.registerJob(JobInstanceLoader.java:135)
[JobInstanceLoader.class:na]
at
org.apache.syncope.core.init.JobInstanceLoader.registerJob(JobInstanceLoader.java:182)
[JobInstanceLoader.class:na]
Colm.
was (Author: coheigea):
This bug still exists on the 1_0_X branch. My setup is a deployment in Apache
Tomcat with a MySQL DataSource. If I try to create a Synchronization task, I
get a "read-only" error.
Colm.
> "Connection is read-only" during initialization
> -----------------------------------------------
>
> Key: SYNCOPE-232
> URL: https://issues.apache.org/jira/browse/SYNCOPE-232
> Project: Syncope
> Issue Type: Bug
> Components: core
> Affects Versions: 1.0.2-incubating, 1.0.3-incubating
> Environment: MySQL
> Reporter: Francesco Chicchiriccò
> Assignee: Francesco Chicchiriccò
> Fix For: 1.0.4-incubating, 1.1.0
>
>
> During initialization, when MySQL is used, a set of exceptions are thrown
> like as:
> ...
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Connection is
> read-only. Queries leading to data modification are not allowed
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
