You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Emiliano Armellin <ea...@ateikon.com> on 2004/12/20 10:23:22 UTC
can i use properties file to set table's owner?
Hello
can I use a properties file to set the table owner in my sql statements?
for example:
| SELECT u.*
FROM $owner$.user u
WHERE cduser = #cduser#
|
until now I pass a *parameterClass="map"* with two Key: *cduser* and *owner*
Can i put *owner* in a properties file and avoid to pass it in the
parameter map?
--
Emiliano Armellin
*
W_
www.ateikon.com <http://www.ateikon.com>
*
@_
earmellin@ateikon.com <ma...@ateikon.com>
*
T_
*+39 0422 452101*
Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=15653&t=86>
Get Thunderbird <http://www.mozilla.org/products/thunderbird/>
Re: can i use properties file to set table's owner?
Posted by Emiliano Armellin <ea...@ateikon.com>.
Clinton Begin wrote:
>You bet. The build time syntax is similar to ${Ant}. For example:
>
>SELECT u.*
> FROM ${owner}.user u
> WHERE cduser = #cduser#
>
>This will also improve performance.
>
>Cheers,
>Clinton
>
>
wonderful!
but, is it documented somewhere? I've guessed the use of properties file
in sql statements from a message in the mailing list...
thanks
--
Emiliano Armellin
*
W_
www.ateikon.com <http://www.ateikon.com>
*
@_
earmellin@ateikon.com <ma...@ateikon.com>
*
T_
*+39 0422 452101*
Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=15653&t=86>
Get Thunderbird <http://www.mozilla.org/products/thunderbird/>
Re: can i use properties file to set table's owner?
Posted by Clinton Begin <cl...@gmail.com>.
You bet. The build time syntax is similar to ${Ant}. For example:
SELECT u.*
FROM ${owner}.user u
WHERE cduser = #cduser#
This will also improve performance.
Cheers,
Clinton
On Mon, 20 Dec 2004 10:23:22 +0100, Emiliano Armellin
<ea...@ateikon.com> wrote:
> Hello
>
> can I use a properties file to set the table owner in my sql statements?
> for example:
>
> SELECT u.*
> FROM $owner$.user u
> WHERE cduser = #cduser#
>
> until now I pass a parameterClass="map" with two Key: cduser and owner
> Can i put owner in a properties file and avoid to pass it in the parameter
> map?
>
>
>
> --
>
> Emiliano Armellin
>
> W_ www.ateikon.com
>
> @_ earmellin@ateikon.com
>
> T_
> +39 0422 452101
>
>