Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Executing procedure in the source tab

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Executing procedure in the source tab

    Hi all!

    I'm trying to execute a stored procedure in the source tab. My procedure is going to return a result like a query "SELECT * FROM TABLE_NAME". The problem is how to retrieve the fields from the stored procedure?

    Follow below the code

    ================================================
    var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:jtds:sql server://server_name:9999/database_name','user','password');
    var result = dbConn.executeCachedQuery("EXEC PROCEDURE_NAME");

    dbConn.close();

    return result;
    ================================================


    Thanks!

    Alexander
Working...
X