RE: How to mimic a subfile with java? - an easy option... -- JAVA400-L

Ok... I just downloaded Studio to take a look at this... I'm getting stuck
on the SQL wizard.  I want to use the com.ibm.as400.access.AS400JDBCDriver
class to connect to my 400.  However, I keep getting an alert box SQL Assist
Exception that lists the driver.  I'm guessing the wizard can't find the
driver.   I've put the .jar in the
classpath:{StudioClasspath};E:\jars;e:\jars\jt400.jar.  I also took the
class out of the jar and put it in the appropriate directories.  However,
Studio keeps alerting me....

very frustrating....  Anyone know what I'm doing wrong?

dan


-----Original Message-----
From: Jim Mason [mailto:JEMason@compuserve.com]
Sent: Wednesday, October 03, 2001 7:35 AM
To: INTERNET:java400-l@midrange.com
Subject: How to mimic a subfile with java? - an easy option...


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
<

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.