How to mimic a subfile with java? - an easy option...

[Jim Mason <JEMason@xxxxxxxxxxxxxx>]

Hi Robert.

If you are using either WebSphere Studio or VisualAge for Java, IBM
includes a Select data access bean that provides all the capability of a
subfile and you can build it visually without writing any Java code !

You just add the Select bean to a desktop in VisualAge and connect it to a
JTable for a client / server app visually with a connection!

For a web app, use WebSphere Studio.  There is more work here for sure in
the current version (3.5.3).  Create an sql statement with the sql wizard.
Create a database jsp with the database wizard.  Here you can specify a
page size just like subfiles have for scrolling with forward and back
buttons.  It generates a jsp that you can easily modify or extend in Page
Designer for a custom look and feel etc....

Jim Mason

Jim Mason

Message text written by INTERNET:java400-l@midrange.com
>
I am attempting to write a java application that would display a customer
list loaded from a db2 file.  When the uses selects a customer it will then
bring them to a customer detail screen.

My question is, what is the best way to load this list.  The method I used
was just a dow not eof loop that appended items to a JList.  This worked
fine for my testing, with minimum records, but when you start to get into
thousands and even hundreds of thousands of records it takes quite a long
time to load.

I don't expect to be able to get subfile load speeds(can I?) but there must
be methods to allow the speeding up of this process.  Has anybody ever done
anything like this?

Any help would be greatly appreciated

Robert Upshall
Professional Software of Amarillo
(806) 358-8928
rupshall@psasoft.com
<