Alfresco 3.4, FirstFoundationClient problems. 3 days ...

[blinker]

Who can explain step by step (with specific moments) how to run examples (I need FFC) ?

Alfresco 3.4 or Alfresco 4.0
Windows7

I received this error:

Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'RepoServerMgmt' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'transactionService' while setting bean property 'transactionService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionService' defined in class path resource [alfresco/core-services-context.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [alfresco/hibernate-context.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [alfresco/hibernate-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Hibernate Dialect must be explicitly set

I can not find a solution on the forum, internet   maybe specific settings ..

Thanks

[mrogers]

Have you created your database.  Is the database server running.

And have you configured your alfresco-global.properties?

[blinker]

Have you created your database.  Is the database server running.

And have you configured your alfresco-global.properties?

Hi. Thank you for reply

yes. I created datebase MySQl with mysql connector.
My localhost:8080/alfresco and localhost:8080/share works perfectly

My Eclipse View

Also I used "Importing the Alfresco SDK projects into Eclipse" from "Alfresco-Exercises.pdf"

My Alfresco installation folder is D:\Projects\test

SDK is here D:\Projects\alfresco-svn-3.4\alfresco-community-sdk-3.4.e

[mrogers]

So is your database called alfresco2

[blinker]

I received progress in solving the problem As soon as I created this topic  :roll:   after 3 days
the magic of collective thinking (forum) 

My steps:

0. SDK 3.4 (D:\Projects\alfresco-svn-3.4\alfresco-community-sdk-3.4.e)

1. I installed alfresco 3.4 (D:\Projects\test-3.4)

2. Then I created empty DB with name "db_alfresco34"

My settings in alfresco-global.properties (D:\Projects\test-3.4\tomcat\shared\classes)

—————————————————
dir.root=D:/Projects/test-3.4/alf_data

### database connection properties ###
db.driver=com.mysql.jdbc.Driver
db.username=root
db.password=root
db.name=db_alfresco34
db.url=jdbc:mysql://localhost/db_alfresco34?useUnicode=yes&characterEncoding=UTF-8
——————————————————-

Start tomcat\alfresco, goto http://localhost:8080/share … wait wait wait .. login as admin\root. Ok. Interface works
Stop tomcat\alfresco.

3. Then I imported SDK projects (as existing projects into workspace)

4. settings:

file "repository.properties" (D:\Projects\alfresco-svn-3.4\alfresco-community-sdk-3.4.e\lib\server\config\alfresco)
set: dir.root=D://Projects//test-3.4//alf_data

file "alfresco-global.properties" (D:\Projects\alfresco-svn-3.4\alfresco-community-sdk-3.4.e\lib\server\config)

—————————————————
dir.root=D:/Projects/test-3.4/alf_data

### database connection properties ###
db.driver=com.mysql.jdbc.Driver
db.username=root
db.password=root
db.name=db_alfresco34
db.url=jdbc:mysql://localhost/db_alfresco34?useUnicode=yes&characterEncoding=UTF-8
——————————————————-

4. very important. Right click on project "SDK FirstFoundationClient" -> Properties -> libraries -> Add External jars
You need add all jars from D:\Projects\test-3.4\tomcat\lib

5. Run "FirstFoundationClient.java"
you will see
——————
13.02.2012 8:09:04 org.activiti.engine.impl.ProcessEngineImpl <init>
INFO: ProcessEngine default created
13.02.2012 8:09:04 org.activiti.engine.impl.jobexecutor.JobAcquisitionThread run
INFO: JobAcquisitionThread starting to acquire jobs
——————

Then you need start tomcat\alfresco, login here http://localhost:8080/share
Click "Repository" and you will see "Foundation API sample (1329113353578)"

Great!

[usetelni]

Congratulations my friend, it is a awesome material.
But I have one more question:

WHY THIS TUTORIAL IS NOT IN THE WIKI YET?