Discussions

EJB design: smart querying in database

Bookmark and Share Get thread feed

  1. smart querying in database (3 messages)

    Hi all, I want to know if there is any way on how to do 'smart' queries on a database... Eg: Suppose I have a database of cars of color dark blue, and plain blue. If i give query of black, then it should result in cars of dark blue in the top of results (as dark blue and black are somewhat close visually speaking). I also want to do this through EJB (2.0) and hence, EJBQL, so I want to know how it will affect my design.. Plz point me in the right direction.. Thanks in advance!
    Reply to this

    Threaded Messages (3)

  2. Re: smart querying in database[ Go to top ]

    for sure, I would not use EJB 2.0. have you checked out the newest spec - EJB 3.0 ?
    Reply to this Reply to original

  3. Re: smart querying in database[ Go to top ]

    How is your database table design..Do you have a column called "Colour" and you store the records for "Dark Blue" and "Plain Blue" color cars as 2 different records. If yes, then how can you expect the Query to give you "Dark Blue", if your query has "Dark Blue" in its predicate?
    Reply to this Reply to original

  4. Re: smart querying in database[ Go to top ]

    I would not recommend putting such logic at EJB layer. Writinng it at DB level (stored procs) is much better.
    Reply to this Reply to original