Details
-
Bug
-
Resolution: Fixed
-
Medium
-
None
-
5.5.3
Description
Tested with Hipchat Integration Plugin 6.11.1
Steps to Reproduce
- Setup Confluence, hooked to SQL Server 2008 or 2012
- Install the Hipchat Integration Plugin
- Navigate to Confluence Admin >> Hipchat Integration
- Click on "Select a Space", then search for a space
Notice that the search will spin forever.
In the logs, you will notice these errors:
2015-02-23 21:32:20,018 WARN [http-bio-8556-exec-1] [hipchat.spacetoroom.service.DefaultSpacesWithAdminPermissionProvider] findSpacesMatchingName Error encountered querying space list -- referer: http://localhost:8556/c556/plugins/servlet/hipchat/configure | url: /c556/rest/hipchat/spacetoroom/1.0/spaces | userName: admin net.sf.hibernate.exception.SQLGrammarException: Could not execute query at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:58) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4132) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1572) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at com.atlassian.confluence.plugins.hipchat.spacetoroom.service.DefaultSpacesWithAdminPermissionProvider.findSpacesMatchingName(DefaultSpacesWithAdminPermissionProvider.java:116) at com.atlassian.confluence.plugins.hipchat.spacetoroom.rest.SpaceToRoomSpaceResource.getSpaces(SpaceToRoomSpaceResource.java:41) ... Caused by: java.sql.SQLException: 'length' is not a recognized built-in function name. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) at net.sf.hibernate.loader.Loader.list(Loader.java:1054) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1569) ... 218 more