calling stored procedures on the Source connector

[rkedilaya]

Version : Mirth 1.5

using javascript stored procedure in source connector.

var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('sun.jdbc.odbc.JdbcOdbcDriver','DATABASE','USERNA ME','');

//HERE I AM GETTING ROWS MORE THAN ONE ROW
var result = dbConn.executeCachedQuery("select patienttestno,t_observation from pob_observation where c_flag='F'");

// HERE THE ROWS ARE TRAVERSED ,BLOB DATA CONVERTED TO TEXT DATA
while (result.next())
{
var xray = result.getClob(2);
var strOut = new java.lang.StringBuffer();
var aux = new java.lang.String();
var kit = new Packages.javax.swing.text.rtf.RTFEditorKit()
var doc = new Packages.javax.swing.text.DefaultStyledDocument();
kit.read(xray.getAsciiStream(), doc, 0);

var text=doc.getText(0,doc.getLength());
channelMap.put('xray',text);
}

dbConn.close();
return result;

select query returns more than one rows.How can i traverse in each row and map to the HL7 OBX5.1 Message?

[chrisl]

Re:calling stored procedures on the Source connector

Sorry, I don't see where you are calling a stored procedure here?

[rkedilaya]

Re:calling stored procedures on the Source connector

Dear Chrisl,

Instead of stored procedure i have used select statement [select patienttestno,t_observation from pob_observation where c_flag='F']
which returns patienttestno and t_observation (which is clob data). I need to convert clob data to text format.

[rkedilaya]

using javascript stored procedure in source connec

Finally able to get the hl7 message OBX.5.1 rtf into text data.:laugh:.I am attaching the file herewith.I am using Database to File Writer.

If i need to configure the same for LLP channel,How can i handle ACK messages and Error Messages?

Testsample.xml (8677 bytes)

[chrisl]

Re:using javascript stored procedure in source connec

Can you post this channel to the file repository? Thanks!