No issue, got it working in the end, however I cant seem to get the
cachedRowSetdataProvider
to "sensibly" allow me to move through large datasets.
Say I have a scrollable cursor within the ResultSet from a query
and create a chacedRowset then a CachedRowSetDataProvider,
If I then attempt to execute the query , it would appear that the provider
attempts to get ALL rows
instead of just those it needs to display.
I have to set the max pages on the cachedRowset to a sensible value such as
500 pages with 50 items a page.
However, doing this in JSTL , creating my own paging table JSP , I can page
through the rows no matter how large they are.
Anyone out there actually used the woodtock paginated table with large data
sets returned from a CachedRowSet
?????
Stu
richard ratta wrote:
>
>
>
> stuartr wrote:
>
>>Everything is working however I noticed that the notation of
>>
>>#{sourcevar.value[keyfield]} doesnt work, and #{sourcevar.value.keyfield}
>>does.
>>
>>
> I believe dataprovider has its own expression syntax.
>
> -rick
>
>>
>>ALso, I am running out of heap in large result sets. Cant seem to scroll
>>within the Cached rowset even though
>>Ive set setFetchSize to 10.
>>
>>
>>Any ideas.
>>
>>???
>>
>>
>>stuartr wrote:
>>
>>
>>>Bill
>>>Have located under my netbeans environment ( however I am developing
under
>>>eclipse at this time ).
>>>Ran my junit and its looking good so far.
>>>Will embed and deploy facelets application , fingers crossed.
>>>
>>>All being well, I owe you a big thanks and a wee whiskey next time you
are
>>>in scotland.
>>>
>>>Forever grateful.
>>>( Man I wish there was more documentation on these providers )
>>>
>>>Stu
>>>
>>>
>>>
>>>
>>>
>>>
>>>Bill Edwards - Sun BOS Software wrote:
>>>
>>>
>>>>I think you need the sqlx.jar file. Not sure where this is, but
>>>>the Lockhart console ships a copy in /usr/share/webconsole/other.
>>>>
>>>>stuartr wrote:
>>>>
>>>>
>>>>>Thanks for feedback
>>>>>
>>>>>However Ive got another problem with woodstock tables displaying
>>>>>CachedRowSetDataProvider
>>>>>I set up the cachedRowset and cant seem to set the DataProvider as I
>>>>>keep
>>>>>getting
>>>>>
>>>>>java.lang.NoClassDefFoundError: com/sun/sql/rowset/CachedRowSetX
>>>>> at
>>>>>com.sun.data.provider.impl.CachedRowSetDataProvider.setCachedRowSet(CachedRowSetDataProvider.java:189)
>>>>> at
>>>>>com.sun.data.provider.impl.CachedRowSetDataProvider.<init>(CachedRowSetDataProvider.java:85)
>>>>> at
>>>>>com.sun.wwops.tie.tdms.sqlBrowser.models.SqlQueryTableModel.getTable(SqlQueryTableModel.java:43)
>>>>> at
>>>>>com.sun.wwops.tie.tdms.sqlBrowser.models.SqlQueryTableModelTest.testGetTable2(SqlQueryTableModelTest.java:97)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>>>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>>>>> at java.lang.reflect.Method.invoke(Unknown Source)
>>>>> at junit.framework.TestCase.runTest(TestCase.java:154)
>>>>> at junit.framework.TestCase.runBare(TestCase.java:127)
>>>>> at junit.framework.TestResult$1.protect(TestResult.java:106)
>>>>> at junit.framework.TestResult.runProtected(TestResult.java:124)
>>>>> at junit.framework.TestResult.run(TestResult.java:109)
>>>>> at junit.framework.TestCase.run(TestCase.java:118)
>>>>> at junit.framework.TestSuite.runTest(TestSuite.java:208)
>>>>> at junit.framework.TestSuite.run(TestSuite.java:203)
>>>>> at
>>>>>org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
>>>>> at
>>>>>org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
>>>>> at
>>>>>org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
>>>>> at
>>>>>org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
>>>>> at
>>>>>org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
>>>>> at
>>>>>org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
>>>>>
>>>>>I have no idea where the CachedRowSetX is defined and cant find any
>>>>>references to it on the web.
>>>>>Im really getting frustrated with Woodstocks lack of real examples.
>>>>>
>>>>>Any hlep to get to the bottom of setting up my
CachedRoiwSetDataprovider
>>>>>would be really appreciated.
>>>>>
>>>>>
>>>>>Stu
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>Morten Egelund Rasmussen-2 wrote:
>>>>>
>>>>>
>>>>>
>>>>>>Hi!
>>>>>>
>>>>>>We're using Facelets and Woodstock with Woodstock buttons all over. No
>>>>>>problems whatsoever.
>>>>>>
>>>>>>Use 'actionListener' and 'action' on the button. The ActionListener is
>>>>>>executed before the Action.
>>>>>>
>>>>>>Some ideas:
>>>>>>
>>>>>>* Check your ActionListener method signature.
>>>>>>
>>>>>>* Remember to register all backingbeans in faces-config.xml.
>>>>>>
>>>>>>* Check that faces-config.xml has JSF 1.2 in the header.
>>>>>>
>>>>>>* Try with <webuijsf:page> and the whole stack in the page and in the
>>>>>>Facelets template (dunno if it makes a difference).
>>>>>>
>>>>>>
>>>>>>Let us know if it helps..... Send code snippets if not.
>>>>>>
>>>>>>
>>>>>>Best regards,
>>>>>>~Morten :-)
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>>>stuart.russell_at_sun.com 25-10-2007 13:46:04 >>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>Jason I too have just wasted 4 hours trying to get the actionlisteners
>>>>>>and
>>>>>>actionExpression working on the Woodstock button component.
>>>>>>It just doesnt work .
>>>>>>Tried using firebox to find out exactly whats going wrong but getting
>>>>>>nowwhere.
>>>>>>
>>>>>>Have resorted to using the standard commandButton within JSF and it
>>>>>>works
>>>>>>AOK, no problems.
>>>>>>
>>>>>>Did anyone get to the button of this issue when integrating with
>>>>>>FACELETS.
>>>>>>
>>>>>>Or
>>>>>>
>>>>>>Anyone suggest another template engine.
>>>>>>
>>>>>>Stu
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>Jason Suplizio wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>>A coworker at my company has the following problem:
>>>>>>>
>>>>>>>I am trying to use Woodstock and Facelets. Rendering works correctly,
>>>>>>>but
>>>>>>>the binding of the "action" components did not work. For example, a
>>>>>>>button
>>>>>>>would not invoke its backing beans action. Removing Facelet and using
>>>>>>>Jsp
>>>>>>>allowed Woodstock to work properly.
>>>>>>>
>>>>>>>Tried using the actionExpression and the actionListenerExpression.
>>>>>>>
>>>>>>>Also note:
>>>>>>>The h:commandButton worked as expected.
>>>>>>>The w:radioButton also failed in Facelets
>>>>>>>
>>>>>>>
>>>>>>>Does anyone have any similar experiences? Do you know of a solution
>>>>>>>for
>>>>>>>these issues?
>>>>>>>
>>>>>>>Thanks,
>>>>>>>Jason
>>>>>>>
>>>>>>>PS Is the dev list the wrong place for these questions?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>--
>>>>>>View this message in context:
>>>>>>http://www.nabble.com/Facelets-%2B-Woodstock-problem-tf4469174.html#a13405134
>>>>>>Sent from the Project Woodstock - Dev mailing list archive at
>>>>>>Nabble.com.
>>>>>>
>>>>>>---------------------------------------------------------------------
>>>>>>To unsubscribe, e-mail: dev-unsubscribe_at_woodstock.dev.java.net
>>>>>>For additional commands, e-mail: dev-help_at_woodstock.dev.java.net
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>---------------------------------------------------------------------
>>>>To unsubscribe, e-mail: dev-unsubscribe_at_woodstock.dev.java.net
>>>>For additional commands, e-mail: dev-help_at_woodstock.dev.java.net
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe_at_woodstock.dev.java.net
> For additional commands, e-mail: dev-help_at_woodstock.dev.java.net
>
>
>
--
View this message in context: http://www.nabble.com/Facelets-%2B-Woodstock-problem-tf4469174.html#a13645473
Sent from the Project Woodstock - Dev mailing list archive at Nabble.com.