[prev in list] [next in list] [prev in thread] [next in thread]
List: opennms-discuss
Subject: [opennms-discuss] Scriptd fails to execute database insert
From: Jaseer T K <jaseer () sparksupport ! com>
Date: 2011-07-29 23:44:51
Message-ID: CALJOiB5m0vzj2YwabNhWWFBD1sThDC6LrmVsmCMtQfw75QFp7w () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I have a problem in executing database insert query, in beanshell script of
scriptd configuration. I have the set the debug log option for scriptd and I
am getting the following error in /var/log/opennms/daemon/scriptd.log
"Non-UEI-specific event handler script [0] execution failed"
My /var/log/opennms/daemon/stds.log shows following error.
================================================================================================
java.security.PrivilegedActionException: org.apache.bsf.BSFException:
BeanShell script error: Sourced file: inline evaluation of: ``event =
bsf.lookupBean("event"); log.debug("Starting your event:11111 jaseer"); . .
. '' : Error in method invocation: No args method execute() not found in
class'org.opennms.netmgt.utils.Updater' : at Line: 1 : in file: inline
evaluation of: ``event = bsf.lookupBean("event"); log.debug("Starting your
event:11111 jaseer"); . . . '' : updater .execute ( )
Caused by: org.apache.bsf.BSFException: BeanShell script error: Sourced
file: inline evaluation of: ``event = bsf.lookupBean("event");
log.debug("Starting your event:11111 jaseer"); . . . '' : Error in method
invocation: No args method execute() not found in
class'org.opennms.netmgt.utils.Updater' : at Line: 1 : in file: inline
evaluation of: ``event = bsf.lookupBean("event"); log.debug("Starting your
event:11111 jaseer"); . . . '' : updater .execute ( )
============================================================================================
Here is my code (I have used some 'log.debug' messages, which helped me to
find where the execution fails. )
=================================================================
<?xml version="1.0"?>
<scriptd-configuration>
<engine language="beanshell" className="bsh.util.BeanShellBSFEngine"
extensions="bsh"/>
<start-script language="beanshell">
log.debug("Starting your script:11111 jaseer");
import org.opennms.netmgt.config.DataSourceFactory;
import org.opennms.netmgt.utils.Updater;
import org.opennms.netmgt.utils.SingleResultQuerier;
log = bsf.lookupBean("log");
log.debug("Starting your script:2222 jaseer");
</start-script>
<stop-script language="beanshell">
log.error("executing a stop script");
</stop-script>
<event-script language="beanshell">
event = bsf.lookupBean("event");
log.debug("Starting your event:11111 jaseer");
if (event.uei.equals("uei.opennms.org/nodes/nodeAdded")) {
updater = new
Updater(DataSourceFactory.getInstance(), "INSERT INTO category_node VALUES
(1,9)");
updater.execute();
log.debug("Starting your event:2222 jaseer- INSIDE
THE IF LOOP");
}
</event-script>
</scriptd-configuration>
==========================================================
--
With Regards,
Jaseer TK
Software Engineer/Administrator
SparkSupport, Cochin.
mob: +91 9633960409
[Attachment #5 (text/html)]
<br><br>I have a problem in executing database insert query, in beanshell script of \
scriptd configuration. I have the set the debug log option for scriptd and I am \
getting the following error in /var/log/opennms/daemon/scriptd.log<br> \
<br>"<font size="2">Non-UEI-specific event handler script [0] execution \
failed</font>"<br><br><br>My /var/log/opennms/daemon/stds.log shows following \
error.<br><br>================================================================================================<br>
java.security.PrivilegedActionException: org.apache.bsf.BSFException: BeanShell \
script error: Sourced file: inline evaluation of: ``event = \
bsf.lookupBean("event"); log.debug("Starting your event:11111 \
jaseer"); . . . '' : Error in method invocation: No args method \
execute() not found in class'org.opennms.netmgt.utils.Updater' : at Line: 1 : \
in file: inline evaluation of: ``event = bsf.lookupBean("event"); \
log.debug("Starting your event:11111 jaseer"); . . . '' : updater \
.execute ( ) <br> <br>Caused by: org.apache.bsf.BSFException: BeanShell script error: \
Sourced file: inline evaluation of: ``event = bsf.lookupBean("event"); \
log.debug("Starting your event:11111 jaseer"); . . . '' : Error in \
method invocation: No args method execute() not found in \
class'org.opennms.netmgt.utils.Updater' : at Line: 1 : in file: inline \
evaluation of: ``event = bsf.lookupBean("event"); log.debug("Starting \
your event:11111 jaseer"); . . . '' : updater .execute ( ) <br> \
<br>============================================================================================<br><br>Here \
is my code (I have used some 'log.debug' messages, which helped me to find \
where the execution fails. )<br> \
=================================================================<br><br><?xml \
version="1.0"?><br><scriptd-configuration><br> <engine \
language="beanshell" className="bsh.util.BeanShellBSFEngine" \
extensions="bsh"/><br> <start-script \
language="beanshell"><br> log.debug("Starting your \
script:11111 jaseer");<br> import \
org.opennms.netmgt.config.DataSourceFactory;<br> import \
org.opennms.netmgt.utils.Updater;<br> import \
org.opennms.netmgt.utils.SingleResultQuerier;<br> log = \
bsf.lookupBean("log");<br> log.debug("Starting your \
script:2222 jaseer");<br> </start-script><br> <br> \
<stop-script language="beanshell"><br> \
log.error("executing a stop script");<br> </stop-script><br><br> \
<event-script language="beanshell"><br> event = \
bsf.lookupBean("event");<br> log.debug("Starting your \
event:11111 jaseer");<br> if (event.uei.equals("<a \
href="http://uei.opennms.org/nodes/nodeAdded">uei.opennms.org/nodes/nodeAdded</a>")) \
{<br> updater = new Updater(DataSourceFactory.getInstance(), "INSERT INTO \
category_node VALUES (1,9)");<br> updater.execute();<br> \
log.debug("Starting your event:2222 jaseer- INSIDE THE IF LOOP");<br> \
}<br> </event-script><br></scriptd-configuration><br>==========================================================<br><br \
clear="all"><br>-- <br>With Regards,<br><br>Jaseer TK<br>Software \
Engineer/Administrator<br> SparkSupport, Cochin.<br>mob: +91 9633960409<br><br>
------------------------------------------------------------------------------
Got Input? Slashdot Needs You.
Take our quick survey online. Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-discuss mailing list
To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic