You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by Nguyen Trong Hoan <ho...@vips.com.vn> on 2007/05/11 05:40:36 UTC

syntax error or access rule violation - Statement id

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.

Re: syntax error or access rule violation - Statement id

Posted by 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.