Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Syed Fahmeed Nawaz
Best IDE for liferay portlet development
October 17, 2012 5:25 AM
Answer

Syed Fahmeed Nawaz

Rank: New Member

Posts: 9

Join Date: October 3, 2012

Recent Posts

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
RE: Best IDE for liferay portlet development
October 17, 2012 5:42 AM
Answer

Priyanka Dhingra

Rank: Liferay Master

Posts: 501

Join Date: December 19, 2011

Recent Posts

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
RE: Best IDE for liferay portlet development
October 17, 2012 5:44 AM
Answer

Syed Fahmeed Nawaz

Rank: New Member

Posts: 9

Join Date: October 3, 2012

Recent Posts

i want to change the default HSQL databse to mysql i am not able to connect mysql database to liferay using eclipse....
Priyanka Dhingra
RE: Best IDE for liferay portlet development
October 17, 2012 6:23 AM
Answer

Priyanka Dhingra

Rank: Liferay Master

Posts: 501

Join Date: December 19, 2011

Recent Posts

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

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

you dont need to use my sql through eclipse
Hitoshi Ozawa
RE: Best IDE for liferay portlet development
October 18, 2012 5:37 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7990

Join Date: March 23, 2010

Recent Posts

Refer to Dave's reply in the thread below:

http://www.liferay.com/community/forums/-/message_boards/message/5609279
Subhash Pavuskar
RE: Best IDE for liferay portlet development
October 19, 2012 2:25 AM
Answer

Subhash Pavuskar

Rank: Regular Member

Posts: 234

Join Date: March 12, 2012

Recent Posts

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


 1
 2<Resource
 3    name="jdbc/LiferayPool"
 4    auth="Container"
 5    type="javax.sql.DataSource"
 6    driverClassName="com.mysql.jdbc.Driver"
 7    url="jdbc:mysql://localhost/Liferay6.1.1?useUnicode=true&amp;characterEncoding=UTF-8"
 8    username="root"
 9    password="root"
10    maxActive="20"
11/>
Hitoshi Ozawa
RE: Best IDE for liferay portlet development
October 20, 2012 5:17 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7990

Join Date: March 23, 2010

Recent Posts

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