You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by "David Johnson (JIRA)" <ji...@apache.org> on 2010/07/05 16:23:51 UTC
[jira] Created: (ROL-1873) Media File search with tags fails on
MySQL
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.
[jira] Resolved: (ROL-1873) Media File search with tags fails on
MySQL
Posted by "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 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.
[jira] Updated: (ROL-1873) Media File search with tags fails on
MySQL
Posted by "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.