topic Re: Remote Alfresco API rivet in Alfresco Archive

Remote Alfresco API rivet

rivetlogic — Mon, 17 Nov 2008 23:32:06 GMT

RAArRAAr is an abstraction layer for remote communication with Alfresco ECM. RAAr provides a simple, Java-based local library that may be used by one or more content rich applications and allows these applications to interface to Alfresco (including multiple Alfresco repositories from the same appli

Re: Remote Alfresco API rivet

g9adm — Fri, 21 Nov 2008 14:41:20 GMT

Hi ..

Is this supported on Alfresco 3 ?

I get a Caused by: java.lang.NoSuchMethodError: com.rivetlogic.core.cma.alfresco.webscripts.bean.AuthenticationServiceWebScript.getRepositoryContext()Lorg/alfresco/web/scripts/WebScriptContext;

trying to run a sample app.

BR
Anders Monrad

Re: Remote Alfresco API rivet

rivetlogic — Fri, 21 Nov 2008 16:11:32 GMT

Nope, 2.2 is what's supported with RAAr 1.8.1.

Will make updates to support 3.0 this weekend and release again.

I'll post the announcement of the new version to this forum. I'll also include the supported Alfresco version(s) on the wiki/release notes.

–Sumer

Re: Remote Alfresco API rivet

mygol — Mon, 24 Nov 2008 09:41:56 GMT

waiting for support Alfresco 3

Re: Remote Alfresco API rivet

rivetlogic — Tue, 25 Nov 2008 04:59:51 GMT

This is going to take a bit more time. Stay tuned…

–Sumer

Re: Remote Alfresco API rivet

monitloth — Mon, 01 Dec 2008 10:50:23 GMT

If I understood it, after reading your website, there is now support for Labs 3.

I have a little question about the capabilities of your library.

I would like to navigate between directories. Is it possible?

As an example, I would like to run the following code (but then in Java):

roothome.childByNamePath("Company Home/Clients");‍

Many thanks.

Re: Remote Alfresco API rivet

rivetlogic — Mon, 01 Dec 2008 20:35:03 GMT

RAAr version 1.9.0 with support for Alfresco 3.0 is out. You can get it from here: http://wiki.rivetlogic.org/display/RAAR/Downloads

Cheers.

–Sumer

Re: Remote Alfresco API rivet

rivetlogic — Mon, 01 Dec 2008 20:38:59 GMT

Not sure if I understood your question, but if it means "get all the content in a particular directory" then

You need to write a lucene query and search using search service which will return the contents in that folder.


String query = "+PATH:\"/app:company_home/cm:Clients/*\"";

List<Node> nodes = searchService.query(ticket, new StoreRef(spacesStore), SearchService.QueryLanguage.lucene, query, 
properties, true, true, true, true, requiredPermissions, 100, sortDefinitions);

if (nodes != null) {
   // file found
   System.out.println("Content in Clients folder");
   for (Node node: nodes) {
      System.out.println("node: " + node.getProperties().get(ContentModel.PROP_NAME));
   }
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

You can also restrict the type of content the search returns. For example get only the items of type folder then the lucene query looks like this:


String query = "+PATH:\"/app:company_home/cm:Clients/*\" + "AND +TYPE:\"cm:folder\"";
‍‍‍

Bear in mind, however, that this query can be optimized if you define which properties you'd like returned (instead of everything).

You can check the Javadoc for more details at: http://docs.rivetlogic.org/projects/raar/current/javadocs

Let me know if you have any questions.

- Praveen C Elineni.

Re: Remote Alfresco API rivet

mesdocs — Wed, 03 Dec 2008 16:57:11 GMT

Hi,

I get an error when i try to install the cma-alfresco-1.9.0.amp in my alfresco server (Enterprise 3.0).

17:53:05,544 ERROR [context.support.XmlWebApplicationContext] Exception thrown from ApplicationListener handling ContextClosedEve
nt
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested excepti
on is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
        at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
        at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
        at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
        at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionMa
nager.java:350)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupp
ort.java:262)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupp
ort.java:219)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:380)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:309)
        at org.alfresco.repo.transaction.RetryingTransactionAdvice.invoke(RetryingTransactionAdvice.java:73)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy151.onShutdown(Unknown Source)
        at org.alfresco.linkvalidation.LinkValidationServiceBootstrap.onShutdown(LinkValidationServiceBootstrap.java:54)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:73)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.ja
va:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:676)
        at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:651)
        at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:336)
        at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:74)
        at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:3882)
        at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4523)
        at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:924)
        at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1006)
        at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1214)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:293)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1337)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
        at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: org.apache.derby.jdbc.EmbeddedDriver is not registered with the JDBC driver manager
        at org.apache.derby.jdbc.AutoloadedDriver.getDriverModule(Unknown Source)
        at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
        at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.ja
va:81)
        at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
        … 36 more
3 dÚc. 2008 17:53:10 org.apache.catalina.startup.HostConfig deployWAR
INFO: D´┐¢ploiement de l'archive alfresco.war de l'application web
Exception in thread "Thread-48" java.lang.IllegalStateException: The org.alfresco.cache.sysAdminCache Cache is not alive.
        at net.sf.ehcache.Cache.checkStatus(Cache.java:1588)
        at net.sf.ehcache.Cache.get(Cache.java:774)
        at net.sf.ehcache.Cache.get(Cache.java:755)
        at org.alfresco.repo.cache.EhCacheAdapter.get(EhCacheAdapter.java:87)
        at org.alfresco.repo.cache.TransactionalCache.get(TransactionalCache.java:348)
        at org.alfresco.linkvalidation.LinkValidationServiceImpl.isLinkValidationDisabled(LinkValidationServiceImpl.java:364)
        at org.alfresco.linkvalidation.LinkValidationServiceImpl.run(LinkValidationServiceImpl.java:592)
        at java.lang.Thread.run(Thread.java:595)

Do you have a solution ?

Mesdocs.

Re: Remote Alfresco API rivet

rivetlogic — Thu, 04 Dec 2008 02:55:13 GMT

Hi Mesdocs,

Looks like the database that you have is corrupt, can you cleanup or erase the whole database and start over. (Delete the alf_data folder at root location of alfresco and restart)

Also make sure Alfresco comes up before installing the RAAR amp into it.

Let me know if the DB cleanup didn't work.

- Praveen C Elineni.

Re: Remote Alfresco API rivet

klwalker — Mon, 08 Dec 2008 14:23:41 GMT

When using RAAR v1.8.1 jars in an applicatin to upload documents to Alfresco, I'm getting the following error in the console. However, when I modify the job to use v1.7.1, the error does not occur. However that version is before the change to allow you to configure the http connection pooling. We're just using the default pool settings so are not overriding with any -D params.

Exception in thread "Thread-5" java.lang.NoSuchFieldError: ANY_HOST_CONFIGURATION
        at org.apache.commons.httpclient.params.HttpConnectionManagerParams.setDefaultMaxConnectionsPerHost(HttpConnectionManagerParams.java:86)
        at com.rivetlogic.core.cma.rest.impl.RestExecuterImpl.init(RestExecuterImpl.java:736)
        at ucs.common.contentmgmt.AlfrescoContentManager.initRaar(AlfrescoContentManager.java:160)
        at ucs.common.contentmgmt.AlfrescoContentManager.<init>(AlfrescoContentManager.java:147)
        at ucs.common.contentmgmt.AlfrescoContentManager.<init>(AlfrescoContentManager.java:140)
        at ucs.common.contentmgmt.ContentManagerFactory.getContentManager(ContentManagerFactory.java:9)
        at ucs.common.contentmgmt.ContentManagementHelper.<init>(ContentManagementHelper.java:40)
        at ucs.itd.ucms.pdf.FileUploadThread.upload(FileUploadThread.java:193)
        at ucs.itd.ucms.pdf.FileUploadThread.run(FileUploadThread.java:86)

Re: Remote Alfresco API rivet

klwalker — Mon, 08 Dec 2008 15:52:27 GMT

Ok, I got it working. The problem was that we were referencing jbossall-client.jar in the classpath as well and that contains httpclient classes of an older version. I moved common-httpclient-3.1.jar first in the classpath and it works now.

Re: Remote Alfresco API rivet

deardooley — Thu, 22 Jan 2009 16:19:18 GMT

I'm using RAAr 1.5 to put together a demo application. How would one get the size of a content node's content (ie the file size)? Also, I don't see a rivetlogic implementation of the PermissionService class, however it was used in a code snippet above to specify how to change permissions on folders. Do I need to upgrade my alfresco and RAAr versions for this feature?

