Re: Disable Transactions into Ibatis How can I do

Tue, 03 Jan 2006 09:12:06 -0800 

<transactionManager type="EXTERNAL">


b


Fabrice MERCIER wrote:

To begin  : Happy new year !-D
More seriously (sorry) I use Ibatis for lot of projects it’s a nice and convenient framework !
At the moment I would like to disabled any transaction into ibatis because requests are embeded into procedure executed on a SQL Server side 


Bellow an extract of my config :


*DAO.XML*


<?xml version="1.0" encoding="UTF-8"?>


<!DOCTYPE daoConfig

    PUBLIC "-//iBATIS.com//DTD DAO Configuration 2.0//EN"

    "http://www.ibatis.com/dtd/dao-2.dtd";>


<daoConfig>


  <properties resource="database.properties"/>


  <context>


    <transactionManager type="SQLMAP">
<property name="SqlMapConfigResource" value="sqlmapdao/sql/sql-map-config.xml"/> 

    </transactionManager>


…

</context>


*SQL-MAP-CONFIG.XML*


<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd";> 


<sqlMapConfig>


  <settings

    cacheModelsEnabled="true"

    enhancementEnabled="true"

    maxSessions="64"

    maxTransactions="8"

    maxRequests="128"/>


  <transactionManager type="JDBC">

    <dataSource type="SIMPLE">

                  <property name="JDBC.Driver"        value="${driver}"/>
<property name="JDBC.ConnectionURL" value="${url}${dataBaseName}"/> 

                  <property name="JDBC.Username"      value="${username}"/>

                  <property name="JDBC.Password"      value="${password}"/>
* **<**property **name**=**"JDBC.DefaultAutoCommit" **value**=**"false"**/>***
<property name="Pool.PingQuery" value="select @@VERSION"/> <property name="Pool.PingEnabled" value="true"/> 
      <property name="Pool.MaximumActiveConnections" value="10"/>

      <property name="Pool.MaximumIdleConnections"   value="5"/>

      <property name="Pool.MaximumCheckoutTime"      value="120000"/>

    </dataSource>

  </transactionManager>


I disabled default autoCommit but when I check a dump of catalina.out

I can see that transaction are still actived !!!


EXAMPLE :
"TP-Processor119" daemon prio=1 tid=0x08f48030 nid=0x9a8 in Object.wait() [ab689000..ab68a8b8] 

      at java.lang.Object.wait(Native Method)

      at java.lang.Object.wait(Object.java:429)

      at com.ibatis.common.util.Throttle.increment(Throttle.java:69)

      - locked <0x47de5658> (a java.lang.Object)

      at com.ibatis.common.util.ThrottledPool.pop(ThrottledPool.java:60)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.popSession(SqlMapExecutorDelegate.java:910)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.<init>(SqlMapSessionImpl.java:50)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.getLocalSqlMapSession(SqlMapClientImpl.java:214)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.startTransaction(SqlMapClientImpl.java:102)
at com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransaction.<init>(SqlMapDaoTransaction.java:31)
at com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransactionManager.startTransaction(SqlMapDaoTransactionManager.java:65)
at com.ibatis.dao.engine.impl.DaoContext.startTransaction(DaoContext.java:91) 

      at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:71)

      at $Proxy3.getIntervenantById(Unknown Source)
at com.mm123.tchatanim.business.impl.IntervenantManagerImpl.getIntervenantById(IntervenantManagerImpl.java:69)
at com.mm123.tchatanim.business.impl.ContextImpl.initialize(ContextImpl.java:111)
at com.mm123.tchatanim.business.impl.ContextImpl.initialize(ContextImpl.java:87)
at com.mm123.tchatanim.business.ContextFactory.getContext(ContextFactory.java:34)
at org.apache.jsp.e_002daccueil.e_002daccueil_jsp._jspService(e_002daccueil_jsp.java:69) 

      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) 

      at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300) 

      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)

      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675) 

      at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) 

      at java.lang.Thread.run(Thread.java:534)
"RUNNING" daemon prio=1 tid=0x08a26310 nid=0x9a8 in Object.wait() [9df0b000..9df0b8b8] 

            at java.lang.Object.wait(Native Method)

            at java.lang.Object.wait(Object.java:429)

            at com.ibatis.common.util.Throttle.increment(Throttle.java:69)

            - locked <0x47de5658> (a java.lang.Object)
at com.ibatis.common.util.ThrottledPool.pop(ThrottledPool.java:60)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.popSession(SqlMapExecutorDelegate.java:910)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.<init>(SqlMapSessionImpl.java:50)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.getLocalSqlMapSession(SqlMapClientImpl.java:214)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.startTransaction(SqlMapClientImpl.java:102)
at com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransaction.<init>(SqlMapDaoTransaction.java:31)
at com.ibatis.dao.engine.transaction.sqlmap.SqlMapDaoTransactionManager.startTransaction(SqlMapDaoTransactionManager.java:65)
at com.ibatis.dao.engine.impl.DaoContext.startTransaction(DaoContext.java:91) 

            at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:71)

            at $Proxy0.getConnectedSessionId(Unknown Source)
at com.mm123.tchatanim.business.impl.AnimStatManagerImpl.getStatsSessionId(AnimStatManagerImpl.java:832)
at com.mm123.tchatanim.business.impl.AnimStatClientListener.messageCreated(AnimStatClientListener.java:145)
at com.mm123.tchat.surv.impl.SurvClientCore.receiveMessageCreated(SurvClientCore.java:664)
at com.mm123.tchat.surv.server.socket.ActionsToSurvClientImpl.survMessageCreated(ActionsToSurvClientImpl.java:81)
at com.mm123.tchat.common.comm.tosurv.SurvMessageCreatedCommand.doTheProcessing(SurvMessageCreatedCommand.java:85)
at com.mm123.socketcom.command.Command$CommandRun.run(Command.java:134)
at com.mm123.socketcom.pool.PooledThreadManager.process(PooledThreadManager.java:125)
at com.mm123.socketcom.pool.PooledThread.run(PooledThread.java:88) 


Could you please help me to disabled totally transaction

And how can I do set a timeOut for each request ???


Thanks a lot


Fabrice

Reply via email to