JBoss RM and WCM

[invantix]

I used the AlfrescoCommunity-2.0-Setup.exe and was up and running in no time to try this system out.  I must say I like it so far.  After playing and reading for a while I see there is more that can be done than simple workflows and spaces.  I would like move off my lap top and in to a staging area but I want to do some things differently.

1. I would like to point at our MSSQL server rather than the default database so those guys can handle backups and desaster recovery of the database.  I see instructions to point to another database, but do I need to create tha schema for that database first?  Are there scripts to do this?

2. I need JBoss for the jBPM workflow creation, which by the way looks cool.  I guess I can just move the XML files to the tomcat installation of alfresco but am wondering if there is any reason I should run alfresco itself on JBoss rather than tomcat. It looks like I will want to use jBPM, RM, and WCM

[kevinr]

Hi,

1. The scripts should be in a folder called: extras/databases/mysql - download the community tomcat bundle if you can't find them.

2. Alfresco already has jBPM integration - it does not require JBoss. However, if mean you are using it externally and still require JBoss then that's no problem:
http://wiki.alfresco.com/wiki/Deploying_WAR_JBoss

Thanks,

Kevin

[invantix]

2. Alfresco already has jBPM integration - it does not require JBoss.

I went to the jboss web site and saw a graphical tool to create jBPM files.  Are you saying this tool is integrated into alfresco, or are you saying I can use the XML files created by that tool in alfresco because the framework that processes those files exists in alfresco.  I was not clear that I was takling about the tool.  I would like to give some power users the ability to create advanced workflows.

Let me add one more.
3. I am starting from scratch.  Is there any reason I would want to use JBoss over Tomcat.  Up until now I have been using tomcat for everything because I never sow the benefit of the complexity of EJBs.  IS there anything in the roadmap that would make me wish later that I used JBoss?  Are tehre any performance benefits?

Thanks again,
Chris

[invantix]

1. The scripts should be in a folder called: extras/databases/mysql - download the community tomcat bundle if you can't find them.

The script I see in extras/databases/mysql  just creates a blank database called alfresco.  Is that all I need?

[kevinr]

Yes, the tables are created automatically when the server auto bootstraps itself the first time you start it.

Thanks,

Kevin