[jira] Updated: (ROL-1873) Media File search with tags fails on MySQL

["David Johnson (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ROL-1873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Johnson updated ROL-1873:
-------------------------------

    Attachment: screenshot-1.jpg

> Media File search with tags fails on MySQL
> ------------------------------------------
>
>                 Key: ROL-1873
>                 URL: https://issues.apache.org/jira/browse/ROL-1873
>             Project: Roller
>          Issue Type: Bug
>          Components: Media files / uploads
>    Affects Versions: 5.0
>            Reporter: David Johnson
>             Fix For: 5.0
>
>         Attachments: screenshot-1.jpg
>
>
> 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)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.