topic FirstFoundationClient and Oracle in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32482#M16871 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>I try to run the FirstFoundationClient from the SDK with an Oracle database but unfortunately I have a Oracle PK violation when trying to create the node . Here is the stack trace :</SPAN><BR /><BR /><SPAN>- ORA-01400: cannot insert NULL into ("ALFRESCO"."NODE"."ID")</SPAN><BR /><BR /><SPAN>Exception in thread "main" org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]; SQL [insert into node (protocol, identifier, uuid, type_qname, acl_id) values (?, ?, ?, ?, ?)]; ORA-01400: cannot insert NULL into ("ALFRESCO"."NODE"."ID")</SPAN><BR /><SPAN>; nested exception is java.sql.SQLException: ORA-01400: cannot insert NULL into ("ALFRESCO"."NODE"."ID")</SPAN><BR /><BR /><SPAN>java.sql.SQLException: ORA-01400: cannot insert NULL into ("ALFRESCO"."NODE"."ID")</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1976)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2405)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:615)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:612)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.newNode(HibernateNodeDaoServiceImpl.java:264)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy1.newNode(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.createNode(DbNodeServiceImpl.java:281)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy2.createNode(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:116)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy15.createNode(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.sample.FirstFoundationClient.doExample(FirstFoundationClient.java:108)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.sample.FirstFoundationClient$1.doWork(FirstFoundationClient.java:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:168)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:74)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:76)</SPAN><BR /><BR /><SPAN>I've seen that a similar issue used to exist in Alfresco 1.1 for instance, But I though it was supposed to be fixed (as I'm running v1.3)</SPAN><BR /><BR /><SPAN>Any ideas about this ?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>Philippe</SPAN></BODY></HTML> Wed, 09 Aug 2006 10:46:29 GMT pcuvecle 2006-08-09T10:46:29Z FirstFoundationClient and Oracle https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32482#M16871 Hi all,I try to run the FirstFoundationClient from the SDK with an Oracle database but unfortunately I have a Oracle PK violation when trying to create the node . Here is the stack trace :- ORA-01400: cannot insert NULL into ("ALFRESCO"."NODE"."ID")Exception in thread "main" org.springframework.dao. Wed, 09 Aug 2006 10:46:29 GMT https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32482#M16871 pcuvecle 2006-08-09T10:46:29Z Re: FirstFoundationClient and Oracle https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32483#M16872 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>This is not the same issue, which referred to Oracle forcing empty strings to be null values.</SPAN><BR /><BR /><SPAN>I'm going to guess that you're using the MySQL dialect.&nbsp; You'll need to make use of overrides (</SPAN><STRONG>config/alfresco/extensions</STRONG><SPAN>) or similar to change the Hibernate dialect (see </SPAN><STRONG>config/alfresco/domain/hibernate-cfg.properties</STRONG><SPAN>).</SPAN><BR /><BR /><SPAN>MySQL autogenerates the ID, whereas Hibernate has to use a sequence when inserting into Oracle.</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Tue, 05 Sep 2006 14:06:50 GMT https://connect.hyland.com/t5/alfresco-archive/firstfoundationclient-and-oracle/m-p/32483#M16872 derek 2006-09-05T14:06:50Z