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

Long invalid space name results in database error rather than "page not found" for DB2 users....

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Fix
    • Icon: Low Low
    • None
    • 3.4.8
    • None

      When attempting to load a bogus space name that's very long, Confluence runs a query against the "spaces" table to see if it exists. For DB2 queries, this results in a database error:

      org.springframework.dao.DataIntegrityViolationException: Hibernate operation: Could not execute query; SQL []; DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.3.111; nested exception is com.ibm.db2.jcc.a.zn: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.3.111
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110)

caused by: com.ibm.db2.jcc.a.zn: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.3.111
    at com.ibm.db2.jcc.a.dd.a(dd.java:668)

      Here's the query:

      2011-02-24 22:00:02,029 DEBUG [http-8090-3] [net.sf.hibernate.SQL] log select space0_.SPACEID as SPACEID, space0_.SPACENAME as SPACENAME, space0_.SPACEKEY as SPACEKEY, space0_.SPACEDESCID as SPACEDES4_, space0_.HOMEPAGE as HOMEPAGE, space0_.CREATOR as CREATOR, space0_.CREATIONDATE as CREATION7_, space0_.LASTMODIFIER as LASTMODI8_, space0_.LASTMODDATE as LASTMODD9_, space0_.SPACETYPE as SPACETYPE, space0_.SPACEGROUPID as SPACEGR11_ from SPACES space0_ where (lower(space0_.SPACEKEY)=? )

      Steps to reproduce:

      1. Open a URL like: http:<server>/display/aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
      2. Check the error message displayed
      3. Check the application logs for database errors

            [CONFSERVER-21903] Long invalid space name results in database error rather than "page not found" for DB2 users....

            No work has yet been logged on this issue.

              drizzuto David Rizzuto
              aatkins TonyA
              Affected customers:
              0 This affects my team
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: