RE: Preferred method to access databases from Servlets

I am afraid I have to disagree with you David. We house the AS400 Record
Level Access classes from the AS400 Tool box for java and we get speed ten
to fifteen times quicker then anything jdbc or sql could produce. We package
these up in a standard interface so that we can switch them out if the
backend changes but as yet we have not needed to do that. If speed and for
that matter security is any concern at all look at the Record Level Access
classes. If you do it correctly you will have speed as well as the potential
for portability. If you are a dedicated AS400 shop then portability may not
be an issue. I do agree with David in that you hide the access in some type
of interface or driver class and in that you move to version 3.5 which will
be out on the 28th of this month. We have been using 3.5 for a little while
now and have found it to be much superior to any of the other websphere
products so far. Be aware though that it implements Java 1.2.2 (Java2), this
should not matter so much if you stuck to the core servlet api. In any case,
we did not have to make any code changes when we moved over.

Hope this helps more then confuses,
Eric


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
+---
| 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
+---