text retrieval WWW <> Java <> DB

[schw...@informatik.uni-kl.de]

Hi world!

Question: Is there any combination of a DB system and a JDBC driver
that can select DB entries by queries like
'string contains substring "xy"' ?

I have to build a system for doing text retrieval on short
texts (held in DB fields) from the web.

I don't think that it is SQL standard, and so I'm not sure if
I can evaluate those queries through a JDBC/ODBC bridge on a
given MS Access DB.

Any hints?

alex.

[RobO]

schw...@informatik.uni-kl.de wrote in message
<702m14$luk$1...@irz1.informatik.uni-kl.de>...

>Question: Is there any combination of a DB system and a JDBC driver
>that can select DB entries by queries like
>'string contains substring "xy"' ?

if you have only to lookup in one varchar column, you can find the
substring using this select :

Select MyColumnContainingSubtext From mytextTable
where MyColumnContainingSubtext LIKE '%searchstring%' ;

You can send this select via ODBC too!

Rob