Bryan, Tore -
From past experience JDBC drivers do behave differently when binding
values in PreparedStatement, so it is driver-specific. Cayenne
addresses these differences by configuring ExtendedType subclasses per
DbAdapter. While adapters come pre-configured with the right "extended
types", still the users can customize this further in the code. However
the whole thing is getting out of hand, and I would love to provide a
better mechanism to configure the types (and likely refactor the
generic type to cover more cases transparently).
So what do we do now... We don't have an ExtendedType subclass for
boolean values, but probably we should create one until a more generic
solution is implemented. So could someone please open a bug report on
that, including the driver/db versions that fail? [Unfortunately I do
not have Oracle 8i to do the testing, but maybe I will be able to
reproduce this on 9i]
Thanks
Andrus
On May 30, 2004, at 3:21 AM, Tore Halset wrote:
> On 30. mai. 2004, at 04.01, Bryan Lewis wrote:
>
>> Should I form the query some other way? Maybe this is an Oracle
>> driver
>> problem?
>
> I am using MS SQL Server with the Microsoft JDBC driver and this
> (t0.IsManager = ? [bind: 'true']) just works. I have tried to change
> jdbc-driver for the same database to jTDS[1] and then I get the same
> error as you did. I am also using PostgreSQL and it works there.
>
> - Tore.
> [1] http://jtds.sourceforge.net/
This archive was generated by hypermail 2.0.0 : Tue Jun 01 2004 - 01:01:37 EDT