topic Alfresco SDK Example in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-sdk-example/m-p/281661#M234791 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I have just started with Alfresco SDK 4.0.d. My question is while running the FirstFoundationClient.java code I get with following exception</SPAN><BR /><BR /><SPAN>Feb 22, 2013 10:56:01 AM org.activiti.engine.impl.ProcessEngineImpl &lt;init&gt;</SPAN><BR /><SPAN>INFO: ProcessEngine default created</SPAN><BR /><SPAN>Feb 22, 2013 10:56:09 AM org.activiti.engine.impl.ProcessEngineImpl &lt;init&gt;</SPAN><BR /><SPAN>INFO: ProcessEngine activitiBootstrapEngine created</SPAN><BR /><SPAN>Feb 22, 2013 10:56:09 AM org.activiti.engine.impl.jobexecutor.JobAcquisitionThread run</SPAN><BR /><SPAN>INFO: JobAcquisitionThread starting to acquire jobs</SPAN><BR /><SPAN>Exception in thread "main" org.alfresco.error.AlfrescoRuntimeException: 01220000 Workflow deployment failed</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:347)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer$1.doWork(WorkflowDeployer.java:465)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer.onBootstrap(WorkflowDeployer.java:461)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:139)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:93)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.BaseApplicationContextHelper.getApplicationContext(BaseApplicationContextHelper.java:67)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:46)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.sample.FirstFoundationClient.main(FirstFoundationClient.java:63)</SPAN><BR /><SPAN>Caused by: org.springframework.jdbc.BadSqlGrammarException: </SPAN><BR /><SPAN>### Error querying database.&nbsp; Cause: org.postgresql.util.PSQLException: ERROR: column node.node_deleted does not exist</SPAN><BR /><SPAN>&nbsp; Position: 420</SPAN><BR /><SPAN>### The error may involve alfresco.node.select_NodeByNodeRef-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### Cause: org.postgresql.util.PSQLException: ERROR: column node.node_deleted does not exist</SPAN><BR /><SPAN>&nbsp; Position: 420</SPAN><BR /><SPAN>; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column node.node_deleted does not exist</SPAN><BR /><SPAN>&nbsp; Position: 420</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy2.selectOne(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:154)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.ibatis.NodeDAOImpl.selectNodeByNodeRef(NodeDAOImpl.java:408)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$NodesCacheCallbackDAO.findByValue(AbstractNodeDAOImpl.java:886)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl$NodesCacheCallbackDAO.findByValue(AbstractNodeDAOImpl.java:842)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.cache.lookup.EntityLookupCache.getByValue(EntityLookupCache.java:396)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.getNodePair(AbstractNodeDAOImpl.java:946)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.getNodePairNotNull(DbNodeServiceImpl.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1677)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1664)</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:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:104)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy4.getChildAssocs(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:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy5.getChildAssocs(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:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.TagScopePropertyMethodInterceptor.invoke(TagScopePropertyMethodInterceptor.java:152)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:305)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.TagScopePropertyMethodInterceptor.invoke(TagScopePropertyMethodInterceptor.java:152)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tagging.TagScopePropertyMethodInterceptor.invoke(TagScopePropertyMethodInterceptor.java:152)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:305)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:305)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:269)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy4.getChildAssocs(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.resolveQNamePath(DictionaryRepositoryBootstrap.java:656)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.getNodes(DictionaryRepositoryBootstrap.java:446)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.onDictionaryInit(DictionaryRepositoryBootstrap.java:253)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryDAOImpl.initDictionaryRegistry(DictionaryDAOImpl.java:261)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryDAOImpl.access$000(DictionaryDAOImpl.java:58)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryDAOImpl$1.doWork(DictionaryDAOImpl.java:207)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryDAOImpl$1.doWork(DictionaryDAOImpl.java:202)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryDAOImpl.initDictionary(DictionaryDAOImpl.java:201)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryDAOImpl.getDictionaryRegistry(DictionaryDAOImpl.java:1046)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryDAOImpl.getCompiledModels(DictionaryDAOImpl.java:1142)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryDAOImpl.getCompiledModels(DictionaryDAOImpl.java:862)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryDAOImpl.getModels(DictionaryDAOImpl.java:791)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryBootstrap.onDictionaryInit(DictionaryBootstrap.java:132)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.dictionary.DictionaryBootstrap.bootstrap(DictionaryBootstrap.java:105)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:257)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 14 more</SPAN><BR /><SPAN>Caused by: org.postgresql.util.PSQLException: ERROR: column node.node_deleted does not exist</SPAN><BR /><SPAN>&nbsp; Position: 420</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:75)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:75)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:69)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)</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:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 84 more</SPAN><BR /><BR /><BR /><BR /><SPAN>I am using postgres as the database.My Alfresco global.properties is</SPAN><BR /><BR /><BR /><SPAN># Sample custom content and index data location</SPAN><BR /><SPAN>#</SPAN><BR /><BR /><SPAN>dir.root=/opt/alfresco-4.2.c/alf_data</SPAN><BR /><BR /><BR /><SPAN>db.username=alfresco</SPAN><BR /><SPAN>db.password=admin</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># MySQL connection (This is default and requires mysql-connector-java-3.1.12-bin.jar, which ships with the Alfresco server)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>db.driver=org.postgresql.Driver</SPAN><BR /><SPAN>db.url=jdbc<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ostgresql://localhost:5432/alfresco</SPAN><BR /><BR /><BR /><SPAN>### hibernate settings ###</SPAN><BR /><SPAN>hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect</SPAN><BR /><SPAN>hibernate.query.substitutions=true TRUE, false FALSE</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=oracle.jdbc.OracleDriver</SPAN><BR /><SPAN>#db.url=jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@localhost:1521:alfresco</SPAN><BR /><BR /><SPAN>#</SPAN><BR /><SPAN># Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location)</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN>#db.driver=com.sybase.jdbc2.jdbc.SybDriver</SPAN><BR /><SPAN>#db.url=jdbc:sybase:Tds:localhost:2638/alfresco</SPAN><BR /><BR /><SPAN># </SPAN><BR /><SPAN># Properties shared between the Alfresco server </SPAN><BR /><SPAN># and its remote clients (e.g.: the virtualization server).</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Ports used by Alfresco</SPAN><BR /><SPAN>#</SPAN><BR /><SPAN># Note:&nbsp; These ports are also used by the virtualization server</SPAN><BR /><SPAN>#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (hence, they're in a seperate file that can be copied easily).</SPAN><BR /><BR /><SPAN># Remote RMI services</SPAN><BR /><SPAN># alfresco.rmi.services.port=50500</SPAN><BR /><SPAN># alfresco.rmi.services.host=localhost</SPAN><BR /><BR /><BR /><SPAN>Please help me out.</SPAN><BR /><BR /><BR /><BR /><BR /><BR /><BR /></BODY></HTML> Fri, 22 Feb 2013 05:50:32 GMT bhupendra9 2013-02-22T05:50:32Z Alfresco SDK Example https://connect.hyland.com/t5/alfresco-archive/alfresco-sdk-example/m-p/281661#M234791 Hi,I have just started with Alfresco SDK 4.0.d. My question is while running the FirstFoundationClient.java code I get with following exceptionFeb 22, 2013 10:56:01 AM org.activiti.engine.impl.ProcessEngineImpl &lt;init&gt;INFO: ProcessEngine default createdFeb 22, 2013 10:56:09 AM org.activiti.engi Fri, 22 Feb 2013 05:50:32 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-sdk-example/m-p/281661#M234791 bhupendra9 2013-02-22T05:50:32Z Re: Alfresco SDK Example https://connect.hyland.com/t5/alfresco-archive/alfresco-sdk-example/m-p/281662#M234792 <HTML><HEAD></HEAD><BODY><SPAN>It looks like, there is a schema problem because of the different version. </SPAN><BR /><SPAN>Because,&nbsp; your alfresco version is 4.2c and your SDK version is 4.0.2. I would suggest, please try with alfresco 4.2c sdk.</SPAN><BR /><BR /><A href="https://wiki.alfresco.com/wiki/Community_file_list_4.2.c" rel="nofollow noopener noreferrer">https://wiki.alfresco.com/wiki/Community_file_list_4.2.c</A><BR /><BR /></BODY></HTML> Fri, 22 Feb 2013 07:21:30 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-sdk-example/m-p/281662#M234792 muralidharand 2013-02-22T07:21:30Z Re: Alfresco SDK Example https://connect.hyland.com/t5/alfresco-archive/alfresco-sdk-example/m-p/281663#M234793 <HTML><HEAD></HEAD><BODY><SPAN>It may help someone:</SPAN><BR /><SPAN>I faced this issue, and it is solved when i set the "dir.root" in the properties file with the correct value</SPAN></BODY></HTML> Sun, 23 Feb 2014 11:59:00 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-sdk-example/m-p/281663#M234793 amrorabi 2014-02-23T11:59:00Z