Hi members,
I followed this: http://doc.nuxeo.com/display/ADMINDOC/VCS+Configuration and I added the proper sentence in the default-repository-config.xml to load my own sqlInitFile (mods.sql.txt in this case).
I've to add some SQL statements to create some stored procedures we need in our Nuxeo Platform. One is a modified version of nx_update_read_acls. I prefer to add a new txt with these statements and do not modify the sqlserver.sql.txt in nuxeo-core-storage-sql-6.0.jar.
I've added the txt (mods.sql.txt) to the nuxeo-core-storage-sql-6.0.jar in the proper subfolder, and when I restart Nuxeo I get errores in the server.log:
org.nuxeo.ecm.core.storage.StorageException: java.io.IOException: Cannot open: mods.sql.txt
at org.nuxeo.ecm.core.storage.sql.jdbc.SQLInfo.<init>(SQLInfo.java:153)
at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend.initializeModel(JDBCBackend.java:189)
at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.initRepository(RepositoryImpl.java:309)
at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection(RepositoryImpl.java:292)
at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryImpl.initialize(ManagedConnectionFactoryImpl.java:291)
at org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:186)
at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:49)
at org.apache.geronimo.connector.outbound.XAResourceInsertionInterceptor.getConnection(XAResourceInsertionInterceptor.java:41)
Where do I have to place this SQL txt?
Thank you,
Gabriel
