Re: How to do this in OJB

[] joinAttributes) I Hope this helps On 11/13/07, k jee wrote: Hi All, How can I write the following query in OJB? SELECT * FROM Table1 AS t1JOIN table2 AS t2 ON t1.fld1 = t2.fld1 AND t1.fld2= t2.fld2 AND t1.fld3= 1 Thanks, Krupa - Be a better pen pal. Text or chat

How to do this in OJB

Hi All, How can I write the following query in OJB? SELECT * FROM Table1 AS t1JOIN table2 AS t2 ON t1.fld1 = t2.fld1 AND t1.fld2= t2.fld2 AND t1.fld3= 1 Thanks, Krupa - Be a better pen pal. Text or chat with friends inside Yahoo! Mail.

Re: QueryBySQL

Thank you very much Armin. What do you think about the performance in those cases, where we have to traverse through this big result set and create our objects. Is there any efficient way to do this? Thanks, Krupa. Armin Waibel [EMAIL PROTECTED] wrote: Hi Krupa, krupa wrote: Hi All,

Re: Bind main/access classes to JNDI

code from web.xml dsForB2C javax.sql.DataSource Container Shareable - Original Message - From: k jee To: OJB Users List Sent: Wednesday, January 17, 2007 6:25 AM Subject: Re: Bind main/access classes to JNDI Armin, Thank you for your response. If I specify JNDI name like jdbc

Re: Bind main/access classes to JNDI

to bind the JNDI name in my startup class. Please help. Thanks. Armin Waibel [EMAIL PROTECTED] wrote: Hi, k jee wrote: Hi All, I am trying to use indirect JNDI for my web app in websphere application server. I followed the following doc and created OjbPbstartup class

Bind main/access classes to JNDI

Hi All, I am trying to use indirect JNDI for my web app in websphere application server. I followed the following doc and created OjbPbstartup class as explained. http://db.apache.org/ojb/docu/guides/deployment.html#bind-to-jndi When I try to access the getObjectByQuery

How to do this in OJB

Hi All, I need some advice on how to achieve the following with ojb. Select T1.FLD1,T1.FLD2, T2.FLD2,T2.FLD3,T3.FLD1,T3.FLD2,T3.FLD4 from table1 T1, table2 T2, Table3 T3,Table4 T4 where (T4.key1=XYZ) and(T3.somefield in (A,B)) and ( (T4.FLD3 = T1.FLD3) and (T4.FLD3 =T2.FLD3) and

Re: OJB Startup

Tomcat starts up using load-on-startup servlet attribute in web.xml InitServlet org.mff.web.serv.InitServlet 1 k jee wrote: Is there a preferred way to initialized OJB when starting a web app? Currently, on my system, OJB doesn't really load up until the first DB related call. Was wondering

OJB Startup

Is there a preferred way to initialized OJB when starting a web app? Currently, on my system, OJB doesn't really load up until the first DB related call. Was wondering if there were some call I could make to an OJB Factory class or whatever, to initialize OJB, other than making a call that

Criteria.addBetween

When I am trying to use criteria.addBetween(datefieldname,SQLdate1,SQLDate2) OJB is not creating the SQL with 2 values for between. here is what I see. Can some one please let me know what is wrong here. SystemOut O [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG:

Re: Criteria.addBetween

not the executed. please use p6spy to monitor the sql statement including all parameters. hth jakob k jee schrieb: When I am trying to use criteria.addBetween(datefieldname,SQLdate1,SQLDate2) OJB is not creating the SQL with 2 values for between. here is what I see. Can some one please let me

getCollectionByQuery

Hi I am trying to use getCollectionByQuery and I want to get the collection that is returned from this to be different than the object that I pass to the criteria. Is this possible? Can someone give me an example on how to do this? Thanks, Krupa