Auto commit in Jakarta taglib?

[Roland Dong]

I have some programs which uses pre-jstl jakarta taglib.  I want to have the
query commit only if there is no errors. However, I could not find in tags
for setting "autocommit".

Tried to add <%conn.setAutoCommit(false);%> but that doesn't work. So I am
wondering if there is a workaround other than rewriting everything using
other tag library(I know struts has it).

Thanks in advance.

RD


The is a code example I used to test auto commit.

=============================
<%-- Taglib Directives --%>
<[EMAIL PROTECTED] uri="http://database.cait.org/dbtags"; prefix="sql"   %>

<-database connection--%>
<%@ include file="../includes/dbConnection.jsp"%>


<sql:statement id="stmt" conn="conn">


      
          <sql:query>
             INSERT INTO school
             VALUES (
                       '666',
                       'rd',
                       'street1',
                       'city1',
                       'county1',
                       'state1',
                       'zip1',
                       'phone1'
                      )
          </sql:query>
          <sql:execute />
       
        <sql:query>
             INSERT INTO school1
             VALUES (
                       '888',
                       'rd',
                       'street1',
                       'city1',
                       'county1',
                       'state1',
                       'zip1',
                       'phone1'
                      )
          </sql:query>
          <sql:execute />
       
     </sql:statement>
      
      OK! 
     <%-- Close database connection --%>
<sql:closeConnection conn="conn"/>
===================================
             


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]