The content of elements must consist of well-formed character data or markup.
The content of elements must consist of well-formed character data or markup. <![CDATA[ ]]> 부등호 사용하고 깜박했네.
Posts
Insert statements cannot be executed as a query
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...
ibatis insert all
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>
ERROR org.springframework.web.context.ContextLoader Context initialization failed
[2016-01-06 11:48:43,073] ERROR org.springframework.web.context.ContextLoader Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'AccComDAO': Injection of resource methods failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [D:\KESI\KESISRC\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\etis\WEB-INF\classes\config\spring\context-sqlMap.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [config/sqlmap/elevator/sql-map-config.xml]; nested exception is com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeExce...
insert selectKey ibatis
<insert id="SmsDAO.registSmsNuri" parameterClass="smsConnVO" > <selectKey resultClass="int" keyProperty="nuriSeq"> <![CDATA[ SELECT nuri_user.msg_data_seq.nextval FROM DUAL ]]> </selectKey> <![CDATA[ insert into nuri_user.msg_data (msg_seq, req_date, cur_state, call_to, call_from, sms_txt, msg_type, user_id, site_cd ) values (#nuriSeq#, sysdate, #curState#, #callTo#, #callFrom#, #text#, #msgType#, #userID#, '01' ) ]]> </insert>