Have the servlet call an entity CMP EJB. If you ever need to change the
database, no problem. If you ever need to change the SQL, just change the
text in the deployment descriptor. Plus the EJB container will handle all
transactions and pooling. Finally, it give you another layer of abstraction
from the business logic and presentation layer.
Cheers!
Mark
----- Original Message -----
From: "Tom & Sharon Kochanowicz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 11:44 AM
Subject: Re: JDBC within a Servlet
> If you want to stay vendor neutral and still have good performance, I
would
> use prepared statements.
>
>
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> Shannyn Barr
> Sent: Monday, July 16, 2001 10:17 AM
> To: [EMAIL PROTECTED]
> Subject: JDBC within a Servlet
>
>
> Does anyone have an opinion either way on which way would be best from
> within a servlet?
>
> -Using JDBC to call a stored procedure in order to update the DB (Oracle
8i)
>
> or
>
> -Using JDBC to directly perform the update procedure
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
