|
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 |
- Re: fill SQL string variable without single quotes Peter Cai
- Re: fill SQL string variable without single quotes Larry Meadors

