[Agila Wiki] Update of "AgilaBpelInstallationGuide" by MatthieuRiou

[Apache Wiki <wi...@apache.org>]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Agila Wiki" for change notification.

The following page has been changed by MatthieuRiou:
http://wiki.apache.org/agila/AgilaBpelInstallationGuide

------------------------------------------------------------------------------
  
  === Using your own Database ===
  
- Coming soon...
+ Agila BPEL is using [http://www.hibernate.org Hibernate] as its persistence layer. Thanks to Hibernate, Twister can support several databases (like MySQL, HSQL, Oracle, DB2, Sybase, MS SQL Server, ...) simply by changing a configuration file. For a full list of supported database servers, please refer to the hibernate web site.
+ 
+ To configure your database server, edit the file hibernate.cfg.xml located in the engine/wsa/src/test/resources directory of your Agila BPEL's sources. Five properties must be changed :
+ 
+  * connection.driver_class : the fully qualified name of the JDBC driver class of your database server.
+  * connection.url : the JDBC connection URL used to connect to your database.
+  * connection.username : the user name to login to your database.
+  * connection.password : the password associated to the login.
+  * dialect : the hibernate dialect to use.
+ 
+ Hibernate uses different "dialects" depending on the database it has to use. The dialect parameter is therefore specific to each database. Here is a table that lists dialects for most currently used databases:
+ 
+ ||Database||Dialect||
+ |MySQL|net.sf.hibernate.dialect.MySQLDialect|
+ |Oracle|net.sf.hibernate.dialect.OracleDialect|
+ |Oracle 9|net.sf.hibernate.dialect.Oracle9Dialect|
+ |DB2|net.sf.hibernate.dialect.DB2Dialect|
+ |Microsoft SQL Server|net.sf.hibernate.dialect.SQLServerDialect|
+ 
+ You'll also need to add your JDBC driver as a Maven dependency in the dist module. Edit ''project.xml'' in the dist module and add something like this (adapt with your driver name and version):
+ 
+ ... to be continued ...
  
  == Testing your installation ==