ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Maves" <nathan.ma...@gmail.com>
Subject Re: Using # in a schema name?
Date Thu, 15 Nov 2007 13:59:05 GMT
good question.... a better one might be how do you find the person that
named the schema name that way and terminate their employment :)

just a guess but try to use a double hash ##

Nathan

On Nov 15, 2007 6:55 AM, Ralf Assmann <ralf.assmann@innovations.de> wrote:

>
> Hi there,
>
> using iBATIS, we have to problem setting the schema name of a table.
>
> If the statement is defined as
>
> SELECT field1
> FROM ${schema}.TESTTABLE
> WHERE field2 = #field2#
>
> and the ${schema} set to "ab#123" in den configuration files (the schema
> name ist given as a username, no change is possible), iBATIS tries to
> execute a statement like
>
> SELECT field1
> FROM ab#123.TESTTABLE
> WHERE field2 = #field2#
>
> Now, the problem is, that # is a placeholder for attributes, iBATIS
> tries to find a getter for #123.TESTTABLE WHERE field2 = #.
>
> How is it possible to set a schema name including a # in its name?
>
> Many thanks.
>
>
> Ralf
>
>
>

Mime
View raw message