Re: Preferred method to access databases from Servlets

["David Duerr" <dduerr@xxxxxxxxxxxxxxxxx>]

Hello,

First, from an architecture perspective, you would not want to access the
database within a servlet, or any ui class for that matter.  You should
create classes that handle database functions solely.   Your servlets and
other classes can utilize these database access classes for db functions.

In regard to your question,  you will have to use both SQL and JDBC to some
extent.  For update, insert, and delete functions, JDBC is a little easier
to code, but I think most of us who are familiar with SQL continue to use
it.

However, I think most java shops at this point either have a database
framework or are implementing EJBs.  So direct database coding in java,
except for an occasional SQL query, is essentially a thing of the past.

In any regard, I would not use the as/400 access classes.  Also, I would
highly recommend upgrading your websphere to 3.02.

Thanks,
Dave


----- Original Message -----
From: Patrick L Archibald <Patrick.Archibald@HOMETELCO.COM>
To: <JAVA400-L@midrange.com>
Sent: Friday, September 15, 2000 2:53 PM
Subject: Preferred method to access databases from Servlets


> Hi
>
> Please list the methods available and tell me
> what is the preferred method for reading,
> adding, deleting, and updating database
> records from Java Servlets on the AS/400 V4R4M0
> WebSphere V1.1?
>
> SQL, JDBC?
>
> Thanx, Patrick
> /
> / Patrick    L    Archibald
> / Home Telephone Company
> / Moncks Corner SC USA
> / http://www.HomeTelco.Com/pla/
> / 1-843-761-9190
> /
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to JAVA400-L@midrange.com.
> | To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: joe@zappie.net
> +---
>


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---