Jason,
    The sql statements should appear at server start up in the server log if
you set debug to true in the standardjaws file. They will come be logged
just after the beans are deployed. Am surprised that it is not showing up.
Is there any sql at all being generated?

Vinay
----- Original Message -----
From: "Jason Wells" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 9:11 PM
Subject: Re: [JBoss-user] CMP finder method problem


> 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


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to