You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Cesar Villar <ce...@yahoo.es> on 2006/03/08 10:19:36 UTC
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
RE: manage transaction
Posted by Cesar Villar <ce...@yahoo.es>.
I prove with that option but the behavior was the
same. If I don´t use
sqlMapClient.getCurrentConnection().setAutoCommit(false)
I can´t disable autocommit with xml config file.
Thanks.
--- Meindert <me...@pastelebusiness.com> escribió:
> In your config;
> <transactionManager commitRequired="true"
> type="EXTERNAL">
>
>
> Jeff Butler wrote on Tuesday;
> If you use an EXTERNAL transaction manager, then
> iBATIS does not do commits
> or rollbacks - even if you call the methods, they do
> nothing at all -
> because you've declared you are using an external
> transaction manager.
>
> Does that help?
>
> Meindert
> -----Original Message-----
> From: Cesar Villar [mailto:cesarvillarcar@yahoo.es]
> Sent: 08 March 2006 11:59 AM
> To: user-java@ibatis.apache.org
> Subject: RE: manage transaction
>
> 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 <me...@pastelebusiness.com>
> 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:cesarvillarcar@yahoo.es]
> > Sent: 08 March 2006 11:20 AM
> > To: user-java@ibatis.apache.org
> > 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
>
> --
> 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
HashMap's List entry for
Posted by Amad Fida <am...@yahoo.com>.
I have a following select statement,
<select id="getAccounts">
select * from accounts
<dynamic prepend="WHERE">
<iterate open="ACCOUNTS.ID IN (" close=")" conjunction=",">
#accountIdList[]#
</iterate>
</dynamic>
</select>
My parameter class is HashMap as i createa map like
Map params = new HashMap();
params.put("accountIdList", accountIds);
My assumption is that iBatis will lookup the accountIdList in the map and the returned value, which is a list will be used in <dynamic>. But I am gettng this error,
--- Cause: com.ibatis.sqlmap.client.SqlMapException: ParameterObject or property was not a Collection, Array or Iterator.
I can't figure out what I am doing wrong. Any ideas?
Amad
---------------------------------
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
RE: manage transaction
Posted by Meindert <me...@pastelebusiness.com>.
In your config;
<transactionManager commitRequired="true"
type="EXTERNAL">
Jeff Butler wrote on Tuesday;
If you use an EXTERNAL transaction manager, then iBATIS does not do commits
or rollbacks - even if you call the methods, they do nothing at all -
because you've declared you are using an external transaction manager.
Does that help?
Meindert
-----Original Message-----
From: Cesar Villar [mailto:cesarvillarcar@yahoo.es]
Sent: 08 March 2006 11:59 AM
To: user-java@ibatis.apache.org
Subject: RE: manage transaction
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 <me...@pastelebusiness.com> 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:cesarvillarcar@yahoo.es]
> Sent: 08 March 2006 11:20 AM
> To: user-java@ibatis.apache.org
> 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
--
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
RE: manage transaction
Posted by Cesar Villar <ce...@yahoo.es>.
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 <me...@pastelebusiness.com> 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:cesarvillarcar@yahoo.es]
> Sent: 08 March 2006 11:20 AM
> To: user-java@ibatis.apache.org
> 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
RE: manage transaction
Posted by Meindert <me...@pastelebusiness.com>.
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:cesarvillarcar@yahoo.es]
Sent: 08 March 2006 11:20 AM
To: user-java@ibatis.apache.org
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