ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Givler, Eric" <egiv...@state.pa.us>
Subject iBATIS and Schema name Changes
Date Fri, 20 Jul 2007 19:33:12 GMT
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