Woodstock Portlet

Hi. Im developing a JSF-Woodstock based web portlet to be used in a Liferay portal. Im having a problem connecting my portlet to a MySQL database. The portlet displays a Woodstock table with the information gathered from the database. I am able to deploy the portlet, but the table shows “No items found”. Im guessing that it is a database connection problem. Could you help me out or at least point me in the right direction? Thank you.

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.549 / Virus Database: 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM

Hi Antonio,

It's been suggested that you first try obtaining data directly from a backing bean (i.e., take the table component out of the equation). If you can get the Liferay/mysql connection to work, then try adding database support to the table.

Antonio Batista wrote:

Hi. Im developing a JSF-Woodstock based web portlet to be used in a Liferay portal. Im having a problem connecting my portlet to a MySQL database. The portlet displays a Woodstock table with the information gathered from the database. I am able to deploy the portlet, but the table shows “No items found”. Im guessing that it is a database connection problem. Could you help me out or at least point me in the right direction? Thank you.

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.549 / Virus Database: 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM

It looks like the _init() method of Page.java(Page java file) is not getting called  in Portlet environment. And user_DataProvider.setCachedRowSet() is called in _init() to set the CachedRowSet for the dataprovider. That's why you are not able to see any data.

Try calling _init() inside constructor of the Page.java.
Also make sure you have added the jdbc datasource properly in your application server.

I tried calling _init() from the constructor of Page.java and it worked for me.

To me it looks like a bug in jsfportletbridge.
Cc'ing jsfportletbridge dev alias.

Thanks,
Satya

From: Antonio Batista <abatista@...>

Date: October 22, 2008 10:40:26 AM PDT

To: dev@...

Subject: Woodstock Portlet

Reply-To: dev@...

Hi. Im developing a JSF-Woodstock based web portlet to be used in a Liferay portal. Im having a problem connecting my portlet to a MySQL database. The portlet displays a Woodstock table with the information gathered from the database. I am able to deploy the portlet, but the table shows “No items found”. Im guessing that it is a database connection problem. Could you help me out or at least point me in the right direction? Thank you.

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.549 / Virus Database: 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM