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]
# 1
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
jsr at 2007-7-7 3:22:24 > top of Java-index,Development Tools,Java Tools...
# 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.

MISS_DUKE at 2007-7-7 3:22:24 > top of Java-index,Development Tools,Java Tools...
# 3
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.
yossarian at 2007-7-7 3:22:24 > top of Java-index,Development Tools,Java Tools...
# 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

nightingale2k1 at 2007-7-7 3:22:24 > top of Java-index,Development Tools,Java Tools...
# 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.

MISS_DUKE at 2007-7-7 3:22:24 > top of Java-index,Development Tools,Java Tools...
# 6
I'm pretty sure copy n paste works from the sessionbean. If Not another workaround that does work is to copy and paste the rowset & field and the associated code in the _init() method. I've always been able to drop a dataprovider.
yossarian at 2007-7-7 3:22:24 > top of Java-index,Development Tools,Java Tools...
# 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}"));

}

MISS_DUKE at 2007-7-7 3:22:24 > top of Java-index,Development Tools,Java Tools...