Alfresco on Linux box with Oracle

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
andybess
Member II

Alfresco on Linux box with Oracle

Hi all!

I installed Alfresco 1.1 on my Linux machine (SuSE 9.3) using JBoss bundle and made all modifications needed to run it with Oracle 10g. JBoss starts and I get the following error:

16:33:51,359 ERROR [JDBCExceptionReporter] ORA-01400: cannot insert NULL into ("VESDIA"."PERMISSION_REF"."TYPE_URI")

16:33:51,359 ERROR [JDBCExceptionReporter] ORA-01400: cannot insert NULL into ("VESDIA"."PERMISSION_REF"."TYPE_URI")

16:33:51,364 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
        at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:74)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:200)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:169)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2033)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2410)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:870)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:344)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:488)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:401)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:260)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:376)
        at org.alfresco.repo.version.VersionBootstrap.bootstrap(VersionBootstrap.java:95)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:971)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:941)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:334)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:222)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:146)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:277)
        at org.springframework.context.support.AbstractApplicationContext.
refresh(AbstractApplicationContext.java:310)

etc.

The database name is 'vesdia', Alfresco's schema name is 'alfresco'.

Does someone have any idea what's wrong?

Thanks.

Best,

Andy.
5 Replies
kevinr
Active Member II

Re: Alfresco on Linux box with Oracle

Hello,

There is a known problem with Oracle DB and Alfresco 1.1, it has been fixed in the nightly builds/SVN rev 1980.

Please see this topic: http://www.alfresco.org/forums/viewtopic.php?t=539#539

Cheers,

Kevin
andybess
Member II

Re: Alfresco on Linux box with Oracle

Thanks Kevin!

But I couldn't find the nightly builds on your site… Would you please give me the reference?

Thanks again.

Andy.
kevinr
Active Member II

Re: Alfresco on Linux box with Oracle

andybess
Member II

Re: Alfresco on Linux box with Oracle

Hi Kevin.

Tell me please when are you planning to release a new version with this Oracle issue fixed?

Thanks.

Andy.
kevinr
Active Member II

Re: Alfresco on Linux box with Oracle