[OJB-developers] "constant" values in where clause

[Matt G. <mat...@ss...>]

Hi,

I'm still trying to understand what's actually possible with OJB ...

If I have a table defined something like this:

    type varchar(xxx)
    short_name varchar(yyy)
    long_name varchar(zzz)

which might hold the following:

    "vehicle", "car", "small thing which can't seem to hold more that one
person at a time"
    "vehicle", "train", "long thing which is always late"
    "fruit", "apple", "green or red round thing"
    "fruit", "mango", "yum, yum"
    "fruit", "banana", "yellow, long and bendy. great with custard"
    ... etc, I'm sure you get the idea by now ;)

Can I tell OJB that I have a class called Fruit with public name and
description properties and ask OJB for all Fruit (for example) without
having to qualify that type='fruit' i.e. supply no Criteria to the query and
only get a list of fruit back?

Thanks, Matt
---
Matt Goodall
Analyst Programmer, Strategic Systems Solutions
e: mat...@ss..., t: +44 113 3892645