Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-4902

Table/Column case issues in Proc&Task dashboard with MySQL,MS SQL Server & Sybase 15.7

    XMLWordPrintable

Details

    • NEW

    Description

      Having just a few selenium tests implemented and running them in DB matrix I again hit upon an issue with case sensitive databases (MySQL 5.7, MS SQL Server 2012 & Sybase 15.7) in Process & Task Dashboard (see screenshots).

      Since MySQL is quite popular and it has case sensitive columns by default, wouldn't it be better to use table and column names exactly as hibernate creates them (e.g. ProcessInstanceLog here?

      This would make the case sensitive databases happy and case insensitive ones wouldn't care. And more importantly we would get rid of similar issues and make it more easier to use for customers. Or is there any limitation in the backend that column names have to be converted to uppercase? I'm a little confused, because when I try creating new Table-based sql dataset I see, that in the dataset editor, the column names have correct case (i.e. as they are in the database - see 3rd screenshot).

      Maybe just fix this to equalsIgnoreCase? What do you think?

      Attachments

        1. Error_ProcessDashbaordTest_MySQL57.png
          Error_ProcessDashbaordTest_MySQL57.png
          70 kB
        2. Error_ProcessDashbaordTest_MYSQL57_2.png
          Error_ProcessDashbaordTest_MYSQL57_2.png
          64 kB
        3. BC_TABLE_ProcessInstanceLog.png
          BC_TABLE_ProcessInstanceLog.png
          69 kB
        4. server.log
          644 kB
        5. ServerLogsAndScreenshots.zip
          162 kB
        6. screenshotsAndLogs.zip
          497 kB

        Activity

          People

            david.magallanes David Gutierrez
            jhrcek Jan Hrcek (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: