ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: iBATIS and Schema name Changes
Date Fri, 20 Jul 2007 19:36:26 GMT
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 <egivler@state.pa.us> 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
>
>

Mime
View raw message