As EJBQL doesn't support full text search, I have to write a native sql such as:
Select * from articles where id in (Select id From articles_fulltext WHERE
MATCH (title,body) AGAINST ('keywords') ).
This might look easy to write. Howevery, if the articles table has 10 join
tables. This native sql would look very complicated e.g. select a.title,
a.author, b.name ... from articles as a, publishers as b ... where ...
The only part I need to write in native sql is the sub query. It would be great
if I can combine EjbQL and native sql like this:
ejbql=createQuery("Select a from articles as a");
nativeSql=createNativeQuery("Select id From articles_fulltext WHERE MATCH
(title,body) AGAINST ('keywords')");
ejbql.addSubQuery(nativeSql);
is ejb3 gonna support doing this?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3921430#3921430
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3921430
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
