Hi, I have included the table schema and the DB receiver config file. I kept the remarks below in mind, since they were already mentionned in an earlier posting. But unfortunately, still no success. The 'application' and 'hostname' paraeters seem to have no effect at all.
Regards, Patrick. -----Original Message----- From: Scott Deboy [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 maart 2005 6:22 To: Log4J Users List Subject: RE: Chainsaw with CustomSQLDBReceiver fo oracle 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: 'log4j-user@logging.apache.org' 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]