You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Craig L Russell <Cr...@Sun.COM> on 2006/07/21 19:54:47 UTC
Logging
Hi,
Is there a simple way to have Derby log stuff? I've scoured the doc
and can't really find much. What I'm mostly looking for is execution
of SQL statements, results coming back from the database, etc. I
know, pretty general, but I can't find anything at all on how to
configure the logging to get anything at all.
Thanks,
Craig
Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!
Re: Logging
Posted by Kathey Marsden <km...@sbcglobal.net>.
Craig L Russell wrote:
> Hi,
>
> Is there a simple way to have Derby log stuff? I've scoured the doc
> and can't really find much.
I logged
https://issues.apache.org/jira/browse/DERBY-1570
for this issue. I put in a suggestion for a possible quick fix for
10.2 so hopefully someone will pick it up. I get this question all the
time and now I understand why.
Thanks
Kathey
> What I'm mostly looking for is execution of SQL statements, results
> coming back from the database, etc. I know, pretty general, but I
> can't find anything at all on how to configure the logging to get
> anything at all.
>
> Thanks,
>
> Craig
>
> Craig Russell
>
> Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
>
> 408 276-5638 mailto:Craig.Russell@sun.com
>
> P.S. A good JDO? O, Gasp!
>
>
Re: Logging
Posted by Kathey Marsden <km...@sbcglobal.net>.
Craig L Russell wrote:
>
> It was the logStatementText that I was looking for in this particular
> case. I just overlooked it.
because it was well hidden I think.
I think there is a great documentation improvement opportunity here.
This information is hidden in the tuning guide which is not where users
might first look for it and also does not give a hit on the key words
"logging", "tracing" or "trace". I, like Myrna, often find myself
going first to the functional tests for information on how to do
something, so it might be worthwhile to file a Jira entry with an idea
for a better documentation presentation or even just for the problem
that derby.language.logStatementText and other logging properties do
not return a hit on these natural keywords. It might help the next
user if fixed.
Kathey
Re: Logging
Posted by Craig L Russell <Cr...@Sun.COM>.
Hi Myrna,
It was the logStatementText that I was looking for in this particular
case. I just overlooked it.
I was thinking that "surely there is a way to get varying levels of
trace/debug/log information" but I'll start with this one.
Thanks,
Craig
On Jul 21, 2006, at 11:02 AM, Myrna van Lunteren wrote:
> On 7/21/06, Craig L Russell <Cr...@sun.com> wrote:
>>
>> Hi,
>>
>> Is there a simple way to have Derby log stuff? I've scoured the
>> doc and
>> can't really find much. What I'm mostly looking for is execution
>> of SQL
>> statements, results coming back from the database, etc. I know,
>> pretty
>> general, but I can't find anything at all on how to configure the
>> logging to
>> get anything at all.
>>
>> Thanks,
>>
>> Craig
>>
>>
> You mean, properties like:
> derby.infolog.append=true
> derby.language.logStatementText=true
> derby.stream.error.logSeverityLevel=0
> ?
> I just poke around at the properties used in the tests, especially the
> store tests.
> There's some fascinating properties in the xaOffline1_derby.properties
> file but I've not used those myself. (eg. derby.debug.true=LogTrace).
>
> Myrna
Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!
Re: Logging
Posted by Myrna van Lunteren <m....@gmail.com>.
On 7/21/06, Craig L Russell <Cr...@sun.com> wrote:
>
> Hi,
>
> Is there a simple way to have Derby log stuff? I've scoured the doc and
> can't really find much. What I'm mostly looking for is execution of SQL
> statements, results coming back from the database, etc. I know, pretty
> general, but I can't find anything at all on how to configure the logging to
> get anything at all.
>
> Thanks,
>
> Craig
>
>
You mean, properties like:
derby.infolog.append=true
derby.language.logStatementText=true
derby.stream.error.logSeverityLevel=0
?
I just poke around at the properties used in the tests, especially the
store tests.
There's some fascinating properties in the xaOffline1_derby.properties
file but I've not used those myself. (eg. derby.debug.true=LogTrace).
Myrna