Tutorials

2006-03-23 Thread ca . ddy
Hey everybody, are there any Tutorials that you can advice for learning to use the OJB especially in the JSP Context. I want to try to self study using ojb... I am developing on Eclipse Version3 and the Server is a Tomcat V5. Thanks a lot !! Caddy Hint : I know that there are some on the OJB

Re: Tutorials

2006-03-23 Thread Stas Ostapenko
Take a look at this http://apache.org/dist/db/ojb/db-ojb-1.0.4/webapp-sample.jar. This is a good example of using OJB, Struts and JSP all together. On 3/23/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hey everybody, are there any Tutorials that you can advice for learning to use the OJB

auto delete and foreign keys

2006-03-23 Thread Jean-Yves Sironneau
Hello, Yes another question again. I have a class Area that is referencing a class Point, and Area has a foreign key constraint on Point. I'am using ODMG, and i would like OJB to delete the Point when i delete the Area. What happens is that when i commit a transaction for removing an Area, OJB

Subqueries in ODMG query

2006-03-23 Thread Eric Kelm
Is it possible to use a subquery inside of an ODMG query e.g. select jobs from + JobBO.class.getName(); where employees_idemployee = + employee.getIdEmployee(); idjob like $1 or idtask_code like (select task_codes from + TaskCodeBO.class.getName(); where task_code_name like $2

RE: Subqueries in ODMG query

2006-03-23 Thread Eric Kelm
Sorry mistyped Is it possible to use a subquery inside of an ODMG query e.g. select jobs from + JobBO.class.getName(); where employees_idemployee = + employee.getIdEmployee() + and (idjob like $1 or idtask_code like (select task_codes from + TaskCodeBO.class.getName(); where

Re: Subqueries in ODMG query

2006-03-23 Thread Vasily Ivanov
http://db.apache.org/ojb/docu/guides/query.html#subqueries On 3/24/06, Eric Kelm [EMAIL PROTECTED] wrote: Is it possible to use a subquery inside of an ODMG query e.g. select jobs from + JobBO.class.getName(); where employees_idemployee = + employee.getIdEmployee(); idjob like $1 or

RE: Subqueries in ODMG query

2006-03-23 Thread Eric Kelm
Thanks, but I was looking for something using ODMG-API, not PB-API. I did find this test case and my query looks similar except that I have 2 different object types in my query. /** + * test Subquery + * get all articles with price avg(price) + * PROBLEM: avg(price) is NOT