Very slow query

[Nicolas Fajersztejn]

Hi,

I'm new to iBatis. I have been using it for a couple of months and really like it.

However, now I am having problems with a very simple query. This is the mapping I have:

<select id="getExposuresForObsId" resultClass="xat.proprietarydates.objects.Exposure">
   SELECT
    obsid obsID,
    inst inst,
    epic_filter epicFilter
FROM xsa..exposures
WHERE
            obsid = #value#
</select>


obsid is a numeric value. I am passing an Integer as parameter and this query takes about 1400 ms to execute!!!
The same query run with explicit value (obsid = 100 for example) takes only 48 ms.

Does it really take so much time to convert an Integer and build up the query or am I missing something?

This is my config file in case it helps:

    <transactionManager type="JDBC">
      <dataSource type="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"/>
      <!-- The following are optional -->
      <property name="Pool.MaximumActiveconnections" value="10"/>
      <property name="Pool.MaximumIdleConnections" value="5"/>
      <property name="Pool.MaximumCheckoutTime" value="120000"/>
      <property name="Pool.TimeToWait" value="10000"/>
      <property name="Pool.PingQuery" value="select * from data_set"/>
      <property name="Pool.PingEnabled" value="false"/>
      <property name="Pool.PingConnectionOlderThan" value="0"/>
      <property name="Pool.PingConnectionNotUsedFor" value="0"/>
      </dataSource>
    </transactionManager>

<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
lazyLoadingEnabled="true"
maxRequests="32"
maxSessions="10"
maxTransactions="5"
useStatementNamespaces="false"
/>


And the Java code:

    public static List getExposuresForObsId(Integer obsID) {
        SqlMapClient sqlMap = XATSqlConfig.getSqlMapInstance();
        List exposureList = null;
        try {
            long t1 = System.currentTimeMillis();
            exposureList = sqlMap.queryForList("getExposuresForObsId", obsID);
            long t2 = System.currentTimeMillis();
            System.out.println("time queryForList is " + (t2-t1));             
        }                                  
        catch (SQLException e) {
            logger.log(Level.WARNING, "SQLException getting exposures list: " + e);
        }
        return exposureList;
    }



I would gladly appreciate your help.

Thanks.