Thanks for your answers. ## will work ...
Ralf
Niels Beekman schrieb:
That's weird, I would assume iBATIS to just inject the schemaname, not
reprocess it. Try escaping the # with ##.
Niels
-----Original Message-----
From: Ralf Assmann [mailto:[EMAIL PROTECTED]
Sent: donderdag 15 november 2007 14:55
To: [email protected]
Subject: Using # in a schema name?
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
