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 
>  
>