Thanks!!
I've changed the reference of ibatis.com to
ibatis.apache.org, but the problem is still there.
The only way that solve the question is to set
autocommit programatically before starting transaction
try{
getMapCliente().getCurrentConnection().setAutoCommit(false);
getMapCliente().startTransaction();
int res = getDao().deleteProyectos(l);
BUSFactory.getItemBUS().deleteItemsByProyectos(l);
getMapCliente().commitTransaction();
return res;
}finally{
getMapCliente().endTransaction();
}
but i don't think that it's the right way.
Thanks.
--- Meindert <[EMAIL PROTECTED]> escribió:
> You have a reference to ibatis.com;
> <!DOCTYPE daoConfig PUBLIC "-//iBATIS.com//DTD DAO
> Configuration 2.0//EN"
> "http://www.ibatis.com/dtd/dao-2.dtd";>
>
> This must be;
> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map
> 2.0//EN"
> "http://ibatis.apache.org/dtd/dao-2.dtd";>
>
> And for the sql maps
> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map
> 2.0//EN"
> "http://ibatis.apache.org/dtd/sql-map-2.dtd";>
>
> MEINDERT HOVING
> -----Original Message-----
> From: Cesar Villar [mailto:[EMAIL PROTECTED]
> Sent: 08 March 2006 11:20 AM
> To: [email protected]
> Subject: manage transaction
>
> Hello everybody!!! I'm begginer with iBatis and i'm
> having a problem.
> I use DaoManager to retrieve my DAOs and
> sqlMapClient
> to manage transactions.
> These are my configuration files:
> <!DOCTYPE daoConfig PUBLIC "-//iBATIS.com//DTD DAO
> Configuration 2.0//EN"
> "http://www.ibatis.com/dtd/dao-2.dtd";>
> <daoConfig>
> <context>
> <transactionManager type="SQLMAP">
> <property name="SqlMapConfigResource"
> value="sql-map-config.xml" />
> </transactionManager>
> <dao interface="CapaDAO"
> implementation="impl.CapaDAOImpl"/>
> </context>
> </daoConfig>
>
> <sqlMapConfig>
> <properties resource="db.properties" />
> <settings useStatementNamespaces="true" />
> <transactionManager commitRequired="true"
> type="EXTERNAL">
> <property name="SetAutoCommitAllowed"
> value="false"/>
> <property name="DefaultAutoCommit"
> value="false"/>
> <dataSource type="SIMPLE">
> <property name="JDBC.DefaultAutoCommit"
> value="false"/>
> <property name="JDBC.Driver"
> value="${driver}"/>
> <property name="JDBC.ConnectionURL"
> value="${url}"/>
> <property name="JDBC.Username"
> value="${username}"/>
> <property name="JDBC.Password"
> value="${password}"/>
> <property name="Pool.MaximumCheckoutTime"
> value="1000"/>
> <property name="Pool.TimeToWait"
> value="1000"/>
> </dataSource>
> </transactionManager>
> <sqlMap resource=" ......
>
> The question is that i want to manage the
> transaction
> from my business classes. I want iBatis to commit o
> rollback when I need. In one of my business classes
> i
> have the following code:
> try{
> getMapCliente().startTransaction();
> int res = getDao().deleteProyectos(l);
>
> BUSFactory.getItemBUS().deleteItemsByProyectos(l);
> getMapCliente().commitTransaction();
> return res;
> }finally{
> getMapCliente().endTransaction();
> }
>
> I throw an Exception from the method
> BUSFactory.getItemBUS().deleteItemsByProyectos(l),
> so
> a rollback has to be executed. But, actually, after
> getDao().deleteProyectos(l) a commit is executed
> instead of a rollback.
> What am i doing wrong?
> I'm using eclipse 3.1, iBatis 2.1.5 and MySQL 5.0.18
>
> Thanks a lot
>
>
>
> ______________________________________________
> LLama Gratis a cualquier PC del Mundo.
> Llamadas a fijos y móviles desde 1 céntimo por
> minuto.
> http://es.voice.yahoo.com
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 268.2.0/276 -
> Release Date: 07/03/2006
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 268.2.0/276 -
> Release Date: 07/03/2006
>
>
>
______________________________________________
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
