[opennms-devel] Matching against NULL nodesysoid in categories.xml

I want to create a category for things that don't have a sysobjid
associated with them. However the following creates a bad exception on
startup:

Caused by: java.lang.reflect.UndeclaredThrowableException
        at org.opennms.netmgt.dao.support.JdbcFilterDao.getIPList(JdbcFilterDao.java:290)
        at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.catConstructIpAddrs(DataManager.java:175)
        at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.catGetIpAddrs(DataManager.java:163)
        at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.catContainsIp(DataManager.java:156)
        at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.catContainsIfService(DataManager.java:152)
        at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.processIfService(DataManager.java:134)
        at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.processKey(DataManager.java:122)
        at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.processRow(DataManager.java:115)
        at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1249)
        at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:600)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:617)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:633)
        at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
        at org.opennms.netmgt.rtc.DataManager.populateNodesFromDB(DataManager.java:360)
        at org.opennms.netmgt.rtc.DataManager.<init>(DataManager.java:406)
        at org.opennms.netmgt.rtc.RTCManager.onInit(RTCManager.java:513)
        ... 25 more
Caused by: org.opennms.netmgt.filter.FilterParseException: Parse error in rule '(IPADDR != '0.0.0.0') & ((nodeSysOID is NULL | nodeSysOID == ''))': java.io.IOException: Pushback buffer overflow
        at org.opennms.netmgt.dao.support.JdbcFilterDao.parseRule(JdbcFilterDao.java:353)
        at org.opennms.netmgt.dao.support.JdbcFilterDao.getSQLStatement(JdbcFilterDao.java:367)
        at org.opennms.netmgt.dao.support.JdbcFilterDao.getIPList(JdbcFilterDao.java:259)
        ... 42 more

If I change the rule (or rather NULL to null) to:

 <rule><![CDATA[(nodeSysOID is null | nodeSysOID == '')]]></rule>

It starts up but doesn't match anything. Is this just the validator
getting it's knickers in a twist?


-- 
Alex Bennee, Software Engineer
UFOs are for real: the Air Force doesn't exist.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel