mandubian/siena — Issue #12: Operator != not supported by JdbcPersistenceManager 
Author: joshx
Created: 2011-11-17 12:32:46+00:00
State: open

I've successfully applied a filter like

filter("fieldName!=", exceptionValue)

in a query on GAE. When I test the same coding on Postgres, I get the error message below.

Reason for this issue is a hard-coded limitation in the code of JdbcPersistenceManager line 494:

if(ClassInfo.isModel(f.getType())) {
if(!op.equals("=")) {
throw new SienaException("Unsupported operator for relationship: "+op);
}

(see http://groups.google.com/group/siena-discuss/browse_thread/thread/8833da633cacaf81)

-------------

SienaException occured : Unsupported operator for relationship: !=
play.exceptions.JavaExecutionException: Unsupported operator for
relationship: !=
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:229)
at Invocation.HTTP Request(Play!)
Caused by: siena.SienaException: Unsupported operator for relationship: !=
at siena.jdbc.JdbcPersistenceManager.appendSqlWhere(JdbcPersistenceManager.java:494)
at siena.jdbc.JdbcPersistenceManager.doFetchKeys(JdbcPersistenceManager.java:852)
at siena.jdbc.JdbcPersistenceManager.fetchKeys(JdbcPersistenceManager.ja va:946)
at siena.BaseQuery.fetchKeys(BaseQuery.java:146)