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?
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?
Comment