Hi, I'm trying to do some tests with JCR SQL2 but i'm facing an issue.
The following code return an /IllegalArgumentException/ String sqlStmt = "SELECT * FROM [nt:file] AS a WHERE ISCHILDNODE( a, '/' ) AND LOCALNAME() LIKE $var"; Query query = queryManager.createQuery( sqlStmt, Query.JCR_SQL2 ); String[] bindVariableNames = query.getBindVariableNames(); query.bindValue( "var", session.getValueFactory().createValue( "%test" ) ); // IllegalArgumentException QueryResult result = query.execute(); In fact, query.getBindVariableNames() returns an empty array. The full error is : /java.lang.IllegalArgumentException: var is not a known bind variable name in this query/ I'm currently using Jackrabbit 2.8 Did i miss something? regards, Nicolas -- View this message in context: http://jackrabbit.510166.n4.nabble.com/Cannot-bind-variable-JCR-SQL2-IllegalArgumentException-tp4663694.html Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
