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] Created: (ROL-1873) Media File search with tags fails on MySQL
Date Mon, 05 Jul 2010 14:23:51 GMT
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


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