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
