Fóruns

Início » Liferay Portal » English » 3. Development

Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
Karthik V S
Configuring MySql in Eclipse in Windows 7
14 de Maio de 2013 09:19
Resposta

Karthik V S

Ranking: Junior Member

Mensagens: 95

Data de entrada: 21 de Dezembro de 2011

Mensagens recentes

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
RE: Configuring MySql in Eclipse in Windows 7
14 de Maio de 2013 23:04
Resposta

Subhasis Roy

Ranking: Regular Member

Mensagens: 234

Data de entrada: 19 de Janeiro de 2012

Mensagens recentes

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
RE: Configuring MySql in Eclipse in Windows 7
15 de Maio de 2013 05:46
Resposta

Karthik V S

Ranking: Junior Member

Mensagens: 95

Data de entrada: 21 de Dezembro de 2011

Mensagens recentes

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
RE: Configuring MySql in Eclipse in Windows 7
15 de Maio de 2013 09:02
Resposta

Subhash Pavuskar

Ranking: Regular Member

Mensagens: 234

Data de entrada: 12 de Março de 2012

Mensagens recentes

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

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


restart your server !!! Hope this may help you !!
Subhasis Roy
RE: Configuring MySql in Eclipse in Windows 7
15 de Maio de 2013 23:35
Resposta

Subhasis Roy

Ranking: Regular Member

Mensagens: 234

Data de entrada: 19 de Janeiro de 2012

Mensagens recentes

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"