RE: Countng Rows

Mon, 04 Jul 2005 01:28:31 -0700

public class DaoConfig {

 

  private static final DaoManager daoManager;

 

  static {

 

    try {

      String resource = "net/naijatek/fgconline/persistence/dao.xml";

      Reader reader = Resources.getResourceAsReader(resource);

      daoManager = DaoManagerBuilder.buildDaoManager(reader);

    } catch (Exception e) {

      throw new RuntimeException("Could not initialize DaoConfig.  Cause: " + e);

    }

  }

 

  public static DaoManager getDaomanager() {

    return daoManager;

  }

}

 

 

 

 

<?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="net/naijatek/fgconline/properties/database_dev_local.properties"/>

 

  <context>

 

   <transactionManager type="JDBC">

      <property name="DataSource" value="SIMPLE"/>

      <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="JDBC.DefaultAutoCommit" value="true"/>

      <property name="Pool.MaximumActiveConnections" value="15"/>

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

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

    </transactionManager>

 

    <dao interface="net.naijatek.fgconline.persistence.iface.MemberDAO" implementation="net.naijatek.fgconline.persistence.sqlmapdao.IbatisMemberDAO"/>

 

  </context>

</daoConfig>

 

From: Clinton Begin [mailto:[EMAIL PROTECTED]
Sent: Monday, July 04, 2005 12:37 AM
To: [email protected]
Subject: Re: Countng Rows

 


Interesting.  It looks like the CCE is coming from a bad transaction implementation.  Here's the line it's popping on...

SqlMapDaoTransaction trans = (SqlMapDaoTransaction) daoManager.getTransaction(this);

So the transaction implementation is not an instance of SqlMapDaoTransaction. 

What transaction manager are you using (i.e can you post your DAO config)?

Cheers,
Clinton

On 7/3/05, Folashade Adeyosoye <[EMAIL PROTECTED]> wrote:

I have quick question please… I am trying to run a select count(*) and seem to be getting a ClassCast Exception… here is the code.

 

I think it might be related to the Integer been returned.

 

Any help would be appreciated.

 

Thanks

 

 

 

 

(XML)

// ADMIN ROLE:  count all members that have an avatar

// MEMBER ROLE : count all members that have an avatar if member status is ACTIVE

 

  <statement id="searchCountAvatar" resultClass="java.lang.Integer" parameterClass="memberObject">

 

      SELECT COUNT(*) FROM FGC_MEMBERS where MemberAvatar != #memberAvatar#

      <dynamic prepend="where">

        <isEqual prepend="and" property="memberRole" compareValue="MEMBER">

          MemberStatus = #memberID#

        </isEqual>

      </dynamic>

  </statement>

 

 

 

 

(JAVA)

 

  public int searchCountAvatar(String role) throws DaoException{

 

    IMember mem = new MemberImpl();

    Object parameterObject = null;

    //int count = 0;

    Integer count;

 

    try {

      mem.setMemberAvatar(FGCConstants.BLANK);

      mem.setMemberRole(role);     // role  == MEMBER or ADMIN

      mem.setMemberStatus(FGCConstants.ACCOUNT_ACTIVE);

      parameterObject = mem;

      count = (Integer) queryForObject("searchCountAvatar", parameterObject);

 

    }

    catch (DaoException sqlEx) {

      logger.fatal("DaoException Error. " + sqlEx.getMessage());

      throw new DaoException(sqlEx.getMessage());

    }

    return ((Integer)count).intValue();

    //return count;

  }

 

 

 

EXCEPTION

=========== Starting testSearchCountAvatar ==============

INFO [2005-Jul-03 21:36:59] - sqlmapdao.BaseSqlMapDao(BaseSqlMapDao.java:30) - BaseSqlMapDao static block starting...

DEBUG[2005-Jul-03 21:36:59] - sqlmapdao.BaseSqlMapDao(BaseSqlMapDao.java:33) - reader = [EMAIL PROTECTED]

DEBUG[2005-Jul-03 21:37:00] - sqlmapdao.BaseSqlMapDao(BaseSqlMapDao.java:35) - sqlMap = [EMAIL PROTECTED]

INFO [2005-Jul-03 21:37:00] - sqlmapdao.BaseSqlMapDao(BaseSqlMapDao.java:37) - BaseSqlMapDao static block finished...

DEBUG[2005-Jul-03 21:37:07] - jdbc.SimpleDataSource(SimpleDataSource.java:579) - Created connection 6400263.

DEBUG[2005-Jul-03 21:37:07] - sql.Connection(ConnectionLogProxy.java:42) - {conn-100000} Connection

DEBUG[2005-Jul-03 21:37:13] - jdbc.SimpleDataSource(SimpleDataSource.java:527) - Returned connection 6400263 to pool.

java.lang.ClassCastException

            at com.ibatis.dao.client.template.SqlMapDaoTemplate.getSqlMapExecutor(SqlMapDaoTemplate.java:60)

            at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java:162)

            at net.naijatek.fgconline.persistence.sqlmapdao.IbatisMemberDAO.searchCountAvatar(IbatisMemberDAO.java:3358)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:324)

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

            at $Proxy0.searchCountAvatar(Unknown Source)

            at net.naijatek.fgconline.service.FGCServiceImpl.searchCountAvatar(FGCServiceImpl.java:1269)

            at net.naijatek.fgconline.framework.FgcDriver.testSearchCountAvatar(FgcDriver.java:98)

            at net.naijatek.fgconline.framework.FgcDriver.main(FgcDriver.java:66)

Hit uncaught exception com.ibatis.dao.client.DaoException

com.ibatis.dao.client.DaoException

            at net.naijatek.fgconline.framework.FgcDriver.main(FgcDriver.java:78)

 

 

Reply via email to