web stats
Oracle DB procedure call problem between Windows and Linux - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2012, 07:43 AM
kresok kresok is offline
What's HL7?
 
Join Date: Aug 2011
Posts: 4
kresok is on a distinguished road
Default Oracle DB procedure call problem between Windows and Linux

I have following problem with calling Oracle DB procedure from Windows and Linux

We develop channel that calls Oracle DB procedure with input and output parameters.
Our code looks like this:

var dbConn = java.sql.DriverManager.getConnection($('dbConnecti onString').toString(),$('dbUser').toString(),$('db Password').toString());
var statement = dbConn.nativeSQL("{call bsn_eliste_pkg.dohvati_termin(?,?,to_date(?,'rrrrM Mddhh24miss'),?,?,?,?,?,?)}");
var spstmt = dbConn.prepareCall(statement);

//... setting input parameters and registering output parameters omitted


spstmt.execute();


The proble is following when we deploy this channel on Mirth running on Windows machine it works just fine and returns correct results but when we deploy the same channel on Mirth running on Linux machine for sam input parameters we get different results that are not correct.

Did someone run into similar problem an what we are doing wrong.

We are running Mirth Connect 2.1.1.5490 but we also try latest version and try to install MIrth on RedHat and Ubuntu with same result.
We also tried to install mirth on different windows machines an on each machine it returns the same result that is correct while on each Linux machine it returns also the same result but different than on windows machine
Reply With Quote
Reply

Tags
db proc call, different win linux, oracle

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 11:15 PM.


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