ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: sql server 2k parameterized queries
Date Thu, 23 Mar 2006 03:51:06 GMT
Can you post the mapped statement?

Larry


On 3/22/06, Bob <gnomeking@gmail.com> wrote:
>
> I'm trying to use ibatis with sql server 2k, and I'm having problems
> with parameterized queries.  I have many parameterized queries working
> with mysql, and I'm really confused as to why this is causing a
> problem.  The query is set up very similarly to all the mysql ones
> (except it is trying to put the results in a list of hashmaps rather
> than of beans)
>
> I am recieving the following exception when trying to use the query.
>
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred while applying a parameter map.
> --- Check the getPayoutOrgData-InlineParameterMap.
> --- Check the statement (query failed).
> --- Cause: java.sql.SQLException: Incorrect syntax near the keyword
> 'GROUP'.
> Caused by: java.sql.SQLException: Incorrect syntax near the keyword
> 'GROUP'.
>         at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> (GeneralStatement.java:185)
>         at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList
> (GeneralStatement.java:123)
>         at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
> SqlMapExecutorDelegate.java:610)
>         at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
> SqlMapExecutorDelegate.java:584)
>         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(
> SqlMapSessionImpl.java:101)
>         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(
> SqlMapClientImpl.java:78)
>
> SQL Profiler suggests that the following is being executed by Ibatis
> create proc #jtds000002 @P0 nvarchar(4000) as SELECT <blah> WHERE @P0
> GROUP BY <blah>
>
> Running that query in Query Analyser indeed gives the same error that
> there is an incorrect syntax near "GROUP".
> However, if I run the query stripping out the proc and @P0 and
> replacing it with the actual parameter, it works flawlessly.
>
> Does Ibatis support parameterized queries with SQL Server 2000?
> Can anyone think of anything I might be doing wrong to get this error?
> Would more information on any part of the problem be helpful?
>
> I would grately appreciate any help or suggestions - I am prepared to
> consider anything! I've been really struggling with this and am
> stumped at the moment.
>
> Thanks a lot,
>
> Bob Ball
>

Mime
View raw message