ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: can i use properties file to set table's owner?
Date Mon, 20 Dec 2004 14:17:50 GMT
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
<earmellin@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 
>  
>

Mime
View raw message