You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ojb-user@db.apache.org by Sy...@swisscom.com on 2003/03/19 16:05:24 UTC

how to send a real SQL query to OJB

Hello,

I have a String variable which contains a real SQL query like this:
"SELECT distinct(workstationName) FROM Workstation w, WntWorkstation t, Package p, Package_Workstation r WHERE (w.workstationName like '%' or w.workstationName is NULL) order by w.workstationName"

How can I send this query (as written above) to OJB?

Thanks
Sylvain

Re: how to send a real SQL query to OJB

Posted by Armin Waibel <ar...@code-au-lait.de>.

Hi Sylvain,

see FAQ
http://db.apache.org/ojb/faq.html

topic "Is it possible to perform my own sql-queries in OJB?"
+ "Can I directly obtain a java.sql.Connection within OJB?"

regards,
Armin

----- Original Message -----
From: <Sy...@swisscom.com>
To: <oj...@db.apache.org>
Sent: Wednesday, March 19, 2003 4:05 PM
Subject: how to send a real SQL query to OJB


Hello,

I have a String variable which contains a real SQL query like this:
"SELECT distinct(workstationName) FROM Workstation w, WntWorkstation t,
Package p, Package_Workstation r WHERE (w.workstationName like '%' or
w.workstationName is NULL) order by w.workstationName"

How can I send this query (as written above) to OJB?

Thanks
Sylvain

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org