betweenGo

To log SQL turn on logging debug for your Repository component.

For example, set /betweengo/repository/Repository.loggingDebug to true.

Note that a lot of SQL statements are outputted. If you want to selectively turn it on and off you can put this in your JSP where you want to start logging SQL.

<dspel:setvalue bean="/betweengo/repository/Repository.loggingDebug"
                value="true"/>

And then put this in your JSP where you want to stop logging SQL.

<dspel:setvalue bean="/betweengo/repository/Repository.loggingDebug"
                value="false"/>

Note I think this solution only works if you are using a javax.sql.DataSource like in a JBoss configuration.

Related posts:

1. How to Log SQL on JBoss
2. NameNotFoundExceptions during start up of ATG application on JBoss
3. Accessing RepositoryItems with JSTL
4. Enabling non-XA Resources in JBoss 4.2 with ATG
5. DynamicBeanMap