Wow, that was quick. This is specified in the <sqlMapConfig file>, and then seen in the individual SqlMap files automagically?
Thanks, Eric -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Meadors Sent: Friday, July 20, 2007 3:36 PM To: [email protected] Subject: Re: iBATIS and Schema name Changes 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 > >
