Configuring MySql in Eclipse in Windows 7

[Karthik V S, modificado 10 Anos atrás.]

hi,

I want to configure MySql Connection with Liferay 6.1.1 in Windows 7 operating system. I have given all the relevant connection code in ROOT.xml and portal-ext.properties. But When I run the liferay tomcat server from eclipse then it is connecting to HSQL only, it is not connecting to MySql. I have also installed MYSql 5.5.

Can anyone help regarding this issue.

With Regards,

V S Karthik

[Subhasis Roy, modificado 10 Anos atrás.]

Can you provide the entries you added in the portal-ext.properties file

portal-ext.properties entry should be like -


jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/<your db name>?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=<your db password>

[Karthik V S, modificado 10 Anos atrás.]

hi

I have given the same code in portal-ext.properties. Also given the following code in ROOT.xml

<Resource
name="jdbc/LiferayPool"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/databasename?useUnicode=true&amp;characterEncoding=UTF-8"
username="root"
password="root"
maxActive="20"
/>

With Regards,

V S Karthik

[Subhash Pavuskar, modificado 10 Anos atrás.]

Hi ,

First create the schema in your MySQL DB and provide the same schema name in your portal-ext.properties.
Suppose i created schema name "lportal "
then in your portal-ext.properties

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

restart your server !!! Hope this may help you !!

[Subhasis Roy, modificado 10 Anos atrás.]

First remove your data source entry and only keep the portal-ext.properties file entry. Then restart your server and check whether its taking the custom database configuration or not.

If its done then you can try putting your data source entry in the "<liferay>/<tomcat>/conf/context.xml"