LIKE with Numeric columns

[Olmanson, Alan]

Hello,

Should the LIKE Criteria be able to work with Numeric columns?

If in the QueryTest.java test case I add the following to the
testLikeCriteria():

        crit = new Criteria();
        crit.addLike("id", "%");
        q = QueryFactory.newQuery(Person.class, crit);

        results = broker.getCollectionByQuery(q);
        assertNotNull(results);

I get a this error:

java.sql.SQLException: Wrong data type: %
        at org.hsqldb.Trace.getError(Unknown Source)
        at org.hsqldb.Trace.error(Unknown Source)
        at org.hsqldb.Column.convertObject(Unknown Source)
        at org.hsqldb.jdbcPreparedStatement.setObject(Unknown Source)
        at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Pl
atformDefaultImpl.java:220)
        at
org.apache.ojb.broker.accesslayer.StatementManager.bindStatementValue(Statem
entManager.java:253)
        at
org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(StatementMa
nager.java:293)
        at
org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(StatementMa
nager.java:463)
        at
org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(JdbcAccess.java:25
5)

I get a similar error for MS SQL and Oracle.

However in both, MS SQL and Oracle, "WHERE id LIKE '%'" is valid. 

Alan

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>