turtle

ERROR kr.go.elevator.rep.cont.service.impl.KeepMsMngServiceImpl SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Insert statements cannot be executed as a query.; nested exception is java.sql.SQLException: Insert statements cannot be executed as a query. java.sql.SQLException: Insert statements cannot be executed as a query. at com.ibatis.sqlmap.engine.mapping.statement.InsertStatement.executeQueryForList(InsertStatement.java:40) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209) at org.springfr...

alter table table_name drop column column_name <insert id="insep.insertkeepCont"  parameterClass="java.util.List"> <![CDATA[ INSERT ALL ]]> <dynamic> <iterate conjunction="  "> <![CDATA[ INTO table_name (KEEP_NO , MGT_NO1 , MGT_NO2 , e_NO , SEL_CHK_MM ) VALUES ]]> (#[].keepNo# ,#[].mgtNo1# ,#[].mgtNo2# ,#[].eNo# ,#[].selChkMm# ) </iterate> <![CDATA[ SELECT * FROM DUAL ]]> </dynamic> </insert>

alter table table_name drop column column_name select * from table_name