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

stored procedures in javascript

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

  • stored procedures in javascript

    HELP.
    can anybody give me a sample code of how to call stored procedures in java? And I am not talking about executing a string "exec stored_P". I want to run it just like it's done in C#
    Code:
    SqlHelper.ExecuteReader(connectionString, "stored_P",Variables);
    or in Java
    CallableStatement stmt = con.prepareCall("{call stored_P}");
    stmt.executeQuery();

  • #2
    Re:stored procedures in javascript

    I'm looking for a way to access database with preparedStatement with JS, or instantiating some Java class from JS, but unsuccessfully (yet).

    The only clue I can give you is that you can instantiate a Java class from Javascript (from a JS reader/writer,transformer, whatever).

    This part is common for our problems

    Hope that help you...

    Comment


    • #3
      Re:stored procedures in javascript

      A search for "stored procedure" on the forum will turn up many results for how to call a stored procedure for nearly all versions of Mirth.
      Jon Bartels

      Zen is hiring!!!!
      http://consultzen.com/careers/
      Talented healthcare IT professionals wanted. Engineers to sales to management.
      Good benefits, great working environment, genuinely interesting work.

      Comment


      • #4
        Re:stored procedures in javascript

        Well, I'm doing some tests about this issue, and IMHO the only way is modifying the DatabaseConnection.java , in the com.webreach.mirth.server.util package of the Mirth sources.

        I also have checked the forums, but the solutions I've seen are using and "exec proc()", which you've discarded.

        I've seen that the methods we can access from DatabaseReader/Writer when JS is turned ON are located at the above class. So, in your case, you should add a method that uses a CallableStatement, like the code you appointed.

        BTW, why you have discarded the "exec proc()" approach ?

        Comment

        Working...
        X