Re: syntax error or access rule violation - Statement id

[Larry Meadors <lm...@apache.org>]

http://ora-00911.ora-code.com/

My guess is that $schema$ is not defined.

Larry


On 5/10/07, Nguyen Trong Hoan <ho...@vips.com.vn> wrote:
>
>
> 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.