Hipchat Integration Does Not Work With Confluence Hooked To SQL Server

XMLWordPrintable

      Tested with Hipchat Integration Plugin 6.11.1

      Steps to Reproduce

      1. Setup Confluence, hooked to SQL Server 2008 or 2012
      2. Install the Hipchat Integration Plugin
      3. Navigate to Confluence Admin >> Hipchat Integration
      4. 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
      

            Assignee:
            Steve Haffenden (Inactive)
            Reporter:
            Foo Sim (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: