ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chema <demablo...@gmail.com>
Subject Re: Possible to get ibatis to throw an exception if not all params are filled in?
Date Thu, 03 Jun 2010 21:42:18 GMT
Why dont you perform the parameter checking in you Java method ?

I guess that the definition of the query is not the right place to
manage when throwing Java exceptions


2010/6/3 laredotornado <laredotornado@gmail.com>:
>
> Hi,
>
> We're using iBatis 2.3 with Tomcat 6.0.26 (Java 1.6).  We have many queries
> where we pass in parameters (e.g. "#company_id#"), similar to
>
>        <select id="getNightlifeDetailsForHotels"
> resultMap="SearchResultSQLMaps.searchResultNightlifeMap"
> parameterClass="java.util.Map">
>                SELECT vw_attractions_and_activities.* FROM
> vw_attractions_and_activities WHERE (propertyid = #company_id#) and
> (subcategoryid = 7) ORDER BY name
>        </select>
>
> I was wondering if there is a way to get ibatis to throw an exception if not
> all the parameters are filled in.  Right now, it just substitutes a "null"
> for parameters that are not included.
>
> Here is an example Java method we use to invoke a query ...
>
>        public static Object queryForObject(String newStmtId, Object inputParams)
> throws SQLException {
>                if (inputParams.getClass() == HashMap.class || inputParams.getClass()
==
> Hashtable.class)
>                        inputParams = preProcessParameters((Map) inputParams);
>                return getSqlMapHandle().queryForObject(newStmtId, inputParams);
>        }
>
> Thanks, - Dave
> --
> View this message in context: http://old.nabble.com/Possible-to-get-ibatis-to-throw-an-exception-if-not-all-params-are-filled-in--tp28773130p28773130.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message