Did you look in server.log rather than the console? I usually get more
logging than I want in the log file unless I turn it off.

Unquoted reserved words are a good guess, I don't remember how you
manipulate this in the jbosscmp config. You can always map to specific
column names if worst comes to worst.

david jencks.

On 2002.12.26 12:52:59 -0500 Joachim Van der Auwera wrote:
> 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
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>