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. BC_TABLE_ProcessInstanceLog.png
          69 kB
          Jan Hrcek
        2. Error_ProcessDashbaordTest_MYSQL57_2.png
          64 kB
          Jan Hrcek
        3. Error_ProcessDashbaordTest_MySQL57.png
          70 kB
          Jan Hrcek
        4. server.log
          644 kB
          Jan Hrcek

        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: