Details
-
Bug
-
Resolution: Won't Fix
-
Low
-
None
-
3.4.8
-
None
Description
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