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

Is Postgres 8.3 supported?

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

  • Is Postgres 8.3 supported?

    After upgrading an ubuntu sytem to postgres 8.3 I get the following error from Mirth 1.6 when trying to log in:

    Code:
    Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
    --- The error occurred in postgres/postgres-user.xml.  
    --- The error occurred while applying a parameter map.  
    --- Check the loginUser-InlineParameterMap.  
    --- Check the statement (update failed).  
    --- Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
    I have updated my postgres jar in <mirthhome>/lib/custom to the latest version (http://jdbc.postgresql.org/download/...-603.jdbc4.jar) .
    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.

  • #2
    Re:Is Postgres 8.3 supported?

    /var/log/postgresql/postgresql-8.3-main.log says:

    Code:
    2008-05-23 16:57:12 EDT ERROR:  operator does not exist: integer = character varying at character 52
    2008-05-23 16:57:12 EDT HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
    2008-05-23 16:57:12 EDT STATEMENT:              UPDATE PERSON           SET LOGGED_IN = TRUE            WHERE ID = $1
    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


    • #3
      Re:Is Postgres 8.3 supported?

      Strange, we haven't had any problems here. We'll look into it and let you know what we find.
      Jacob Brauer
      Director, Software Development
      NextGen Healthcare

      sigpic

      Comment


      • #4
        Re:Is Postgres 8.3 supported?

        jacobb wrote:
        Strange, we haven't had any problems here. We'll look into it and let you know what we find.
        I upgraded to 1.7.1 and it stopped complaining. So its likely isolated to 1.6.

        One of my other developers saw a similar issue with our software. It has to do with postgres 8.3 expecting integers to be quoted or not. We're not sure if its the same issue here, but the error messages are the same.

        Post edited by: jbartels, at: 05/27/2008 06:13
        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


        • #5
          Re:Is Postgres 8.3 supported?

          Mirth 1.6 did not work with PostgreSQL 8.3, but the issue was fix in 1.7 as you have noticed.
          Gerald Bortis | Chief Information Officer | Mirth Corporation

          Comment

          Working...
          X