Pool problem

[Inés Pederiva <in...@sol.info.unlp.edu.ar>]

    Hi everyone!
    I have a problem with the pool of connectcions that struts provides.
    I work with Microsoft SQL-Server and when I query my database (all through stored procedures) everything works fine. 
    The problem is when I call a stored procedure to update or delete some data. It does not update it neither delete tthe data!!!
    It´s a problem of the connection because if I call that stored procedure with a new connection that i create, everything works ok!
    Thanks a lot!!
Bye!
Inés Pederiva

RE: Pool problem

[Roumen Ganeff <ga...@wizcom.bg>]

check to see if you have the property of the datasource/connection
autocommit=true;
or you shoudl call after each update
connection.commit()

G.

-----Original Message-----
From: Inés Pederiva [mailto:ines@sol.info.unlp.edu.ar]
Sent: Thursday, November 15, 2001 1:36 PM
To: struts-user@jakarta.apache.org
Subject: Pool problem


    Hi everyone!
    I have a problem with the pool of connectcions that struts provides.
    I work with Microsoft SQL-Server and when I query my database (all
through stored procedures) everything works fine.
    The problem is when I call a stored procedure to update or delete some
data. It does not update it neither delete tthe data!!!
    It´s a problem of the connection because if I call that stored procedure
with a new connection that i create, everything works ok!
    Thanks a lot!!
Bye!
Inés Pederiva


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>