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

    Details

    • QE Status:
      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?

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                davidredhat David Gutierrez
                Reporter:
                jhrcek Jan Hrcek
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: