Thanks.
Even if I have to use very large SQL statements, is it not worthwhile
(performance wise) to use SP's ??
What's the reason??
TIA
Gaurav
jon * wrote:
> > H1,
> > I am trying to use the following code, in my servlet.
> > The code creates a simple Stored Procedure and executes it. I am using
> > Oracle 7.2.3 and Apache JServ.
> > The motive here is to learn how to use 'Stored Procedures' using JDBC in
> > Servlets.
> > The code compiles without error, but it fails to actually add a record
> > to the database.
> > What could be the reason??
> > Any help is highly appreciated!
> > TIA
> > Gaurav
>
> I understand the need to learn how to create/execute stored procedures, but
> from my experience with working with SP's with Java Servlets, they have
> actually been quite a bit slower than just executing the code directly so in
> a way, you /might/ be wasting your time.
>
> BTW, you can use Village or Town to do exactly what you are doing in just a
> few lines of code and it is a lot less complicated/overhead than what you
> are doing.
>
> TableDataSet tds = new TableDatSet ( connection, "my_table" );
> Record rec = tds.addRecord ();
> rec.setValue ("Name", "George" );
> rec.setValue ("Age", 32 );
> rec.setValue ("Sex", "Yes" );
> rec.setValue ("Address", "San Francisco");
> rec.save();
> tds.close();
>
> <http://www.working-dogs.com/village/>
>
> or
>
> <http://www.working-dogs.com/town/>
>
> -jon
>
> ___________________________________________________________________________
> 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
