Hi,

when i develop a database collector to collect bussiness database
logs about oracle for our customer , i use JDBC to connect to remote
oracle database, after i add database collector / jdbc connector /
database event source in SCC, i found i can not startup any of these
plugins, why? can database collector debug? the following codes is my
collector codes, additions, can anyone provide me a detail step by step
guide for database collector?


sqlquery.base
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT TOP %d * FROM ts_querybillsigned_log WHERE REQUEST_TM > %s

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

release.js
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Collector.prototype.initialize = function() {
this.PARSER.getOffsetData = function(input) {
if (typeof input.RXMap != "undefined") {
return input.RXMap.REQUEST_TM;
}
};
conn.addParser(this.PARSER.getOffsetData);
return true;
};

Collector.prototype.cleanup = function() {
return true;
};


Connector.prototype.sendQuery = function() {
return true;
};


Record.prototype.preParse = function(e) {
if (this.CONNECTION_ERROR != null || typeof this.RXMap == "undefined")
{ return false; }

if (this.CONNECTION_METHOD == "DATABASE") {

for (var field in this.RXMap) {
this[field] = this.RXMap[field];
}

return true;
};

Record.prototype.parse = function(e) {

this.iuid = this.LOG_ID;
this.cv30 = this.METHODNAME;
this.cv31 = this.CLIENTNAME;
this.cv32 = this.CLIENTMAC;
this.cv33 = this.CLIENTIP;
this.cv34 = this.QUERYTYPE;
this.cv35 = this.SIGNEDTYPE;
var detstring =
this.RXMap.REQUEST_TM.replace(/(\d+)\/(\d+)\/(\d{4})\s(\S+)/, "$1/$2/$3
$4 GMT");
var dt = new Date(detstring);
e.setDeviceEventTime(dt);
return true;
};


Record.prototype.normalize = function(e) {
instance.SEND_EVENT =true;
return true;
};

Record.prototype.postParse = function(e) {
return true;
};


Record.prototype.reply = function(e) {
return true;
};


--
DCorlette
------------------------------------------------------------------------
DCorlette's Profile: https://forums.netiq.com/member.php?userid=323
View this thread: https://forums.netiq.com/showthread.php?t=50302