roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Johnson (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (ROL-1873) Media File search with tags fails on MySQL
Date Sun, 12 Sep 2010 15:48:33 GMT

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

David Johnson resolved ROL-1873.
--------------------------------

      Assignee: David Johnson
    Resolution: Not A Problem

My bad. I had this setting in my roller-custom.properties:

   openjpa.jdbc.DBDictionary=mysql(SupportsSubselect=false, SearchStringEscape=\\\\)

Once I deleted that, search for tags works fine.

> 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
>            Assignee: 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.


Mime
View raw message