Where to place a sqlInitFile

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

0 votes

1 answers

882 views

ANSWER



If I'm not mistaken the SQL init file should be placed at the root of the JAR if you only specify a filename in the <sqlInit> element.

0 votes