InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Vidur

With InstantDB you can't compare a double value against a binary value.
InstantDB knows very little about the structure of binary data. It
essentially classifies it as a string, a Java object, or as anything else.
In the case of "anything else" it doesn't know whether its a number, an
image or whatever, so it doesn't know how to perform the compare.

I couldn't reproduce exactly the same exception though. Maybe you could
alter the attached script to bring it closer to what you're trying to do?

Regards

Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Vidur Dhanda <vdhanda@active-solutions-inc.com>
To: instantDB <instantDB@enhydra.org>
Date: 04 July 2000 21:09
Subject: InstantDB: longvarbinary column in where clause


>Hello,
>
>Is it possible to test for equality on a longvarbinary column.  When I
>use a prepared statement -- select * from A where longvarbinarycolumnB =
>an instance of a Double,  I get an exception:
>java.sql.SQLException: java.lang.Double
> at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276)
> at
>org.enhydra.instantdb.jdbc.idbPreparedStatement.execute(idbPreparedStatemen
t.java:92)
>
> at
>org.enhydra.instantdb.jdbc.idbPreparedStatement.executeQuery(idbPreparedSta
tement.java:59)
>
>Thanks,
>Vidur
>
>---------------------------------------------------------------------------
--
>To unsubscribe from this mailing list, send email to majordomo@enhydra.org
>with the text "unsubscribe instantdb" in the body of the email.
>If you have other questions regarding this mailing list, send email to
>the list admin at owner-instantdb@enhydra.org.
>

d org.enhydra.instantdb.jdbc.idbDriver;
o jdbc:idb:e:/instantdb/bugs/sample.prp;

c set timeout 10000;
e SET EXPORT "trace.log" TRACE 6 CONSOLE;

e drop table Test;
e CREATE TABLE Test (long1 longvarbinary);
e insert into test values (10);
e select * from test where long1=10.0;

c close;
c exit;