web stats
ORA data will not get returned - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 09-06-2012, 02:04 PM
MikeCaldwell MikeCaldwell is offline
Where are the forums?
Join Date: Mar 2008
Location: Sacramento, CA
Posts: 154
Default ORA data will not get returned

I built a chanel, works with SQL2008R2, the Channel Reads an HL7, pulls and ID the HL7 runs a stored procedure on a SQL server passing the ID, Data gets returned, I updated the HL7 Files with returned data and I move on.
I tried this with Oracle and no luck. I have the same type of code setup to do the same data pull but it is going against Oracle database and WILL NOT RETURN data EXCEPT when I make the source tab a direct connect (not use Java) it can get data in XML format. I have tried everything ot pull the data into transformation using JAVA and it resturns this thig. I need it in java, this is what I have tested. Again the connectio string works on a direct connect using the GUI, I get tables and Columns returned. The variable $('usr_loginname') always comes back blank which should come back with somehting like 'gsmith' etc....
I keep getting this in result>> com.sun.rowset.CachedRowSetImpl@122e772
OR I get .getString(0) is not a function.
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 = "";
// usr_loginname = result.getString(0);
channelMap.put('usr_loginname',$('usr_loginname')) ;

I've tried almost everything i can think, stillnot getting back data! HELP!
Mike Caldwell
Alliance HealthCare - GE VAR
Rocklin, CA
Centricity PM/EMR Support - Developer - Network Engineer
Reply With Quote

database, emr, oracle, results, sql

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -8. The time now is 02:19 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation