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

Media File search with tags fails on MySQL

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Problem
    • 5.0
    • 5.0
    • Media files / uploads
    • 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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment