Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Raminda Lasith
problem in connecting MySQL and Portlet using Hibernate and spring
November 6, 2012 2:37 AM
Answer

Raminda Lasith

Rank: New Member

Posts: 3

Join Date: October 15, 2012

Recent Posts

hey gays i am very new in Jsp and also life ray Hibernate Spring there for it is very difficult to understand in portlet and MySQL database connection part pls help me to solve my problem if u gays have any sample small portlet with MySQL db pls email me or give me some opinions for solving my problem pls my email address is ramindalasith007@gmail.com
Priyanka Dhingra
RE: problem in connecting MySQL and Portlet using Hibernate and spring
November 6, 2012 4:04 AM
Answer

Priyanka Dhingra

Rank: Liferay Master

Posts: 501

Join Date: December 19, 2011

Recent Posts

are you able to set portal-ext.properties, is that configured for my sql????
like following
Create a new file called portal-ext.properties at tomcat/ROOT/WEB-INF/classes with the following content.
1jdbc.default.driverClassName=com.mysql.jdbc.Driver
2jdbc.default.url=jdbc:mysql://localhost:{mysql-port}/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
3# Username and pw are set to blank by default
4jdbc.default.username=
5jdbc.default.password=


Go to MySQL (either workbench GUI or console) and create database named ‘lportal’
create database lportal character set utf8;
Raminda Lasith
RE: problem in connecting MySQL and Portlet using Hibernate and spring
November 6, 2012 4:37 AM
Answer

Raminda Lasith

Rank: New Member

Posts: 3

Join Date: October 15, 2012

Recent Posts

thanks but how i bind some data tables and data to my portlet like how i get data in my database to some combo box and or save same details to database using portlet pls help me in sample Db connection for this prototype case
Priyanka Dhingra
RE: problem in connecting MySQL and Portlet using Hibernate and spring
November 6, 2012 5:05 AM
Answer

Priyanka Dhingra

Rank: Liferay Master

Posts: 501

Join Date: December 19, 2011

Recent Posts

You need to use service builder
like this
Raminda Lasith
RE: problem in connecting MySQL and Portlet using Hibernate and spring
November 6, 2012 5:12 AM
Answer

Raminda Lasith

Rank: New Member

Posts: 3

Join Date: October 15, 2012

Recent Posts

thx Bro is there have any thing in hibernate and Spring like this link
Priyanka Dhingra
RE: problem in connecting MySQL and Portlet using Hibernate and spring
November 6, 2012 6:00 AM
Answer

Priyanka Dhingra

Rank: Liferay Master

Posts: 501

Join Date: December 19, 2011

Recent Posts

you can refer to this
http://www.liferay.com/community/forums/-/message_boards/message/15263919