Hi,

I used this mapping to get the schema information for a table:


    <parameterMap id="select-field-para" class="fieldParameter">
      <parameter property="table" />
      <parameter property="schema" />
    </parameterMap>

    <statement id="getFieldList" parameterMap="select-field-para">
      show columns from ? from ?
    </statement>



when I set table="product" schema="jpetstore" in fieldParameter class (both
schema and table are java String type). I really want a sql statement like
this

    " show columns from product from jpetstore "

But iBATIS will generate a statement like this:

    " show columns from 'product' from 'jpetstore' "

So MySQL database always complaint an error.

How to fix it?

Thank you very much!

Peter


Reply via email to