Rowsets in pagebean not working as expected !!
Rowsets put in the pagebean scope are not working for me !! The datatables (bound to the relavent dataproviders) are not showing any items. In the properties pannel, rowsets cannot be set for dataproviders !! (if set, they are automatically get emptyed)
Anyone having the same problem?
Thank you.
[315 byte] By [
MISS_DUKE] at [2007-11-26 11:08:04]

# 2
I still face the same problem in my existing project. But this problem is only for my existing project !! I created a new test project and tested rowsets in pagescope, thery arer working as expexted, but they are not working in my existing project !!
But I desperately need to put the rowsets in the page scope to add some funtionalities to my existing project.
Any help from anyone is greately appreciated.
(My existing project was initially created with JSC2)
Thank you very much.
# 4
> I keep all of my RowSets in the page and have no
> problems. In the options I unchecked "Create RowSets
> in Session" and I just drag the table to the page
> outline to create it. How are you creating the
> RowSets?
> -Jeff
> http://www.ragtop.org
Hi Jeff,
I want to know how to set the option ? I use Netbean VWP :)
Thx
adwin
www.adwin.org
# 5
> Yeah I've been living with this problem for some time
> now. The affected project was a JSC 2 project that I
> imported to netbeans.
>
> Current workaround is to copy and paste a rowset /
> dataprovider combination from another page. If it's
> from the wrong table i clean it up manually.
But I haven't got any rowsets in the pagebean yet ! (All are in the sessionbean) What can I do?
Any further help is very much appreciated.
Thank you.
# 7
I made a new page with name "Test.jsp" and dropped a rowset with name "mainRowSet". The following code is automatically created. But in the design view the dataprovider cannot be assigned with the rowset !!
private void _init() throws Exception {
mainRowSet.setDataSourceName("java:comp/env/jdbc/MySQLDataSource");
mainRowSet.setCommand("SELECT * FROM main");
mainRowSet.setTableName("main");
mainDataProvider.setCachedRowSet
((javax.sql.rowset.CachedRowSet)getValue("#{Test.mainRowSet}"));
}