db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Log connects, queries, and disconnects
Date Wed, 12 Jan 2005 19:36:51 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
In Derby, you can quote a table using using double-quotes... like:&nbsp;
SELECT * FROM "tdb";<br>
<br>
Regarding logging querries, can you use the property, <b>logStatementText</b>?
You can find more information about this and how to set properties in
the tuning guide:
<a class="moz-txt-link-freetext" href="http://incubator.apache.org/derby/manuals/tuning/perf77.html#HDRSII-PROPER-43517">http://incubator.apache.org/derby/manuals/tuning/perf77.html#HDRSII-PROPER-43517</a><br>
<br>
Satheesh<br>
<br>
SD wrote:<br>
<blockquote cite="midp05200f22be09f105ea8d@%5B172.16.32.200%5D"
 type="cite">Hello all,
  <br>
  <br>
&nbsp; It's me again.&nbsp; Thank you for the help with my previous question.
  <br>
  <br>
&nbsp; I'm changing our current project from Mysql to use Cloudscape/Derby.
  <br>
  <br>
&nbsp; My next question: Is there a way to log all the connects, queries,
and disconnects to derby?&nbsp; I'm running an embedded derby BTW.
  <br>
  <br>
&nbsp; Also, how does one quote a table name or column name.&nbsp; In Mysql you'd
wrap it with the ` character (ie: SELECT * FROM `the table`;).
  <br>
  <br>
&nbsp; Thanx again.
  <br>
  <br>
  <br>
</blockquote>
</body>
</html>

Mime
View raw message