Thanks for your help!!

Rion

Re: Remote Alfresco API rivet

rivetlogic — Thu, 22 Jan 2009 20:10:46 GMT

Hi Rion,

To get the size, get the content property, cast it to a ContentData and ask that for the size. Example:


  ContentData contentData = (ContentData) node.getProperties.get(ContentModel.PROP_CONTENT);
  long size = 0L;
  if (contentData != null)
  {
    size = contentData.getSize();
  }
‍‍‍‍‍‍‍‍

Check out the SecurityService for getting/setting permissions.

With regard to compatibility, here is the compatibility matrix:
http://wiki.rivetlogic.com/display/RAAR/Compatibility+Matrix

You might want to consider RAAr 1.8.1 with Alfresco 2.2.1.

Cheers.

–Sumer

Re: Remote Alfresco API rivet

rivetlogic — Mon, 09 Feb 2009 00:36:34 GMT

RAAr version 1.11.0 is out.

Changelog: http://wiki.rivetlogic.com/display/RAAR/Change+Log

Download: http://wiki.rivetlogic.org/display/RAAR/Downloads

Cheers.

–Sumer

Re: Remote Alfresco API rivet

rivetlogic — Tue, 10 Feb 2009 16:35:26 GMT

RAAr version 1.11.0 is out.

Changelog: http://wiki.rivetlogic.com/display/RAAR/Change+Log

Download: http://wiki.rivetlogic.org/display/RAAR/Downloads

Cheers.

–Sumer

Re: Remote Alfresco API rivet

deardooley — Mon, 23 Feb 2009 17:41:42 GMT

Quick question. Are users able to see all permissions on a node? As a standard user, I've created a node in my personal space and added Consumer permissions for other users to view the that file. The other users can see the file just fine. However, I'm querying for the permissions on that node and all I see are my personal permissions, not those I've set for the other users. Is there a way I can see the other users permissions that I've set.

Re: Remote Alfresco API rivet

rivetlogic — Mon, 23 Feb 2009 21:14:32 GMT

Hi,

You should be able to use the following RAAr call from the SecurityService to get all permissions assigned to a node:


java.util.Set<org.alfresco.service.cmr.security.AccessPermission> getAllSetPermissions(Ticket ticket, org.alfresco.service.cmr.repository.NodeRef nodeRef) throws InvalidTicketException, CmaRuntimeException
‍‍‍

This call will return a set of permissions assigned to that node. It will include all users and their access level. The only gotcha is that if the user executing this call is a Consumer on that node you will get a org.alfresco.repo.security.permissions.AccessDeniedException exception.

The following is an example of how you can catch that exception:


try {
    Set<AccessPermission> accessPerms = securityService().getAllSetPermissions(ticket, nodeRef);
} catch (CmaRuntimeException e) {
    if (e.getCause() instanceof AccessDeniedException) {
        // This means you are a Consumer on this node
}
‍‍‍‍‍‍‍‍

Hope this helps,

–Alaaeldin

Re: Remote Alfresco API rivet

deardooley — Thu, 26 Feb 2009 18:44:45 GMT

Hey all,

Thanks again for all the help coming up to speed on the RAAr java api. I'm working with the VersionService and don't quite understand how versioning works through the api. How does one go about enabling versioning on a node? I see the version service, but I'm unsure what the steps would be to add versioning support. Looking at the effect on a node from the alfresco webapp, I see that the following properties were added to a node after versioning:

{http://www.alfresco.org/model/content/1.0}versionLabel
{http://www.alfresco.org/model/content/1.0}autoVersion
{http://www.alfresco.org/model/content/1.0}initialVersion

As well, the following aspect was added:

{http://www.alfresco.org/model/content/1.0}versionable

Is it sufficient to add the aspect and then perform a createVersion, or is there more to it. Also, to find out if a node is versioned, do we simply look for the versionable aspect, or check for a version history?

Rion

Re: Remote Alfresco API rivet

rivetlogic — Sun, 01 Mar 2009 13:47:47 GMT

Hi,

You answered your own question

If you want Alfresco to start versioning a node you should just attach the versionable aspect to it. Any updates to the document will then automatically increment the version number.

If you want to find out if a node is versioned you should just check if the versionable aspect is added using the hasAspect() method of the NodeService.

Hope this helps,

–Alaaeldin