1 - Do i have to use MySql databas? Is there a default HSQL embedded database for Alfresco SDK? (I have already installed Alfresco server - tomcat bundle, it's running properly with the default HSQL db)
2 - Which eclipse release to use with Alfresco SDK: eclipse for java SE - Eclipse Europa (for JEE) - Eclipse Callisto (for web) - myEclipse (Note: i tried eclipse Europe, but failed to run web projects in SDK samples, e.g. SDK CustomJSP).
I'm newbie to Alfresco & any help would appreciated
Why do you want to configure a database for the SDK ? The SDK provides Eclipse projects to use for development. For the Eclipse version, you could use Eclipse Ganymede for J2EE: it comes with interesting plugins for JSF / Web apps development. I personally use the freemarker and jBPM designer plugins too which should be installed separately. You can download them here: http://www.jboss.org/tools/download/index.html.
The first step is to ensure an appropriate database is setup for the Alfresco Repository. If using MySQL, the following may be issued from the shell script:
mysqladmin -u root -p create alfresco mysql -u root -p -e "grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;" mysql -u root -p -e "grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;"
Alternatively you can run the batch/sql file: /extras/databases/mysql/db_setup.bat (which calls db_setup.sql)
My question: Is it mandatory to install MySql database to run sdk samples ? - i mean SDK FirstFoundationClient
(Note: i got Alfresco server running using the default HSQL, so i don't wanna install MySql to avoid conflict.)
You don't need MySQL to run Alfresco from Eclipse. HSQL is fine for development. I personnally use Eclipse 3.2.2. Look at these posts for more details on how to configure your project :