Hi
After the new DB class implementation I got the following exception:
Exception: interbase.interclient.SQLException: [interclient][interbase]
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 147
UPPER
Later I found that the problem is that BasePeer adds an uppercase to the
order-by criteria. In other words the query looks something like this:
SELECT COL1, COL2 FROM TABLE ORDER BY UPPER (COL3).
Apparently some databases (Interbase for example) does not accept the "ORDER
BY UPPER". I removed the uppercase from BasePeer (diff at the end) and the
problem went away. I assume that this will not influence the working of
BasePeer for ORDER BY probably does not need for the column to be uppercase
to yield the correct sequence.
Let me know if my assumptions are wrong.
Regards
Leon
diff -r1.23 BasePeer.java
789,796c789
< if ( column.getType() instanceof String )
<
< orderByClause.add( db.toUpperCase(orderByColumn) );
< }
< else
< {
< orderByClause.add(orderByColumn);
< }
---
> orderByClause.add(orderByColumn);
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
