You can set a property named schema to your properties file, then
"select ... from ${scema}.table..." will do it.
Larry
On 7/20/07, Givler, Eric <[EMAIL PROTECTED]> wrote:
Does Ibatis support the ability to add a property definition to the <sqlmap>
that would allow me to specify the schema name (I didn't see it in the DTD)?
The problem is that the SCHEMA has changed between development boxes and
all the queries reference an incorrect schema. I'd like to have my select
have:
select <column list>
from {schema}.TABLE
I don't have privileges to create public synonyms, and our applications run
under a different account than the object owner, so the schema prefixes the
object name.
Eric
