Jboss+tomcat bundle (5.3) and binding to MySQL ?

[ilke Muhtaroglu, geändert vor 14 Jahren.]

Hi,


I downloaded the Jboss + tomcat bundle and it works fine through ..\bin\run.bat

Now I want to use MySQL database instead of built-in database; What are the instructions for this? Can you please describe or point to a description or a document.

ilke

[Lisa Simpson, geändert vor 14 Jahren.]

I would suggest looking at the JBOSS documents for how to bind it to MySQL.

[Arun Kumar S, geändert vor 14 Jahren.]

ilke Muhtaroglu:

Hi,


I downloaded the Jboss + tomcat bundle and it works fine through ..\bin\run.bat

Now I want to use MySQL database instead of built-in database; What are the instructions for this? Can you please describe or point to a description or a document.

ilke

1) Create portal-ext.properties under(jboss-tomcat-5.0.0\server\default\deploy\ROOT.war\WEB-INF\classes\portal-ext.properties)
2) add the below lines to connect mysql database

#
# MySQL
#
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=
jdbc.default.password=

Thanks,
Arun

[Victor Zorin, geändert vor 14 Jahren.]

Still have to change over database for jboss datasources as well, datasource definitions are usually in deploy directory, could be named standardjbosscmp-jdbc.xml and/or xxx-ds.xml and/or xxx-service.xml.

Change DefaultDS mapping from HSQL to Mysql.

[Lisa Simpson, geändert vor 14 Jahren.]

JBOSS has it's own seperate binding to the database and that needs to be set as well. Not just Liferay's.