Hello,

I would like to use static parameters that I can set in a config file directly in SQL queries. I need it especially for the MS SQL database owner that I want neither to hard code in SQL nor to pass as a parameter from Java code each time I execute queiries. I tried to define a "dbOwner" setting in properties.config, but it didn't work with the following code:

<sqlMap namespace="Students">
  <select id="isStudent" resultClass="java.lang.Integer">
      SELECT count(*)  FROM ${dbOwner}.students WHERE id = #value#
  </select>  </sqlMap>

Is it possible in any other way with iBatis?

Thanks a lot in advance
Ilya

Reply via email to