If you can post your table schema and what you have for an 'sql' parameter and we can figure it out.
Scott There are a number of limitations described in the JavaDoc: http://cvs.apache.org/viewcvs.cgi/logging-log4j/src/java/org/apache/log4j/db/CustomSQLDBReceiver.java?rev=1.3&view=markup - You must have an identity column and specify that field as the IDField param. - All of the event fields must be defined in the SQL statement, even if you don't have columns for them in your database - Unless you specify 'application' and 'hostname' params, the events may show up on the chainsaw-log tab (but more likely) an empty tab. There is an example receiver configuration on Chainsaw's Welcome tab that shows an example CustomSQLDBReceiver config. When running, look on the chainsaw-log tab for messages containing 'lastID' - this will tell you if your sql is executing, because lastID is the highest value of the identity field that the receiver was able to retrieve from the database. -----Original Message----- From: Ghielli Patrick [mailto:[EMAIL PROTECTED] Sent: Wed 3/16/2005 8:14 AM To: '[email protected]' Cc: Subject: Chainsaw with CustomSQLDBReceiver fo oracle Hi, I am trying to configure a CustomSQLDBReceiver for the Oracle DB I am using. After solving some problems mentionned in other postings on this mailing list, I now try set up a working sql statement. The statement I have now results in an error. The event in the chainsaw log describe it as an invalid column name. However, executing this statement in sqlplus returns the result as I would have expected. I should add that the chainsaw log output says that it is not able to select a dialect. Perhaps that has something to do with it. But I don't know how to make it choose the correct one. Thanks, Patrick Ghielli
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
