Hi,
most databases do not allow to use a blob field in a where clause.
Probably Torque also does not support it, but you can check it by putting
it into a criteria and see what happens. But even then, you can always use
Criteria.CUSTOM if you know how the SQL should look like.
Thomas
"Ferruh Zamangoer" <[EMAIL PROTECTED]> schrieb am 01.06.2005
15:23:03:
> Hi,
>
>
>
> we are developing a legal p2p-filesharing system in JXTA combined with
web
> services and additionally we want to use a persistence layer. Our web
> services are running on a tomcat server. Before our p2p clients can
exchange
> any data they must verify on a Trusted Third Party(TTP) our web services
if
> the content they want to exchange is legal. Our web service have to
access a
> centralized database where we have for example two tables. One
Table(White
> List) holds the contents which are registered as sharable and a another
> table(Black List) contains the contents which are registered as not
> sharable. In these two tables the primary key is a blob field.
>
>
>
> My question is it possible to query in these fields. What I mean is that
my
> clients sends a byte[] and what the service had to do is to query these
two
> tables to see if it match to the primary key fields in theses two tables.
>
>
>
> Regards
>
> Ferruh
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
