Uploaded image for project: 'Apache Roller'
  1. Apache Roller
  2. ROL-1873

Media File search with tags fails on MySQL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: 5.0
    • Fix Version/s: 5.0
    • Component/s: Media files / uploads
    • Labels:
      None

      Description

      Hmm.... I believe MySQL supports sub-selects these days.

      Maybe the 'SupportsSubselect' option mentioned below will work. Or, maybe I should take another shot at moving to OpenJPA 2.0.

      ERROR 2010-07-05 09:58:13,457 MediaFileView:search - Error applying search criteria
      <openjpa-1.2.1-r752877:753278 fatal general error> org.apache.openjpa.persistence.PersistenceException: The database dictionary in use ("class org.apache.openjpa.jdbc.sql.MySQLDictionary") reports that it does not have feature "SupportsSubselect". This feature is needed to complete the current operation. To force OpenJPA to try to use the feature anyway, set the following property:
      openjpa.jdbc.DBDictionary: SupportsSubselect=<value>
      at org.apache.openjpa.jdbc.sql.DBDictionary.assertSupport(DBDictionary.java:2571)
      at org.apache.openjpa.jdbc.kernel.exps.JDBCExpressionFactory.newSubquery(JDBCExpressionFactory.java:229)
      at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getSubquery(JPQLExpressionBuilder.java:1199)
      at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.eval(JPQLExpressionBuilder.java:1077)
      at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.eval(JPQLExpressionBuilder.java:1068)
      at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getExpression(JPQLExpressionBuilder.java:1408)
      at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.eval(JPQLExpressionBuilder.java:769)
      at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getExpression(JPQLExpressionBuilder.java:1408)
      at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.eval(JPQLExpressionBuilder.java:723)
      at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.evalWhereClause(JPQLExpressionBuilder.java:498)
      at org.apache.openjpa.kernel.jpql.JPQLExpressionBuilder.getQueryExpressions(JPQLExpressionBuilder.java:273)
      at org.apache.openjpa.kernel.jpql.JPQLParser.eval(JPQLParser.java:62)
      at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.<init>(ExpressionStoreQuery.java:661)
      at org.apache.openjpa.kernel.ExpressionStoreQuery.newDataStoreExecutor(ExpressionStoreQuery.java:170)
      at org.apache.openjpa.kernel.QueryImpl.createExecutor(QueryImpl.java:734)
      at org.apache.openjpa.kernel.QueryImpl.compileForDataStore(QueryImpl.java:692)
      at org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:674)
      at org.apache.openjpa.kernel.QueryImpl.getOperation(QueryImpl.java:1492)
      at org.apache.openjpa.kernel.DelegatingQuery.getOperation(DelegatingQuery.java:123)
      at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:243)
      at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:294)
      at org.apache.roller.weblogger.business.jpa.JPAMediaFileManagerImpl.searchMediaFiles(JPAMediaFileManagerImpl.java:617)
      at org.apache.roller.weblogger.ui.struts2.editor.MediaFileView.search(MediaFileView.java:238)

        Attachments

        1. screenshot-1.jpg
          40 kB
          David Johnson

          Activity

            People

            • Assignee:
              djohnson David Johnson
              Reporter:
              djohnson David Johnson
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: