I am tried to consult a row in the data base and to give back to a communication point the value of a field of that is same row.
This it is the code that I am using in the filter:
var driver, address, username, password //variables initialized previously
dbConn = DatabaseConnectionFactory.createDatabaseConnection (driver, address, username, password);
var campo = msg['message']['message.01']['message.01.1'];
var expression = "SELECT * FROM demograficos WHERE idpaciente = 1;";
var resultado = dbConn.executeQuery(expression);
resultado.next();
var texto = resultado.getClob["responsexml"];
var cantidad = resultado.getLength();
resultado.close();
dbConn.close();
globalMap.put('Prueba',texto);
globalMap.put('xml',cantidad);
//msg = texto;
return true;
This is the error message that shows to me in logs:
ERROR-200: Filter error
ERROR MESSAGE: Error evaluating filter
org.mozilla.javascript.WrappedException: Wrapped org.postgresql.util.PSQLException: This ResultSet is closed. (b7d96e74-5ee5-4f77-90df-eb4fe5578a16#20)
at org.mozilla.javascript.Context.throwAsScriptRuntim eEx(Context.java:1693)
at org.mozilla.javascript.MemberBox.invoke(MemberBox. java:157)
at org.mozilla.javascript.NativeJavaMethod.call(Nativ eJavaMethod.java:201)
at org.mozilla.javascript.optimizer.OptRuntime.callPr op0(OptRuntime.java:117)
at org.mozilla.javascript.gen.c683._c3(b7d96e74-5ee5-4f77-90df-eb4fe5578a16:20)
at org.mozilla.javascript.gen.c683.call(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at org.mozilla.javascript.optimizer.OptRuntime.callNa me0(OptRuntime.java:106)
at org.mozilla.javascript.gen.c683._c2(b7d96e74-5ee5-4f77-90df-eb4fe5578a16:55)
at org.mozilla.javascript.gen.c683.call(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at org.mozilla.javascript.optimizer.OptRuntime.callNa me0(OptRuntime.java:106)
at org.mozilla.javascript.gen.c683._c0(b7d96e74-5ee5-4f77-90df-eb4fe5578a16:57)
at org.mozilla.javascript.gen.c683.call(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at org.mozilla.javascript.ContextFactory.doTopCall(Co ntextFactory.java:337)
at org.mozilla.javascript.ScriptRuntime.doTopCall(Scr iptRuntime.java:2755)
at org.mozilla.javascript.gen.c683.call(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at org.mozilla.javascript.gen.c683.exec(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at com.webreach.mirth.server.mule.transformers.JavaSc riptTransformer.evaluateFilterScript(JavaScriptTra nsformer.java:268)
at com.webreach.mirth.server.mule.transformers.JavaSc riptTransformer.transform(JavaScriptTransformer.ja va:221)
at org.mule.transformers.AbstractEventAwareTransforme r.doTransform(AbstractEventAwareTransformer.java:4 8)
at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)
at org.mule.impl.MuleEvent.getTransformedMessage(Mule Event.java:251)
at com.webreach.mirth.server.controllers.MessageObjec tController.getMessageObjectFromEvent(MessageObjec tController.java:276)
at com.webreach.mirth.server.mule.providers.tcp.TcpMe ssageDispatcher.doDispatch(TcpMessageDispatcher.ja va:124)
at com.webreach.mirth.server.mule.providers.tcp.TcpMe ssageDispatcher.doSend(TcpMessageDispatcher.java:2 15)
at org.mule.providers.AbstractMessageDispatcher.send( AbstractMessageDispatcher.java:166)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:191)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:130)
at org.mule.routing.outbound.AbstractOutboundRouter.s end(AbstractOutboundRouter.java:85)
at org.mule.routing.outbound.FilteringMulticastingRou ter.route(FilteringMulticastingRouter.java:89)
at org.mule.routing.outbound.OutboundMessageRouter$1. doInTransaction(OutboundMessageRouter.java:78)
at org.mule.transaction.TransactionTemplate.execute(T ransactionTemplate.java:48)
at org.mule.routing.outbound.OutboundMessageRouter.ro ute(OutboundMessageRouter.java:82)
at org.mule.impl.model.DefaultMuleProxy.onCall(Defaul tMuleProxy.java:247)
at org.mule.impl.model.seda.SedaComponent.doSend(Seda Component.java:209)
at org.mule.impl.model.AbstractComponent.sendEvent(Ab stractComponent.java:277)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:201)
at org.mule.routing.inbound.InboundMessageRouter.send (InboundMessageRouter.java:161)
at org.mule.routing.inbound.InboundMessageRouter.rout e(InboundMessageRouter.java:128)
at org.mule.providers.AbstractMessageReceiver$Default InternalMessageListener.onMessage(AbstractMessageR eceiver.java:492)
at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:271)
at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:243)
at com.webreach.mirth.server.mule.providers.tcp.TcpMe ssageReceiver$TcpWorker.processData(TcpMessageRece iver.java:278)
at com.webreach.mirth.server.mule.providers.tcp.TcpMe ssageReceiver$TcpWorker.run(TcpMessageReceiver.jav a:250)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkC losed(AbstractJdbc2ResultSet.java:2442)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.next(A bstractJdbc2ResultSet.java:1816)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mozilla.javascript.MemberBox.invoke(MemberBox. java:142)
... 45 more
Somebody can help me, please?
This it is the code that I am using in the filter:
var driver, address, username, password //variables initialized previously
dbConn = DatabaseConnectionFactory.createDatabaseConnection (driver, address, username, password);
var campo = msg['message']['message.01']['message.01.1'];
var expression = "SELECT * FROM demograficos WHERE idpaciente = 1;";
var resultado = dbConn.executeQuery(expression);
resultado.next();
var texto = resultado.getClob["responsexml"];
var cantidad = resultado.getLength();
resultado.close();
dbConn.close();
globalMap.put('Prueba',texto);
globalMap.put('xml',cantidad);
//msg = texto;
return true;
This is the error message that shows to me in logs:
ERROR-200: Filter error
ERROR MESSAGE: Error evaluating filter
org.mozilla.javascript.WrappedException: Wrapped org.postgresql.util.PSQLException: This ResultSet is closed. (b7d96e74-5ee5-4f77-90df-eb4fe5578a16#20)
at org.mozilla.javascript.Context.throwAsScriptRuntim eEx(Context.java:1693)
at org.mozilla.javascript.MemberBox.invoke(MemberBox. java:157)
at org.mozilla.javascript.NativeJavaMethod.call(Nativ eJavaMethod.java:201)
at org.mozilla.javascript.optimizer.OptRuntime.callPr op0(OptRuntime.java:117)
at org.mozilla.javascript.gen.c683._c3(b7d96e74-5ee5-4f77-90df-eb4fe5578a16:20)
at org.mozilla.javascript.gen.c683.call(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at org.mozilla.javascript.optimizer.OptRuntime.callNa me0(OptRuntime.java:106)
at org.mozilla.javascript.gen.c683._c2(b7d96e74-5ee5-4f77-90df-eb4fe5578a16:55)
at org.mozilla.javascript.gen.c683.call(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at org.mozilla.javascript.optimizer.OptRuntime.callNa me0(OptRuntime.java:106)
at org.mozilla.javascript.gen.c683._c0(b7d96e74-5ee5-4f77-90df-eb4fe5578a16:57)
at org.mozilla.javascript.gen.c683.call(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at org.mozilla.javascript.ContextFactory.doTopCall(Co ntextFactory.java:337)
at org.mozilla.javascript.ScriptRuntime.doTopCall(Scr iptRuntime.java:2755)
at org.mozilla.javascript.gen.c683.call(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at org.mozilla.javascript.gen.c683.exec(b7d96e74-5ee5-4f77-90df-eb4fe5578a16)
at com.webreach.mirth.server.mule.transformers.JavaSc riptTransformer.evaluateFilterScript(JavaScriptTra nsformer.java:268)
at com.webreach.mirth.server.mule.transformers.JavaSc riptTransformer.transform(JavaScriptTransformer.ja va:221)
at org.mule.transformers.AbstractEventAwareTransforme r.doTransform(AbstractEventAwareTransformer.java:4 8)
at org.mule.transformers.AbstractTransformer.transfor m(AbstractTransformer.java:197)
at org.mule.impl.MuleEvent.getTransformedMessage(Mule Event.java:251)
at com.webreach.mirth.server.controllers.MessageObjec tController.getMessageObjectFromEvent(MessageObjec tController.java:276)
at com.webreach.mirth.server.mule.providers.tcp.TcpMe ssageDispatcher.doDispatch(TcpMessageDispatcher.ja va:124)
at com.webreach.mirth.server.mule.providers.tcp.TcpMe ssageDispatcher.doSend(TcpMessageDispatcher.java:2 15)
at org.mule.providers.AbstractMessageDispatcher.send( AbstractMessageDispatcher.java:166)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:191)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:130)
at org.mule.routing.outbound.AbstractOutboundRouter.s end(AbstractOutboundRouter.java:85)
at org.mule.routing.outbound.FilteringMulticastingRou ter.route(FilteringMulticastingRouter.java:89)
at org.mule.routing.outbound.OutboundMessageRouter$1. doInTransaction(OutboundMessageRouter.java:78)
at org.mule.transaction.TransactionTemplate.execute(T ransactionTemplate.java:48)
at org.mule.routing.outbound.OutboundMessageRouter.ro ute(OutboundMessageRouter.java:82)
at org.mule.impl.model.DefaultMuleProxy.onCall(Defaul tMuleProxy.java:247)
at org.mule.impl.model.seda.SedaComponent.doSend(Seda Component.java:209)
at org.mule.impl.model.AbstractComponent.sendEvent(Ab stractComponent.java:277)
at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:201)
at org.mule.routing.inbound.InboundMessageRouter.send (InboundMessageRouter.java:161)
at org.mule.routing.inbound.InboundMessageRouter.rout e(InboundMessageRouter.java:128)
at org.mule.providers.AbstractMessageReceiver$Default InternalMessageListener.onMessage(AbstractMessageR eceiver.java:492)
at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:271)
at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:243)
at com.webreach.mirth.server.mule.providers.tcp.TcpMe ssageReceiver$TcpWorker.processData(TcpMessageRece iver.java:278)
at com.webreach.mirth.server.mule.providers.tcp.TcpMe ssageReceiver$TcpWorker.run(TcpMessageReceiver.jav a:250)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkC losed(AbstractJdbc2ResultSet.java:2442)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.next(A bstractJdbc2ResultSet.java:1816)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mozilla.javascript.MemberBox.invoke(MemberBox. java:142)
... 45 more
Somebody can help me, please?
Comment