Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-5919

Setup should display error when database user does not have permissions to create tables

      The Setup doesn't display an error message when the user does not have permissions to create tables in the database. Instead it simply goes ahead to the next step to create a user and fails with the following exception:

      Cause:
      org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: Invalid object name 'os_user'.
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:85)
      caused by: java.sql.SQLException: Invalid object name 'os_user'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)

      Stack Trace: [hide]

      org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: Invalid object name 'os_user'.
      java.sql.SQLException: Invalid object name 'os_user'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
      at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)

      We should catch the lack of permissions earlier and display an appropriate error message.

            [CONFSERVER-5919] Setup should display error when database user does not have permissions to create tables

            No work has yet been logged on this issue.

              Unassigned Unassigned
              jens@atlassian.com jens
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: