-
Bug
-
Resolution: Won't Fix
-
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:
- Open a URL like: http:<server>/display/aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
- Check the error message displayed
- 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....
| Workflow | Original: JAC Bug Workflow v3 [ 2890510 ] | New: CONFSERVER Bug Workflow v4 [ 2982811 ] |
| Workflow | Original: JAC Bug Workflow v2 [ 2803072 ] | New: JAC Bug Workflow v3 [ 2890510 ] |
| Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
| Workflow | Original: JAC Bug Workflow [ 2734740 ] | New: JAC Bug Workflow v2 [ 2803072 ] |
| Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2400160 ] | New: JAC Bug Workflow [ 2734740 ] |
| Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 [ 2299415 ] | New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2400160 ] |
| Workflow | Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2233898 ] | New: Confluence Workflow - Public Facing - Restricted v5 [ 2299415 ] |
| Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2195659 ] | New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2233898 ] |
| Workflow | Original: Confluence Workflow - Public Facing - Restricted v5 [ 1934435 ] | New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2195659 ] |
| Workflow | Original: Confluence Workflow - Public Facing - Restricted v3 [ 1733978 ] | New: Confluence Workflow - Public Facing - Restricted v5 [ 1934435 ] |
| Workflow | Original: CONF Bug Subtask WF (TEMP) [ 1692529 ] | New: Confluence Workflow - Public Facing - Restricted v3 [ 1733978 ] |