I turned all this on, and although I do get additional debug printing from
the datasource connection pool, I still get no SQL statements in either the
console output or in server.log.
Any other ideas?
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 1:07 AM
Subject: RE: [JBoss-user] CMP finder method problem
> > I could get to the bottom of this if I could just see what
> > the container is doing when the findAll() is triggered.
> > My question is: is there a way to print or log the SQL SELECT
> > statement that the container has executed on my entity bean's
> > behalf? If not, can anyone suggest a good way to debug
> > something like this?
>
> Yes, you can (there are few places where you can turn logging on and off):
>
> jaws.xml or standardjaws.xml and specify:
> <jaws>
> ...
> <debug>true</debug>
> ...
> </jaws>
>
> jboss.xml or standardjboss.xml in you CMP container configuration:
>
> <!-- prints the method invoked by container -->
> <call-logging>true</call-logging>
>
> in jboss.jcml in your datasource configuration:
>
> <mbean ...>
> ...
> <attribute name="LoggingEnabled">true</attribute>
> </mbean>
>
>
> Also, do not forget to watch the server.log, not the console output,
because
> SQL statements appear only in server log (at least in my case).
>
> Roman
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
