Mybatis tag cause SAXParseException

Question

i'm using mybatis in my app. I'm using bind tag in my select element. This is my mapper code:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="myapp.model.MyDAO">
        <select id="mySelect" parameterType="myapp.model.MyParameterBean" resultType="hashmap">
        <bind name="SL" value="_parameter.getSelectList()" />
        <bind name="TNS" value="_parameter.getTableNameSuffix()" />
        SELECT NAME
        #{SL}
        FROM MYTABLE_#{TNS}
        </select>
    </mapper>

When i try to compile my app, i get a SAXParseException. Detailed error message is:

Failed to parse mapping resource: 'file [C:\myapp\model\myMapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: org.xml.sax.SAXParseException: Element type "bind" must be declared. Have you any idea about this bahaviour?

I'm using spring-mvc. For spring-mybatis integration I included mybatis-spring-1.1.0.jar.

Hi to all!

What are you trying to achieve? In this example I don't see any reason to use bind? — maks, Apr 14 '14 at 09:54
I know, i could use bind variable in this case. I need mechanism to insert entire custom sections in my select statement. For example i could need to modify select list or table_names or change completely where conditions. — javaduke, Apr 14 '14 at 09:59

score 0 · Answer 1 · answered Apr 14 '14 at 10:26

In my case is all completely dynamic.select list or table name suffix depends on parameters.

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="myapp.model.MyDAO">
<select id="mySelect" parameterType="myapp.model.MyParameterBean" resultType="hashmap">
    <bind name="SL" value="_parameter.getSelectList()" />
    <bind name="TNS" value="_parameter.getTableNameSuffix()" />
    SELECT NAME
    #{SL}
    FROM MYTABLE_#{TNS}
</select>
</mapper>

score -1 · Answer 2 · answered Apr 14 '14 at 10:06

-1

Example of <sql> and <include> tags

<sql id="columns">
   SURNAME,ADDRESS
</sql>

<select id="mySelect" resultType="hashmap">
    SELECT NAME,
    <include refid="columns">
    FROM MYTABLE
</select>

answered Apr 14 '14 at 10:06

maks

5,911
17
79
123

Mybatis tag cause SAXParseException

2 Answers2