I am creating a table dynamically.
CREATE TABLE #tableName# (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
Hi--
Try $tableName$ rather than #tableName#
See page 32 here for more:
http://svn.apache.org/repos/asf/ibatis/java/ibatis-2/trunk/ibatis-2-docs/en/iBATIS-SqlMaps-2
gt; at java.lang.reflect.Method.invoke(Method.java:585)
> at
> com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)
> at $Proxy5.execute(Unknown Source)
> at
> com.
lStatement.sqlExecuteUpdate(GeneralStatement.java:200)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
... 32 more
--
View this message in context:
http://old.nabble.com/Ibatis-Mysql-Sql-error-but-sql-runs-fine-tp28219