[syslog-ng] commit with the oracle sql driver

Patrick H. syslogng at feystorm.net
Tue Mar 2 20:46:12 CET 2010


So, extensive googling has failed me on this. I'm using the sql driver 
to output to an oracle database, with debugging mode, I can see that the 
insert queries are indeed being executed, however my tables remain empty.
I've been through the source code, and it doesnt look like a commit is 
being performed anywhere. Though my google efforts, I did find one 
reference where someone patched the libdbi-drivers oracle driver to do a 
commit on success after every query, but that is insanely expensive (and 
ugly).

I have started modifying the code to add the flush_lines and 
flush_timeout option to the sql driver. But before I got too carried 
away, I was wondering why this is the way it is the way it is, or if I'm 
missing something.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20100302/6b018369/attachment.htm 


More information about the syslog-ng mailing list