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

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
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


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

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 02:50 AM.

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