JavaScript Reader: Retrieving Deployed Channels

Getting errors with this JavaScript to stop channels for a period and restart afterwards. But it is getting an error in the stack trace below. Any suggestions for a MirthConnect novice?



//First we need to import the controllers

importPackage(Packages.com.mirth.connect.server.us erutil);

importPackage(Packages.com.mirth.connect.server.us erutil.ChannelUtil);

importPackage(Packages.com.mirth.connect.server.us erutil.DatabaseConnection);

importPackage(Packages.com.mirth.connect.server.us erutil.DatabaseConnectionFactory);



//Set TimeFrame variables

var d = new Date();

var currtime = d.getHours() * 100 + d.getMinutes(); // so 10:30 will be number 1030

var startRange = 2200

var EndRange = 2300

var bStopChannel=false;

var intStopMsgCnt=0;



//Check Current time is within our Timeframe

if (currtime >= startRange && currtime < EndRange)

{

bStopChannel=true;

}



//creates DB connection

var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('org.postgresql.Driver','jdbc:postgresql://localhost:5432/mirthdb','mirthdb_ro','********');



//builds query

var query = "SELECT channel_id FROM d_channels"



//executes query

var result = dbConn.executeCachedQuery(query);



//stops channels

while(result.next())

{

if (bStopChannel)

{

ChannelUtil.stopChannel(result.getString("channel_ id"));

}

else

{

ChannelUtil.startChannel(result.getString("channel _id"));

}

}



dbConn.close();



return null;



But it is generating this error:

[2014-10-28 13:24:43,168] ERROR (com.mirth.connect.connectors.js.JavaScriptReceive r:124): Error executing JavaScript Reader script cf851235-236d-415c-b43a-302793b5f42e.

com.mirth.connect.server.util.javascript.JavaScrip tExecutorException: com.mirth.connect.server.MirthJavascriptTransforme rException: CHANNEL:

Channel STOP-START for DB2 BackupCONNECTOR:

SourceSOURCE CODE:

23: }24: }25: function doScript() {26: //First we need to import the controllers27: importPackage(Packages.com.mirth.connect.server.us erutil);28: importPackage(Packages.com.mirth.connect.server.us erutil.ChannelUtil);29: importPackage(Packages.com.mirth.connect.server.us erutil.DatabaseConnection);30: importPackage(Packages.com.mirth.connect.server.us erutil.DatabaseConnectionFactory);31: 32: //Set TimeFrame variablesLINE NUMBER:

28DETAILS:

Function importPackage must be called with a package; had "[JavaClass com.mirth.connect.server.userutil.ChannelUtil]" instead.

at cf851235-236d-415c-b43a-302793b5f42e:28 (doScript)

at cf851235-236d-415c-b43a-302793b5f42e:132

at com.mirth.connect.server.util.javascript.JavaScrip tUtil.execute(JavaScriptUtil.java:63)

at com.mirth.connect.connectors.js.JavaScriptReceiver .poll(JavaScriptReceiver.java:90)

at com.mirth.connect.donkey.server.channel.PollConnec tor$PollConnectorTask.run(PollConnector.java:131)

at java.util.TimerThread.mainLoop(Timer.java:555)

at java.util.TimerThread.run(Timer.java:505)Caused by: com.mirth.connect.server.MirthJavascriptTransforme rException: CHANNEL:

Channel STOP-START for DB2 BackupCONNECTOR:

SourceSOURCE CODE:

23: }24: }25: function doScript() {26: //First we need to import the controllers27: importPackage(Packages.com.mirth.connect.server.us erutil);28: importPackage(Packages.com.mirth.connect.server.us erutil.ChannelUtil);29: importPackage(Packages.com.mirth.connect.server.us erutil.DatabaseConnection);30: importPackage(Packages.com.mirth.connect.server.us erutil.DatabaseConnectionFactory);31: 32: //Set TimeFrame variablesLINE NUMBER:

28DETAILS:

Function importPackage must be called with a package; had "[JavaClass com.mirth.connect.server.userutil.ChannelUtil]" instead.

at cf851235-236d-415c-b43a-302793b5f42e:28 (doScript)

at cf851235-236d-415c-b43a-302793b5f42e:132

at com.mirth.connect.server.util.javascript.JavaScrip tUtil.executeScript(JavaScriptUtil.java:490)

at com.mirth.connect.connectors.js.JavaScriptReceiver $JavaScriptReceiverTask.call(JavaScriptReceiver.ja va:143)

at java.util.concurrent.FutureTask.run(FutureTask.jav a:262)

at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

JavaScript Reader: Retrieving Deployed Channels