Re: NetBeans 6.0 beta 1 with the VWP, trying to retrieve blob and display in table

Folks, I was able to workaorund the issue, instead of an "image" component, I used the ImageHyperlink component, a.k.a.

<webuijsf:imageHyperlink actionExpression="#{admin$PictureAdministration.imageHyperlink1_action}"
                                        binding="#{admin$PictureAdministration.imageHyperlink1}" id="imageHyperlink1"
                                        imageURL="/servlet/DisplayImage?imageid=#{currentRow.value['PICTURE_TBL.PICTURE_ID']}" text="" url="/servlet/DisplayImage?imageid=#{currentRow.value['PICTURE_TBL.PICTURE_ID']}"/>


I would love to know why the "Image" component doesn't work though.

Chris



Chris Fleischmann wrote:

Folks, any thoughts on the below issue... I am trying to replicate the tutorial in Creator 2, and 2.0 update 1 here...  http://developers.sun.com/jscreator/reference/techart/2/retrieve_binary_data.html

Using NetBeans 6.0 beta 1 and MySQL 5.0.45 OR Derby from GlassFish b58g (that ships with FULL NetBeans IDE download)

----

So, I drop a table on to any blank Visual JSF page, then drag the "PICTURE_TBL" on to it, (which creates the dataprovider and cacherowset... blah blah)

The DB TABLE was created like so (in MySQL):

create table PICTURE_TBL ( PICTURE_ID INT NOT NULL primary key AUTO_INCREMENT, IMAGE BLOB);

and like (for Derby DB)

CREATE TABLE PICTURE_TBL (PICTURE_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),  IMAGE BLOB);

Then I select Table Layout, and configure it so that the table is created something like;



heres the information behind the scenes, (the JSP)

<ui:table augmentTitle="false" binding="#{Page1.table1}" id="table1" style="left: 72px; top: 240px; position: absolute; width: 120px"
                            title="Images Retrieved from Database" width="120">
                            <ui:tableRowGroup binding="#{Page1.tableRowGroup1}" id="tableRowGroup1" rows="10" sourceData="#{Page1.demo_blobDataProvider1}" sourceVar="currentRow">
                                <ui:tableColumn binding="#{Page1.tableColumn1}" headerText="IMAGE" id="tableColumn1" sort="PICTURE_TBL.PICTURE_ID">
                                    <ui:staticText binding="#{Page1.staticText1}" id="staticText1" text="#{currentRow.value['PICTURE_TBL.PICTURE_ID']}"/>
                                </ui:tableColumn>
                                <ui:tableColumn binding="#{Page1.tableColumn3}" headerText="Image" id="tableColumn3">
                                    <ui:image binding="#{Page1.image1}" id="image1" url="/servlet/DisplayImage?imageid=#{currentRow.value['PICTURE_TBL.PICTURE_ID']}"/>
                                </ui:tableColumn>
                            </ui:tableRowGroup>
                        </ui:table>

BUT each time I right Select the Table and Choose Table-Layout, I get the following error?



Note also the changes in column names etc.

Any thoughts, how-tos or advice, greatly appreciated.

Chris