I have a problem with the automatically generated SQL by the JBoss CMP
engine, and want to see the SQL statement which is being generated. How can
I turn the loggin on in JBoss?

I assumed adding
<category name="org.firebirdsql">
<priority value="DEBUG"/>
</category>
in lig4j.xml would do the trick, but it doesn't seem to help.

The error I get

org.jboss.deployment.DeploymentException: Error while creating table; -
nested throwable: (org.firebirdsql.jdbc.FBSQLException: GDS Exception.
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 147
Group)

doesn't help much, though it makes me assume the generated SQL doen't quote
the fieldnames.

Thanks for the help,
Joachim