no ddl VCS configuration not working in nuxeo EP 5.5
I first started Nuxeo 5.5 EP with my oracle database configured with OWNER rights. Then I wanted to connect it with USER rights, USER has synonyms so USER does not have rights to CREATE table.
All the tables are there in database, but when I started the nuxeo server it gave me errors like the following:
2012-05-07 08:00:28,691 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table RECM_USER.NXP_LOGS (LOG_ID integer not null, LOG_EVENT_CATEGORY varchar2(255 char), LOG_EVENT_COMMENT varchar2(1024 char), LOG_DOC_LIFE_CYCLE varchar2(255 char), LOG_DOC_PATH varchar2(1024 char), LOG_DOC_TYPE varchar2(255 char), LOG_DOC_UUID varchar2(255 char), LOG_EVENT_DATE timestamp, LOG_EVENT_ID varchar2(255 char) not null, LOG_PRINCIPAL_NAME varchar2(255 char), LOG_REPO_ID varchar2(255 char), primary key (LOG_ID)) 2012-05-07 08:00:28,691 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] ORA-01031: insufficient privileges
I referred to this: http://doc.nuxeo.com/display/ADMINDOC/VCS+Configuration
and set the
but nuxeo server again tries to create tables; and the errors persists.
Where am I wrong..
<noDDL>
only controls VCS, but given the error message you show your problem comes from Hibernate.
In any case if you want a kind of “noDDL” for hibernate you still must create the tables by hand before starting Nuxeo, it needs them.
How did you set noDDL to true: which file(s) did you change?
Did you precisely write <noDDL>
and not <noddl>
(in lowercase)?
Note with INFO level on “org.nuxeo.ecm.core.storage.sql.jdbc”, if no DDL was properly set, you would see a log line stating that JDBCBackend is “Skipping database creation”.
Thats my default-repository-config.xml file in templates/oracle as I have specified template = oracle in nuxeo.conf file.
<code> <?xml version="1.0"?> <component name="default-repository-config"> <extension target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="default"
factory="org.nuxeo.ecm.core.storage.sql.ra.PoolingRepositoryFactory">
<repository name="default">
<clustering enabled="${repository.clustering.enabled}" delay="${repository.clustering.delay}" />
<binaryStore path="${repository.binary.store}" />
<binaryManager class="org.nuxeo.ecm.core.storage.sql.XORBinaryManager" key="test"/>
<schema>
<field type="largetext">note</field>
<field type="largetext">relatedtext</field>
<field type="largetext">webp:content</field>
<field type="largetext">webc:welcomeText</field>
<field type="largetext">comment:comment</field>
<field type="largetext">post</field>
<field type="largetext">mail:mail</field>
</schema>
<indexing>
<fulltext>
<index name="default">
<!-- all props implied -->
</index>
<index name="title">
<field>dc:title</field>
</index>
<index name="description">
<field>dc:description</field>
</index>
</fulltext>
</indexing>
<xa-datasource>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource>
<property name="URL">jdbc:oracle:thin:@${nuxeo.db.host}:${nuxeo.db.port}:${nuxeo.db.name}
</property>
<property name="User">${nuxeo.db.user}</property>
<property name="Password">${nuxeo.db.password}</property>
<noDDL>true</noDDL>
</repository>
</repository>
</extension> </component> </code>
2012-05-08 07:22:07,164 INFO [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCBackend] Skipping database creation