Re: Newbie questions about OJB capabilities

[Thomas Mahler]

Hi Alok,

Alok Pota wrote:

I wanted to know if OJB currently supports returning

 - Mapped objects obtained by running ad -hoc SQL queries ("select * from
... where ..") without using any special
   syntax for specifying the query

Yes that's possible with our QueryBySql Queries! We also provide ReportQueries that can be used to retrieve raw data from a resultset (can be combined with QueryByCriteria)

 - A java.sql.ResultSet or a wrapper there of that will help me get a finer
control on the returned data in
   cases where I don't want to return an object

Sure! You can use PersistenceBroker.getIteratorByQuery(..) to obtain a RsIterator that is essentially a wrapper around a ResultSet!

 - Running Stored procedures.

You can use OJB API to obtain a JDBC connection and perform arbitrary calls against it.
have a look at src/test/org/apache/ojb/broker/PerformanceJdbcReferenceTest.java for details.

cheers,
Thomas

-Alok


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>