Hello all, new to iBatis, here goes.

I have a table structure like this:

create table zomg_zh (
    id         int(10) not null,
    name   varchar(64) null,
    age      int(10) null,
    primary key(id),
    unique(id)
)

create table zomg_er (
    id         int(10) not null,
    name   varchar(64) null,
    age      int(10) null,
    primary key(id),
    unique(id)
)

and an object like this (brevity):

public class NotImportant {
     void setId(Long id);
     Long getId();
     void setName(String name);
     String getName();
     void setAge(Long age);
     Long getAge();
    
     // special stuff
     String getTableName();
     void setTableName(String name);
}

SqlMappingFile:

<sqlMap>
    <typeAlias alias="notImportant" type="com.my.ball.NotImportant" />

    <!--
     | table structure
     +-->
    <resultMap id="result" class="notImportant">
        <result property="id" column="id" />
        <result property="name" column="name" />
        <result property="age" column="age" />
    </resultMap>

    <!--
     | select all
     +-->
    <select id="readAll" resultMap="result" parameterClass="notImportant">
        select * from zomg_#tableName#  -- **** NOTICE THIS ****
    </select>

    <insert id="insert" parameterClass="notImportant">
        insert into zomg_#tableName# (
            id, name, age)
        values (
            #id#,
            #name#,
            #age#)
    </insert>
  </sqlMap>



calling getSqlMapClient().queryForList("readAll", notImportantObj); leads to a MySQLSyntaxException because it creates a query like this: '   select * from zomg_'zh'   '; while this exception makes perfect sense to me (it seems natural for iBatis to surround a string with ' '); I would love to know how to solve this problem.

So my goal here is to basically map many tables to 1 object.  There is no inheritance that makes sense in my particular object model, which would be the way I would think about solving this with hibernate.  Obviously I've created a dummy example to not bring any added complexity in this example.  Is this possible to do with iBatis?

Basically I have massive amounts of data for each of these tables, or I wouldn't be looking to do this.

Thanks,

failuser