[
https://issues.apache.org/jira/browse/SYNCOPE-232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13490969#comment-13490969
]
Francesco Chicchiriccò commented on SYNCOPE-232:
------------------------------------------------
Colm,
I am not able to reproduce this issue; here it follows what I did.
1. "mvn -P all clean install" on branch 1_0_X sources - this because the hotel
connection isn't particularly good, but I don't think is relevant
2. "mvn archetype:generate -DarchetypeGroupId=org.apache.syncope
-DarchetypeArtifactId=syncope-archetype
-DarchetypeRepository=file:///home/ilgrosso/.m2/repository
-DarchetypeVersion=1.0.4-incubating-SNAPSHOT" - for creating a sample project
3. added MySQL JDBC connector in core/pom.xml:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.21</version>
</dependency>
4. replaced core/src/main/resources/persistence.properties with [1]
5. changed port from 9080 to 8080 in
console/src/main/resources/configuration.properties
6. "mvn clean package"
7. deployed core/target/syncope.war and console/target/syncope-console.war to
Tomcat
8. started Tomcat, logged in to admin console, then created a connector (CSV),
a resource and a synchronization task (with schedule).
No failures.
I've also repeated all the steps above using PostgreSQL; same results.
Colm, could you please try to create a fresh environment like in the above
steps? I suspect it might be something relating to upgrading from one version
to another.
[1]
https://svn.apache.org/repos/asf/incubator/syncope/branches/1_0_X/core/src/test/resources/mysql/persistence.properties
> "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
