how to configure mysql database with liferay ide

[Ramesh K, módosítva 13 év-val korábban]

Hi to All,
i am using liferay tomcat bundle 6.0.4,
plugins sdk 6.0.4 and liferay ide 1.0
now i want to connect to database mysql
how to configure mysql database in liferay ide
thanks in advance...

Thanks & Regards
Ramesh K

[Anil Sunkari, módosítva 13 év-val korábban]

Hi Ramesh,

##
## You can override portal.properties by specifying your own settings in this
## file.
##

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/DBNAME?useUnicode=true&charac
terEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=xxxx
jdbc.default.password=xxxx

You can override this in portal-ext.properties./You can observe in portal.properties file.

[Ramesh K, módosítva 13 év-val korábban]

Hi Anil
Thanks for your reply..
i am unable to find which portal.properties i should change..
can you please tell me where is the portal.properties in plugins folder
i am using plugins sdk 6.0.4 with liferay ide 1.0

Thanks & Regards
Ramesh K

[prakash harigopal, módosítva 13 év-val korábban]

Ramesh,

Add the Mysql server details under $TOMCAT_HOME\conf\catalina\localhost\ROOT.xml

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

And you have to create a new properties file named "portal-ext.properties" under path

$TOMCAT_HOME\webapps\ROOT\WEB-INF\classes

and there you can add the required settings and add the db details as

jdbc.default.jndi.name=jdbc/LiferayPool

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=

thats all .. it will resolve.

thanks
prakash