topic Re: Getting FirstFoundationClient running in V4.0 in Alfresco Archive

Getting FirstFoundationClient running in V4.0

rjohnson — Fri, 09 Mar 2012 21:21:58 GMT

I have recently struggled to get the Alfresco SDK V4.0 working properly, and whilst there are a fair few posts on the subject of getting the SDK example applications working, few of them cover V4.0 and many of them end without a fix.This post is for those who might benefit from my experience of gett

Re: Getting FirstFoundationClient running in V4.0

mrogers — Fri, 09 Mar 2012 23:20:51 GMT

Thanks for the posting.

I've updated the wiki page to point to 4.0.d and raised an issue in JIRA to consider how the introduction of SOLR affects the Embedded projects of the SDK.

Re: Getting FirstFoundationClient running in V4.0

dnallsopp — Wed, 16 May 2012 15:26:07 GMT

Thanks very much indeed for posting - I too spent ages trying to get this working (which is pretty demoralising for a 'Hello World' type example!).

On Windows XP, with Alfresco Community V4.0.d, I did not need to add the hibernate settings, though I did need to manually start PostgreSQL since the scripts in the Start Menu shut down both Tomcat and Postgres.

I didn't get any exceptions about missing classes.

I didn't put alfresco-global.properties into {alfresco-root}/SDK/samples/FirstFoundationClient/build - this folder doesn't seem to exist? I am still not sure what the correct location(s) are - because of earlier trial-and-error (and sheer desperation) I have one copy in {alfresco-root}/SDK/samples/FirstFoundationClient and another in {alfresco-root}/SDK/samples/FirstFoundationClient/source/alfresco/extension (which I created because it was mentioned in the wiki documentation, but is missing) and another in SDK AlfrescoEmbedded/config!

I also ran into the cryptic "CreateProcess error=87" problem which is due to the classpath being too long - workaround is to move the SDK nearer to the root of the filesystem (e.g. C:\Alfresco) so that the paths are shorter (!).

Re: Getting FirstFoundationClient running in V4.0

melttech — Fri, 11 Jan 2013 03:28:29 GMT

Hi, i'm having problem to run FirstFoundationClient.java as Java application from Eclipse.

I have my alfresco working even before implementing this sample.

First, I added mysql-connector-java-5.1-22.bin.jar in my build path.

Second, i cant find alfresco-vti-4.0.d.jar, jetty-6.1.26.jar, jetty-util-6.1.26.jar in downloaded {alfresco-root}/SDK/lib/server directory

I already run my ant build.xml>Run as Ant build

Eclipse giving me org.springframework.jdbc.BadSqlGrammarException error

I bet theres sth to do with ApplicationContext ctx = ApplicationContextHelper.getApplicationContext();

Here is the error message : http://pastebin.com/cCQmMY2H

I'm thankful if someone can help me.

Cheers,

Re: Getting FirstFoundationClient running in V4.0

rjohnson — Fri, 11 Jan 2013 11:05:15 GMT

Your error suggests that your database schema and your Alfresco instance are out of step.

The default database is now Postgresql so I'm guessing that you elected to use MySql on the install instead or that you have upgraded from an earlier version. I can't think of a reason why that would be a problem but…

Have you managed to log into Alfresco and do "some work" i.e. add, update and delete a document or 2?

Re: Getting FirstFoundationClient running in V4.0

melttech — Mon, 14 Jan 2013 08:23:08 GMT

HI,

Sry for late reply.

I'm using Mysql as database. My alfresco is working normally. I can do whatever i want in alfresco. I already copy paste alfresco-global.properties into Eclipse. This error driving me crazy

Re: Getting FirstFoundationClient running in V4.0

rjohnson — Mon, 14 Jan 2013 11:47:09 GMT

Then I suspect that the FirstFoundationClient is out of step with the 4.0d release database schema on MySQL. Looking at the log you put into PasteBin the key lines for me are

### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'node.node_deleted' in 'field list'
### The error may involve alfresco.node.select_NodeByNodeRef-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'node.node_deleted' in 'field list'

To me, this says that the error is that FirstFoundationClient is trying to query your database and asking it to return information in a column node.node_deleted (so I'm guessing that means a table called node and a column within that table called node_deleted) and the issue is that this table / column combination isn't there.

Now, I am running 4.0a on postgresql and I have just had a quick look at my database structure using psql and I can tell you that there is no table called node, there is one called alf_node and there is one called avm_node and alf_node does have a column called node_deleted in it. I suggest that you have a peek at the MySQL database and see what tables you have got in it because it looks to me as if your SDK is trying to access a table that isn't there and based on the error message it looks as if the SQL statement created for MySQL is wrong.

Good luck and let me know how you get on.

Bob

Re: Getting FirstFoundationClient running in V4.0

melttech — Tue, 15 Jan 2013 07:24:54 GMT

I took a peek into mySQL and alf_node does not have a column called node_deleted in it.

What can go wrong?

Re: Getting FirstFoundationClient running in V4.0

rjohnson — Thu, 17 Jan 2013 09:35:34 GMT

Based on a very quick search of this forum it seems like you have a database from Alfresco V4.1 Schema 5113 or later and a development kit that pre-dates that because at V4.1 Schema 5113 the column node_deleted was removed from alf_nodes and replaced by another mechanism for tracking deleted nodes. See this JIRA

https://issues.alfresco.com/jira/browse/DOC-410?page=com.atlassian.jira.plugin.system.issuetabpanels:changehistory-tabpanel

I would start by checking to see if there is a later version of the SDK. If there isn't, ask a separate question in the relevant forum about when a new version might be available.

Re: Getting FirstFoundationClient running in V4.0

melttech — Mon, 21 Jan 2013 01:21:11 GMT

Thanks rjohnson for your help.

Appreciated it. Now it is clear the reason why i cant make the SDK running.

In the nutshell, available SDK wont work with Alfresco V4.1 Schema 5113 and later.

Cheers!