web stats
Mirth Community - View Single Post - ORA data will not get returned
View Single Post
  #4  
Old 09-06-2012, 08:18 PM
ami199102 ami199102 is offline
OBX.2 Kenobi
 
Join Date: May 2012
Location: India
Posts: 70
ami199102 is on a distinguished road
Thumbs up

try this
Code:
var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbcracle:t hin:@x.x.x.x:1521rasid','login','pass');
var thequery = "SELECT USR.loginname AS usr_loginname FROM ML.USR WHERE ROWNUM=1";
var result = dbConn.executeCachedQuery(thequery);
var last_updated_date = "";
if(result.first()){
var loginname = result.getString(1); or var loginname=result.getString('loginname');
channelMap.put('result',result);
channelMap.put('usr_loginname',loginname,) ;
}
dbConn.close()
__________________
Amarnath. K
http://amarnathks.wordpress.com
Reply With Quote