Re: An Object with Two objects in a relationship search query

2007-07-19 Thread urugn urugn
Hay guys. It would do good to have the patch. Am eager for one. Mean while i kind of got to much used to DataObject query strategies and am wondering if any one could pass me a sample ROW SQL to use with SQLTemplate for outer join queries or a link to a resolved issue on the same. I tried somethin

Re: An Object with Two objects in a relationship search query

2007-07-19 Thread Mike Kienenberger
Or if you're using Cayenne 1.2, you can apply the outer join patch in the JIRA database. https://issues.apache.org/cayenne/browse/CAY-560 I just got back from a three-week vacation, but I'm hoping to port the patch over to 2.0 and 3.0 in the next month if my schedule isn't too busy. On 7/19/07,

Re: An Object with Two objects in a relationship search query

2007-07-19 Thread urugn urugn
Hi Andrus. Thanks A lot for your responce. Well i think coz of speed 1st option will be placed 1st. Altho i'll upgrade to 3 soon, that means i'll still somehow encouter the second option. Once again thanks, at least i know where to head to from here. Regards Urugn. --- Andrus Adamchik <[EMAIL P

Re: An Object with Two objects in a relationship search query

2007-07-19 Thread Andrus Adamchik
Hi Urugn, The problem seems to be that you need OUTER joins for relationships that may be NULL... Expressions are always resolved as INNER joins and hence you are getting no results. We've been discussing a fix for some time, but it is not there yet. For now you have two options: 1. Use S

An Object with Two objects in a relationship search query

2007-07-19 Thread urugn urugn
Hi guys. Let me start by saying that am very greateful. This coz of what the cay team has made things simple and first. Am just having a small problem which i think might have a simple solution, but can't figure it out. Am trying to query from a table T1 that has two objects T2 and T3 where if o

Re: show table status

2007-07-19 Thread Michael Gentry
I would think you'd be able to use an SQLTemplate to perform that kind of query: http://cayenne.apache.org/doc20/sqltemplate-query.html You'll want to call setFetchingDataRows(true) on your SQLTemplate object, too, otherwise Cayenne will try to make CayenneDataObjects out of it. Do this before

commit exception after server restart

2007-07-19 Thread Peter Schröder
hi, we have some trouble with our clustered applications. after restarting one of the servers the user gets a commit exception (see below). i think that this is already reported as a bug, but jira seems to be down... https://issues.apache.org/cayenne/browse/CAY-796 is there something we can do

show table status

2007-07-19 Thread Jack O'Connor
Hi all, in my project I need to extract the total db size(kb). Im using Cayenne 1.2.3 and MySQL and I found the SQL command "show table status from " which displays a table of information about all of the tables in a certain db. This table has columns like "Name"(of table), "Data_length" and "I

Re: Cayenne Query trivia

2007-07-19 Thread Andrus Adamchik
You are free to extend the query in any way you want, as long as it produces something understood by Cayenne in either 'route' or 'createSQLAction' method. So yeah, you can store parameters in your custom query, and later bind them via the existing API. Although by convention query doesn't

Re: Switching Between Databases

2007-07-19 Thread Malcolm Edgar
Thanks I will give it a try. regards Malcolm Edgar On 7/19/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote: > My concern it that the > schema name is defined in the cayenne mapping file. AFAIK MySQL schema is the same as "database name" part of the URL, so use an empty schema and change connec

Re: Usage in Axis2

2007-07-19 Thread Andrus Adamchik
That is strange... I assume Cayenne jars are in "axis2/WEB-INF/lib", and not in some shared location? Andrus On Jul 18, 2007, at 11:53 PM, Ajay H. Daptardar wrote: Hello all, I am trying to use Cayenne within Axis2. I copied the three configuration XML files into the classes folder for Axis

Re: Switching Between Databases

2007-07-19 Thread Andrus Adamchik
My concern it that the schema name is defined in the cayenne mapping file. AFAIK MySQL schema is the same as "database name" part of the URL, so use an empty schema and change connection URL. Andrus On Jul 19, 2007, at 5:23 AM, Malcolm Edgar wrote: Hi All, what is an easy way to swit

Re: Switching Between Databases

2007-07-19 Thread Joe Baldwin
Malcolm, OK, you asked for an idea (this is untested): Java defines a DataSource interface: http://java.sun.com/j2ee/sdk_1.3/techdocs/api/javax/sql/package- summary.html Is it possible to drill down and create a connection pool as described in this link and then set the desired DataSource