Re: JavaFX Composer

[Maros Sandor < >]

I have tried you attached example and indeed was able to reproduce your 
problem. However, once I changed "product_id" to "PRODUCT_ID" and 
"description" to "DESCRIPTION" all started to work as expected. So the 
problem was indeed in mistyped field names.

Maros

MILLER, JON A CIV DFAS wrote:
> Maros:
>
> 1) I agree, the "index buttons" are working and data is being pulled
> from the DB.
> 2) All the field names are correct;
> 3) Test app attached; app modeled on screencast at
> http://netbeans.org/project_downloads/javafx/jdbc/JDBC.html.
>
> Environment:
>
> Product Version = NetBeans IDE 6.9 Beta (Build 201004200117)
> Operating System = Windows XP version 5.1 running on x86
> Java; VM; Vendor = 1.6.0_20
> Runtime = Java HotSpot(TM) Client VM 16.3-b01
> Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3)
> Gecko/20100401 Firefox/3.6.3
>
> Jon A. Miller 
>
> -----Original Message-----
> From: 
>        [mailto:
>       ] 
> Sent: Thursday, May 06, 2010 4:04 AM
> To: MILLER, JON A CIV DFAS
> Cc: 
>
>       
> Subject: Re: JavaFX Composer
>
> Hello Jon,
>
> thanks for the detailed report. I have tried your scenario here with 
> MySQL and all worked fine for me. I will also try JavaDB later today. 
> What version of NetBeans/JavaFX/Composer are you using? Could you send 
> me your sample app zipped? I do not see any problem from what you have 
> described but just to be sure. Index buttons behavior indicates that the
>
> data source has successfully fetched the data, please double check that 
> you have correct field names in the Form template.
>
> Maros
>
> MILLER, JON A CIV DFAS wrote:
> > Newbie to Composer:  
> >
> > Objective: Attempting to implement simple Oracle JDBC datasource
> > display:
> >
> > 1) Services -> Databases -> [jdbc] -> [right-click] -> connect ->
> > display schema objects
> > 2) File -> New Project -> JavaFX -> JavaFX Desktop application ->
> [enter
> > app name] -> FINISH
> > 3) Pallette -> Data Sources -> [DnD} JDBC Data Source into Scene ->
> > Support Popup -> OK 
> > 4) BROWSE -> [select jdbc] -> OK -> [enter SELECT * FROM TABLE] ->
> check
> > lazy loading 
> > 5) EXECUTE QUERY -> data from table displayed -> OK
> > 6) TEMPLATES -> [DnD] Desktop Form into Scene -> popup -> DATA SOURCE
> > [select jdbc] -> ADD
> > 7) [enter fields(column names) and labels] -> OK -> labels and bound
> > display in Scene
> > 8) TEMPLATES -> [DnD] INDEX BUTTONS -> popup -> INDEX COMPONENT
> [select
> > jdbc] -> OK
> > 9) "PREVIOUS"/"NEXT" Buttons display in Scene
> > 10) Add Oracle "ojdbc6" jars to project properties 
> > 11) RUN -> Build Successful -> "NEXT" button highlighted, but data is
> > NOT displayed
> >         a) database monitor indicates sql was submitted to the Oracle
> > database server
> >         b) incrementing the "NEXT" button 38 times grayed it out(table
> > contains 39 rows)
> >         c) same scenario on the "PREVIOUS" button
> >         d) at no time is the data displayed
> >         e) Navigator indicates all expected objects created
> >         f) "VISIBILITY" set to true
> > 12) Same results using JavaDB.
> >
> > -Did we miss a step somewhere, or is this a known issue.
> >
> > Thanx in advance... 
> >
> > Jon A. Miller