[
https://issues.apache.org/jira/browse/SYNCOPE-232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13491342#comment-13491342
]
Colm O hEigeartaigh commented on SYNCOPE-232:
---------------------------------------------
Hi Francesco,
Thanks for looking in to this. I'm still getting the error. The difference
between the steps you have outlined and my deployment scenario, is that I am
using a datasource. Could you try with this to see if you can replicate the
error?
On Tomcat, I'm adding the following to $CATALINA_HOME/conf/context.xml:
<Resource name="jdbc/syncopeDataSource" auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
testOnBorrow="true" testOnReturn="true" validationQuery="SELECT 1"
validationInterval="30000"
maxActive="50" minIdle="2" maxWait="10000" initialSize="2"
removeAbandonedTimeout="20000"
removeAbandoned="true" logAbandoned="true" suspectTimeout="20000"
timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="5000"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="syncope_user" password="syncope_pass"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8"/>
<Manager pathname="" /> is uncommented and the "resource-ref" section in
'core/src/main/webapp/WEB-INF/web.xml' is uncommented.
Thanks,
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
