You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by peter riegersperger <ri...@subnet.at> on 2003/01/17 14:38:07 UTC
show sql statements in logfile
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
hi!
i've set
services.LoggingService.system.level=DEBUG
services.LoggingService.sql.level=DEBUG
in order to see all sql statements generated by torque, not just SELECTs.
yet, i still see only select-statements.
i'm interesting in seeing UPDATE and INSERT as well. how can i enable them in
the logs?
thanks,
rick
- --
|-
| peter riegersperger <ri...@subnet.at>
|-
| ein windows switcher tagebuch:
| http://forum.subnet.at/viewforum.php?f=22
|-
| subnet
| platform for media art and experimental technologies
|-
| http://www.subnet.at/
|-
| muehlbacherhofweg 5 // 5020 salzburg // austria
|-
| fon/fax +43/662/842 897
|-
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE+KAdAIMP39JYOy9IRAiA6AJ9oeYCJJiAJOQfoB2EHJjfztT9QEQCggxnp
3QB2vFwNPXQwUPcji6dnvdw=
=ivcb
-----END PGP SIGNATURE-----
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Xslt with Turbine
Posted by Aparna Sundari <ap...@cmcltd.com>.
hai all,
i am a new user to turbine.
in my project i am using Turbine with Velocity.
could any one kindly tell me how should i call an xsl from an action
class???
I am able to set a screen(a .vm file)..
>From the same action class i want to set an xsl page..
or print a string containing an xsl file on to the screen.
thanks in advance,
regards,
Aparna.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: AW: AW: show sql statements in logfile
Posted by Scott Eade <se...@backstagetech.com.au>.
On 18/01/2003 10:39 PM, "peter riegersperger" <ri...@subnet.at> wrote:
> what puzzles me is that all SELECTs are getting logged in turbine.log, but
> nothing else.
I think you will find that only the SELECTs have the debugging code - the
debugging functionality hasn't been implemented for the other statement
types yet.
Patches are welcome ;-)
HTH,
Scott
--
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au
.Mac Chat/AIM: seade at mac dot com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: AW: AW: show sql statements in logfile
Posted by peter riegersperger <ri...@subnet.at>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Saturday 18 January 2003 12:21, Marc Lustig wrote:
> Are you using 2.2?
> Then read this from
> http://jakarta.apache.org/turbine/turbine-2/services/logging-service.html
[...]
> Not quite if this is applicable for 2.2 final as well thou.
i'm using tdk2.2, and i've got log4j-jars all over the place :)
the logging looks quite "log4jish", but i still don't get how to enable
automatic sql-logging (of course, i could do a
XXXPeer.createQueryString(...)), but i was looking for a better solution.
what puzzles me is that all SELECTs are getting logged in turbine.log, but
nothing else.
rick
- --
|-
| peter riegersperger <ri...@subnet.at>
|-
| ein windows switcher tagebuch:
| http://forum.subnet.at/viewforum.php?f=22
|-
| subnet
| platform for media art and experimental technologies
|-
| http://www.subnet.at/
|-
| muehlbacherhofweg 5 // 5020 salzburg // austria
|-
| fon/fax +43/662/842 897
|-
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE+KTz9IMP39JYOy9IRAv8QAJ4iD60BW+qOD5wyOgGVC7qzys6mkACdGwB4
euNYhvno7z08kV3waGQ3TL8=
=W8Ed
-----END PGP SIGNATURE-----
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
AW: AW: show sql statements in logfile
Posted by Marc Lustig <ma...@marclustig.com>.
Are you using 2.2?
Then read this from
http://jakarta.apache.org/turbine/turbine-2/services/logging-service.html
--
Turbine's logging service is exceptionally powerful. And it was proprietary.
So we ripped it out post Turbine 2.2 and replaced it with commons-logging
backed by Log4j.
--
Not quite if this is applicable for 2.2 final as well thou.
Marc
> -----Ursprüngliche Nachricht-----
> Von: peter riegersperger [mailto:rick@subnet.at]
> Gesendet: Samstag, 18. Januar 2003 12:05
> An: Turbine Users List
> Betreff: Re: AW: show sql statements in logfile
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> > On Sat, 18 Jan 2003, Marc Lustig wrote:
> > > I tried that out and added your lines at the bottom of tr.props.
> > > Nothing is written to the log-file thou.
> > > Did you remove anything in tr.props?
>
> same with me. app-sql.log is created, but empty.
>
> On Saturday 18 January 2003 00:23, Jeffery Painter wrote:
> > what is your service.LoggingService.facilities
> > set to?
>
> services.LoggingService.facilities=system,debug,security,sql
> services.LoggingService.default=system
> services.LoggingService.loggingConfig=org.apache.turbine.services.
> logging.PropertiesLoggingConfig
>
> # A facility for system logging.
> services.LoggingService.system.destination.file=/logs/turbine.log
> services.LoggingService.system.className=org.apache.turbine.servic
> es.logging.FileLogger
> services.LoggingService.system.level=DEBUG
>
> # A facility for SQL query logging
> # To enable SQL query logging, set the system and sql log level to DEBUG
> services.LoggingService.sql.destination.file=/logs/app-sql.log
> services.LoggingService.sql.className=org.apache.turbine.services.
> logging.FileLogger
> services.LoggingService.sql.level=DEBUG
>
> i dunno what goes wrong *shrug*
>
> rick
>
>
> - --
> |-
> | peter riegersperger <ri...@subnet.at>
> |-
> | ein windows switcher tagebuch:
> | http://forum.subnet.at/viewforum.php?f=22
> |-
> | subnet
> | platform for media art and experimental technologies
> |-
> | http://www.subnet.at/
> |-
> | muehlbacherhofweg 5 // 5020 salzburg // austria
> |-
> | fon/fax +43/662/842 897
> |-
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.7 (GNU/Linux)
>
> iD8DBQE+KTTVIMP39JYOy9IRApnJAKDIrGWKra8z/Qo0xyq7Td8tGZXHmQCgs44K
> ce5NXUs7WsQ0e9j89nqys2Y=
> =7D8f
> -----END PGP SIGNATURE-----
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: AW: show sql statements in logfile
Posted by peter riegersperger <ri...@subnet.at>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> On Sat, 18 Jan 2003, Marc Lustig wrote:
> > I tried that out and added your lines at the bottom of tr.props.
> > Nothing is written to the log-file thou.
> > Did you remove anything in tr.props?
same with me. app-sql.log is created, but empty.
On Saturday 18 January 2003 00:23, Jeffery Painter wrote:
> what is your service.LoggingService.facilities
> set to?
services.LoggingService.facilities=system,debug,security,sql
services.LoggingService.default=system
services.LoggingService.loggingConfig=org.apache.turbine.services.logging.PropertiesLoggingConfig
# A facility for system logging.
services.LoggingService.system.destination.file=/logs/turbine.log
services.LoggingService.system.className=org.apache.turbine.services.logging.FileLogger
services.LoggingService.system.level=DEBUG
# A facility for SQL query logging
# To enable SQL query logging, set the system and sql log level to DEBUG
services.LoggingService.sql.destination.file=/logs/app-sql.log
services.LoggingService.sql.className=org.apache.turbine.services.logging.FileLogger
services.LoggingService.sql.level=DEBUG
i dunno what goes wrong *shrug*
rick
- --
|-
| peter riegersperger <ri...@subnet.at>
|-
| ein windows switcher tagebuch:
| http://forum.subnet.at/viewforum.php?f=22
|-
| subnet
| platform for media art and experimental technologies
|-
| http://www.subnet.at/
|-
| muehlbacherhofweg 5 // 5020 salzburg // austria
|-
| fon/fax +43/662/842 897
|-
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE+KTTVIMP39JYOy9IRApnJAKDIrGWKra8z/Qo0xyq7Td8tGZXHmQCgs44K
ce5NXUs7WsQ0e9j89nqys2Y=
=7D8f
-----END PGP SIGNATURE-----
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
AW: AW: show sql statements in logfile
Posted by Marc Lustig <ma...@marclustig.com>.
I just copied your lines:
#SQL-Logging
service.LoggingService.facilities=system,sql,debug,security
services.LoggingService.sql.destination.file=/logs/app-sql.log
services.LoggingService.sql.className=org.apache.turbine.services.logging.Fi
leLogger
services.LoggingService.sql.level=DEBUG
> -----Ursprungliche Nachricht-----
> Von: Jeffery Painter [mailto:painter@kiasoft.com]
> Gesendet: Samstag, 18. Januar 2003 00:23
> An: Turbine Users List
> Betreff: Re: AW: show sql statements in logfile
>
>
>
> what is your service.LoggingService.facilities
> set to?
>
> you should at least have
> service.LoggingService.facilities=system,sql
>
> that is the kicker.
>
> the system and sql logging service need to be set to DEBUG
>
>
> On Sat, 18 Jan 2003, Marc Lustig wrote:
>
> > I tried that out and added your lines at the bottom of tr.props.
> > Nothing is written to the log-file thou.
> > Did you remove anything in tr.props?
> >
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: AW: show sql statements in logfile
Posted by Jeffery Painter <pa...@kiasoft.com>.
what is your service.LoggingService.facilities
set to?
you should at least have
service.LoggingService.facilities=system,sql
that is the kicker.
the system and sql logging service need to be set to DEBUG
On Sat, 18 Jan 2003, Marc Lustig wrote:
> I tried that out and added your lines at the bottom of tr.props.
> Nothing is written to the log-file thou.
> Did you remove anything in tr.props?
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
AW: show sql statements in logfile
Posted by Marc Lustig <ma...@marclustig.com>.
I tried that out and added your lines at the bottom of tr.props.
Nothing is written to the log-file thou.
Did you remove anything in tr.props?
Marc
> -----Ursprungliche Nachricht-----
> Von: Jeffery Painter [mailto:painter@kiasoft.com]
> Gesendet: Freitag, 17. Januar 2003 18:45
> An: Turbine Users List
> Betreff: Re: show sql statements in logfile
>
>
> I found this a bit confusing at first too. the answer is not apparent in
> documentation, but easy to fix.
>
> I created a seperate log file just for my sql statements.
>
> services.LoggingService.sql.destination.file=/logs/app-sql.log
>
> and then add sql to your services.LoggingService.facilities
>
> service.LoggingService.facilities=system,sql,debug,security
>
> services.LoggingService.sql.destination.file=/logs/app-sql.log
> services.LoggingService.sql.className=org.apache.turbine.services.
> logging.FileLogger
> services.LoggingService.sql.level=DEBUG
>
>
> all sql statements will then be logged.
>
> HTH!
>
> Jeff Painter
> painter@kiasoft.com
>
>
> On Fri, 17 Jan 2003, Johnny Quazar wrote:
>
> > Hey Rick,
> >
> > I too want this, just saw an alternative that looks good though I
> > haven't tried it. Also there's a thread about it on this list some
> > where, I don't know if it concludes "hey that works" or not.
> >
> > But the better answer seems to be at http://www.p6spy.com/
> >
> > Good luck.
> >
> > At 2:38 PM +0100 1/17/03, peter riegersperger wrote:
> > >-----BEGIN PGP SIGNED MESSAGE-----
> > >Hash: SHA1
> > >
> > >hi!
> > >
> > >i've set
> > >services.LoggingService.system.level=DEBUG
> > >services.LoggingService.sql.level=DEBUG
> > >in order to see all sql statements generated by torque, not
> just SELECTs.
> > >yet, i still see only select-statements.
> > >
> > >i'm interesting in seeing UPDATE and INSERT as well. how can i
> enable them in
> > >the logs?
> >
> > --
> > To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: show sql statements in logfile
Posted by Jeffery Painter <pa...@kiasoft.com>.
I found this a bit confusing at first too. the answer is not apparent in
documentation, but easy to fix.
I created a seperate log file just for my sql statements.
services.LoggingService.sql.destination.file=/logs/app-sql.log
and then add sql to your services.LoggingService.facilities
service.LoggingService.facilities=system,sql,debug,security
services.LoggingService.sql.destination.file=/logs/app-sql.log
services.LoggingService.sql.className=org.apache.turbine.services.logging.FileLogger
services.LoggingService.sql.level=DEBUG
all sql statements will then be logged.
HTH!
Jeff Painter
painter@kiasoft.com
On Fri, 17 Jan 2003, Johnny Quazar wrote:
> Hey Rick,
>
> I too want this, just saw an alternative that looks good though I
> haven't tried it. Also there's a thread about it on this list some
> where, I don't know if it concludes "hey that works" or not.
>
> But the better answer seems to be at http://www.p6spy.com/
>
> Good luck.
>
> At 2:38 PM +0100 1/17/03, peter riegersperger wrote:
> >-----BEGIN PGP SIGNED MESSAGE-----
> >Hash: SHA1
> >
> >hi!
> >
> >i've set
> >services.LoggingService.system.level=DEBUG
> >services.LoggingService.sql.level=DEBUG
> >in order to see all sql statements generated by torque, not just SELECTs.
> >yet, i still see only select-statements.
> >
> >i'm interesting in seeing UPDATE and INSERT as well. how can i enable them in
> >the logs?
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: show sql statements in logfile
Posted by Johnny Quazar <qu...@bitblaster.com>.
Hey Rick,
I too want this, just saw an alternative that looks good though I
haven't tried it. Also there's a thread about it on this list some
where, I don't know if it concludes "hey that works" or not.
But the better answer seems to be at http://www.p6spy.com/
Good luck.
At 2:38 PM +0100 1/17/03, peter riegersperger wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>hi!
>
>i've set
>services.LoggingService.system.level=DEBUG
>services.LoggingService.sql.level=DEBUG
>in order to see all sql statements generated by torque, not just SELECTs.
>yet, i still see only select-statements.
>
>i'm interesting in seeing UPDATE and INSERT as well. how can i enable them in
>the logs?
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>