My idea is to monitor an Oracle database table and then process the data to a pdf file which is then sent to a (test) hardcoded email adress (later this will be the user); my first tests with babeldoc are positif, but the scanner still invokes a pipeline even if there are no rows returned by the query; any hints would be welcome.
Here is my scanner configuration; the sql-statement and updateStatement succeed.
AttestGeneratorSql.type=sql
AttestGeneratorSql.period=10000
AttestGeneratorSql.resourceName=AdminformsDatasource
AttestGeneratorSql.pipeline=AttestGenerator
AttestGeneratorSql.documentType=xml
AttestGeneratorSql.xmlHeadingTag=testdocument
AttestGeneratorSql.xmlRowTag=row
AttestGeneratorSql.sqlStatement=SELECT NOM name, PRENOM firstname FROM BOU_CONS_CHANGEADR WHERE id = 921 and dt_transfer_sysper is null
AttestGeneratorSql.updateStatement=UPDATE BOU_CONS_CHANGEADR SET dt_transfer_sysper = SYSDATE WHERE id = 921
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
My idea is to monitor an Oracle database table and then process the data to a pdf file which is then sent to a (test) hardcoded email adress (later this will be the user); my first tests with babeldoc are positif, but the scanner still invokes a pipeline even if there are no rows returned by the query; any hints would be welcome.
Here is my scanner configuration; the sql-statement and updateStatement succeed.
AttestGeneratorSql.type=sql
AttestGeneratorSql.period=10000
AttestGeneratorSql.resourceName=AdminformsDatasource
AttestGeneratorSql.pipeline=AttestGenerator
AttestGeneratorSql.documentType=xml
AttestGeneratorSql.xmlHeadingTag=testdocument
AttestGeneratorSql.xmlRowTag=row
AttestGeneratorSql.sqlStatement=SELECT NOM name, PRENOM firstname FROM BOU_CONS_CHANGEADR WHERE id = 921 and dt_transfer_sysper is null
AttestGeneratorSql.updateStatement=UPDATE BOU_CONS_CHANGEADR SET dt_transfer_sysper = SYSDATE WHERE id = 921
OK, there is a bug in the source code when the [scannerName].documentType=xml , where a document is queued even when no rows are returned by the query
I corrected the error in the source code; if someone can include it in cvs I will be happy to post the correction.
Jan
Sure - post it to patches and I will apply it.