Forums

Home » Liferay Portal » English » 3. Development

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
dave ch
Store procedure
March 29, 2012 8:14 AM
Answer

dave ch

Rank: Regular Member

Posts: 164

Join Date: February 6, 2012

Recent Posts

Hi all,

Can any body have any idea about what is store procedure in portlet? Please help me out with details?
Jelmer Kuperus
RE: Store procedure
March 29, 2012 9:59 AM
Answer

Jelmer Kuperus

Rank: Liferay Legend

Posts: 1192

Join Date: March 10, 2010

Recent Posts

You mean a stored procedure ? that has nothing to do with portlets. If not what do you mean ?
Hitoshi Ozawa
RE: Store procedure
March 29, 2012 8:46 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

I've answered in the following thread.

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

or do you want to use stored procedure with service builder?
dave ch
RE: Store procedure
March 29, 2012 9:46 PM
Answer

dave ch

Rank: Regular Member

Posts: 164

Join Date: February 6, 2012

Recent Posts

Thank you.
ashish pradhan
RE: Store procedure
March 29, 2012 9:57 PM
Answer

ashish pradhan

Rank: Junior Member

Posts: 54

Join Date: March 17, 2012

Recent Posts

Actually what is the Storde procedure portlet? i dont have any idea

yes, i want stored proceudure in service builder
David H Nebinger
RE: Store procedure
March 30, 2012 6:22 AM
Answer

David H Nebinger

Community Moderator

Rank: Liferay Legend

Posts: 11046

Join Date: September 1, 2006

Recent Posts

This is doable, but can take a lot of work on your end depending upon what the stored proc is doing.

If you're retrieving data to be returned as an entity, you would create an entity in service.xml and build the services. You'd then go to the ***LocalServiceImpl class and either add methods to invoke the SP separately or override the generated methods if you have to invoke the SP to do those operations.

Oh, and there is no "stored procedure portlet", it doesn't exist.
Hitoshi Ozawa
RE: Store procedure
March 30, 2012 7:00 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

I haven't tried this myself yet, but it may be doable by writing up procedure in default.xml in custom-sql folder.

http://www.liferay.com/ja/documentation/liferay-portal/6.1/user-guide/-/ai/custom-sql