Re: Joining unrelated tables

[Jakob Braeuchi]

hi divakar,

ojb does not support joining unrelated tables because the joins
are always built base on relationships defined in the repository.

you can use a QueryBySql which supports almost any sql-clause.

jakob

Sri Divakar schrieb:

 Hi,
  
  I am facing a problem of joining two unrelated tables using 
queryByCriteria (reportQueryByCriteria).
  
  For example:
  Table T1{sno integer, id integer, desc varchar} and 
  Table T2{rollno integer, number integer, value varchar} 
are two tables with out any relation between them (i.e., there are no 
path-expressions in any of the class-descriptors).
  
  I want to write a Query (QueryByCriteria/ReportQueryByCriteria), 
which is equivalent to this SQL query:
  
  SELECTT1.sno, T1.id, T1.desc, T2.value

  FROM T1, T2
  WHERE T1.id = T2.number
  
  
Thanks for any help/idea/comment/hint.
  
-Divakar
  



-
 Yahoo! FareChase - Search multiple travel sites in one click.  


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

Criteria.addBetween

[k jee]

  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: 
executeQuery : Query   from class xx.yyy where [crit1 = 100,   crit2 = 29867, 
[crit3 = K,   [crit3 = E, [crit3 = D], [crit3 = S], [date1 BETWEEN   
2005-11-18, time BETWEEN 14:00:00
  
  
  Thanks,
  Krupa


-
 Yahoo! FareChase - Search multiple travel sites in one click.  

Re: Criteria.addBetween

[Jakob Braeuchi]

hi krupa,

what you see isan output of the query 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 know what is wrong here.


SystemOut O   [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeQuery : Query   from class xx.yyy where [crit1 = 100,   crit2 = 29867, [crit3 = K,   [crit3 = E, [crit3 = D], [crit3 = S], [date1 BETWEEN   2005-11-18, time BETWEEN 14:00:00
  
  
  Thanks,

  Krupa


-
 Yahoo! FareChase - Search multiple travel sites in one click.  


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

Re: Criteria.addBetween

[k jee]

Hi Jakob,
  
  Thanks for your prompt reply.
  
  I was not able to get the p6spy work with websphere . Can you suggest any 
other way to see if the between is actually working.
  
  thanks,
  Krupa

Jakob Braeuchi [EMAIL PROTECTED] wrote:  hi krupa,

what you see isan output of the query 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 know what is wrong here.
 
 
  SystemOut O [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG:  
 executeQuery : Query from class xx.yyy where [crit1 = 100, crit2 =  29867, 
 [crit3 = K, [crit3 = E, [crit3 = D], [crit3 = S], [date1 BETWEEN  2005-11-18, 
 time BETWEEN 14:00:00
   
   
   Thanks,
   Krupa
 
   
 -
  Yahoo! FareChase - Search multiple travel sites in one click.  

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





-
 Yahoo! FareChase - Search multiple travel sites in one click.