In Derby, you can quote a table using using double-quotes... like:
SELECT * FROM "tdb";
Regarding logging querries, can you use the property, logStatementText?
You can find more information about this and how to set properties in
the tuning guide:
http://incubator.apache.org/derby/manuals/tuning/perf77.html#HDRSII-PROPER-43517
Satheesh
SD wrote:
Hello all,
It's me again. Thank you for the help with my previous question.
I'm changing our current project from Mysql to use Cloudscape/Derby.
My next question: Is there a way to log all the connects, queries,
and disconnects to derby? I'm running an embedded derby BTW.
Also, how does one quote a table name or column name. In Mysql you'd
wrap it with the ` character (ie: SELECT * FROM `the table`;).
Thanx again.
|
