[ROL-1873] Media File search with tags fails on MySQL

• 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
• Assignee: David Johnson
• Reporter: David Johnson
• Created: 05/Jul/10 14:22
• Updated: 01/Jan/13 17:53
• Resolved: 12/Sep/10 15:48

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)