Hi all,
In my project I use ibatis, but while executing sql statement
"getNoticeFromAdmin", I've got the following error:
Error executing query for object. Cause: syntax error or access rule
violation - Statement id (getNoticeFromAdmin). More detail:
--- The error occurred in
jp/imagecity/emc/database/resourse/sqlmapdao/EmcNoticeFromAdmin.xml.
--- The error occurred while applying a parameter map.
--- Check the getNoticeFromAdmin-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-00911: invalid character
My sqlMap as the following:
<sqlMap namespace="EmcNoticeFromAdmin">
<typeAlias alias="emcNoticeFromAdmin"
type="jp.imagecity.emc.domainmodel.bd.EmcNoticeFromAdmin"/>
<resultMap id="emcNoticeFromAdminResult" class="emcNoticeFromAdmin">
<result property="message" column="message" />
<result property="registered" column="registered" />
<result property="voiceTime" column="voice_time" />
<result property="voiceRecFlg" column="voice_rec_flg" />
<result property="voiceLob" column="voice_lob" />
</resultMap>
<select id="getNoticeFromAdmin" resultMap="emcNoticeFromAdminResult"
parameterClass="emcBase">
SELECT
message,
registered,
voice_time,
voice_rec_flg,
voice_lob
FROM
$schema$.emc_notice_from_admin;
</select>
</sqlMap>
Can you give me some help?
Thank you very much.