You have to change configuration files within .jars in deploy directory
in af.logic.jar change file hibernate.cfg.xml (you have setup new "dialect" (net.sf.hibernate.dialect.MySQLDialect in case of MySQL) and (optionaly) "connection.datasource"
in wf.logic.jar change file wf_jbpm.properties change save properties to the values as above
Hi,
I have an client that wants to use Runa with SQL Server 2000. Is it possible to integrate?
Thanks a lot
BMA
Hi,BMA
>I have an client that wants to use Runa with SQL Server 2000. Is it possible to integrate?
Yes, it is possible.
RUNA WFE was tested on MS SQL Server 2000,Oracle 9, MYSQL 4.1, PosgeSQL 8 and HSQL.
Regards,
Vitaliy
Thanks a lot.
>Thanks a lot.
You are welcome.
Regards,
Vitaliy
Hi, Vitaliy
Is it necessary any kind of customization ou development to integrate with SQL Server? If it is, how many hours or difficulties to do this?
Thanks
BMA
Hi, BMA
>Is it necessary any kind of customization ou development to integrate with SQL Server?
>If it is, how many hours or difficulties to do this?
It's not hours it's minutes ;-)
You need to change two values in two configuration files plus create data source configuration file for jboss application server.
It was discussed how to run RUNA WFE on MySQL here
http://sourceforge.net/forum/forum.php?thread_id=1340138&forum_id=426100
For MS SQL 2000 it is the same.
You need to create DataSource configuration file
(let me know if you don't know how, I'll post one for you).
replace old data source and (sql) dialect values
in
../hibernate_build.properties
../resources/wf/wf_jbpm.properties
by these values
hibernate.connection.datasource=java:/yourmssqlservername
hibernate.dialect=net.sf.hibernate.dialect.SQLServerDialect
recompile and redeploy the system
(if you unfamiliar with ant let me know I'll show you how to switch to MSSQL without rebuilding).
Regards,
Vitaliy
Hi Vitaliy
How can I switch to MySQL without rebuilding?
Chibsta
You have to change configuration files within .jars in deploy directory
in af.logic.jar change file hibernate.cfg.xml (you have setup new "dialect" (net.sf.hibernate.dialect.MySQLDialect in case of MySQL) and (optionaly) "connection.datasource"
in wf.logic.jar change file wf_jbpm.properties change save properties to the values as above
also you have to setup MySQL datasource as described here http://sourceforge.net/forum/message.php?msg_id=3307781
Hi
I am using the binary version of runa, where do I place the MySQL datasource once I have set it up?
Regards
Chibsta
Hi, Chibsta
re: where do I place the MySQL datasource once I have set it up?
You should place it to runawfe\server\default\deploy
Regards,
Vitaliy