[OAK-8237] Unable to run Apache OAK with mySQL as backing store.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 1.9.8
• Component/s: rdbmk
• Labels: mysql oak rdb
• Assignee: Unassigned
• Reporter: Vishnu Aggarwal
• Created: 15/Apr/19 04:41
• Updated: 27/May/19 11:37
• Resolved: 27/May/19 11:37

Description

I am running a Grails 3.3.5 application with Apache OAK 1.9.8. When I use mySQL(v 5.7) as the backing node store, the application fails to boot-up.

I used org.apache.jackrabbit.oak.plugins.document.rdb.RDBDocumentNodeStoreBuilder to create the repository object. 

At that moment, I get the following exception,

 

java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed. 

This is issue comes even when I have specifically checked that the connection is in write mode and even explicitly opened the connection in write mode.