Mirth Connect 4.3.0 Released!

Mirth Connect 4.3.0 is now available as an appliance update and on our GitHub page.

This is a major release containing new features like adding new functionality to the Mirth Connect Setup Wizard, adding the ability for resource and channel-specific classloaders to load child-first or parent-first, and added a default implementation of the getObjectsForSwaggerExamples() method in the ServicePlugin class. This release also contains enhancements for the Mirth Connect Administrator Launcher, the Mirth Connect Docker images, and several bug fixes and security improvements.

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

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

conversion of long

  • Filter
  • Time
  • Show
Clear All
new posts

  • conversion of long

    I read a value from the database in a transformer. The SQL datatype of this column is bigint.

    var Patient_Uid = result.getLong(1);  
    localMap.put("Patient_Uid", Patient_Uid);
    In the destination database writer, I want to write this out to another table.

    insert into sometable (Patient_Uid,...) values (${Patient_Uid},...);
    I get the following error message during the execution of the query:

    java.sql.SQLException: Error converting to long. 23.0 ...
    In this case, 23 was the bigint value retrieved from the database (Firebird).

    I hacked a solution by forcing the Patient_Uid variable to a string in Javascript as follows:
    var Patient_Uid = result.getLong(1) + ''
    This did the trick.

    Is there a better solution than this? My javascript knowledge is moderate at best.