Best IDE for liferay portlet development

[Syed Fahmeed Nawaz, geändert vor 11 Jahren.]

Guide me which is the best IDE for liferay portlet development i am using eclipse but i am not comfortable with it because i am unable to connect database did any one haive idea about eclipse mysql integration for liferay database.....

[Priyanka Dhingra, geändert vor 11 Jahren.]

can you explain why you need the mysql integration with eclipse...I never came across with such requirement
anyhow eclipse 1.5.2 liferay developer studio is the best one as far as i know

[Syed Fahmeed Nawaz, geändert vor 11 Jahren.]

i want to change the default HSQL databse to mysql i am not able to connect mysql database to liferay using eclipse....

[Priyanka Dhingra, geändert vor 11 Jahren.]

just create the portal-ext.properties in your 3. liferay-portal\tomcat-x.x.xx\webapps\ROOT\WEB-INF\classes
and add these properties there after creating a database in sql

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=

you dont need to use my sql through eclipse

[Hitoshi Ozawa, geändert vor 11 Jahren.]

Refer to Dave's reply in the thread below:

http://www.liferay.com/community/forums/-/message_boards/message/5609279

[Subhash Pavuskar, geändert vor 11 Jahren.]

Adding to Priyanka Dhingra point !!

Add following xml code to /home/Documents/Liferay-SetUp-6.1.1/Liferay-6.1.1/tomcat-7.0.27/conf/Catalina/localhost/ROOT.xml File

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

[Hitoshi Ozawa, geändert vor 11 Jahren.]

Editing ROOT.xml file in unnecessary because jdbc connection is being defined in portal-ext.properties.