[ http://issues.apache.org/jira/browse/IBATIS-85?page=history ]
Clinton Begin closed IBATIS-85:
-------------------------------
Resolution: Invalid
Use $substitution$ syntax, not #parameter# syntax. See the PDF guid for more.
> Textual substitution for parameterized queries
> ----------------------------------------------
>
> Key: IBATIS-85
> URL: http://issues.apache.org/jira/browse/IBATIS-85
> Project: iBatis for Java
> Type: New Feature
> Components: SQL Maps
> Versions: 2.0.9b
> Environment: SQL Server 2000, Win XP, Tomcat, JDK 1.4
> Reporter: Vadim Pesochinskiy
>
> Problem Description:
> Unable to execute parameterized query using SQL Server TOP keyword. TOP
> allows you to return the specified number of rows from a result set.
> Query below fails with SQLException: Line 1: Incorrect syntax near '@P1'.
> <select id="getRecentAlerts.sqlserver" resultMap="alertResult"
> parameterClass="int">
> SELECT TOP #value# *
> FROM ods_exception_alert
> ORDER BY alert_time DESC
> </select>
> This one executes OK (replaced "value" for troublshooting).
> <select id="getRecentAlerts.sqlserver" resultMap="alertResult"
> parameterClass="int">
> SELECT TOP 5 *
> FROM ods_exception_alert
> ORDER BY alert_time DESC
> </select>
>
> I know this is JDBC driver problem, but it would be great if iBATIS allowed
> doing text substitutions as a work-around. At the moment I guess I will have
> to rewrite SQL with sub selects. Is there another way to work-around this?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
