> 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
