hello there
i use dbconnection too... but i have some trouble.
in my application the dbclasses get a connection from the pool,
then they call a stored procedure and return the connection to the pool.
this works fine until the stored procedures returns a resultset. but
i have insert or update-sp that don't return a resultset. the next time i
use this connection from the pool, i always get an odbc-exception
"connection is busy". i tried different ways to execute the stored
procedure.
the only workaround i've found till now is to "kill" the connection in the
pool and
get a new one.
does someone have any clue?
thanks
Sandro
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html