This has little to do with servlet exactly, the same would hold good for an
application or applet
but In most cases SPs work faster than regular SQL statements (pre-compiled
and all that sort of thing)
of course you normally don't create SPs for each and every SQL statement in
your app
that would unnecessarily increase the size of the database, since SPs and
database objects and hence take up database space
pb
-----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: 16 July, 2001 8:47 PM
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
