gmane.comp.java.cayenne.user

Re: Domain configuration file "cayenne.xml" is not found.

Kanwar Manish — 2012-05-25T06:37:40

Worked - Possible Bug? [Not Solved - because I don't understand how it
worked. Two approaches below]

Question is - if the postgres jdbc jar is missing - why should the error be
- "....cayenne.xml not found...". Please read for details.

Thanks Guys for all the help. Please remember that I am a .NET specialist
and a Java newbie [phew - talk about being deadly ;-)]

Here is what I did - 1st approach

1. Moved to conf files to the default package.

2. Stepped through lot of errors for dependencies like Commons-Collections,
Ashwood and JDBC driver not found.

3. Used code below - and it worked.

"
        DefaultConfiguration conf = new DefaultConfiguration();
        conf.addClassPath("mypackage");
        Configuration.initializeSharedConfiguration(conf);
        DataContext context = DataContext.createDataContext();
        return context;
"

2nd Approach

To test out Michael's suggestion of keeping the '<context-param> section
before <filter> and <filter-mapping>', I moved back the config files to the
locat

Re: Domain configuration file "cayenne.xml" is not found.

Mike Kienenberger — 2012-05-24T15:33:38

Yes, dependent on your servlet version, context-param definitely has
to be the first section in the file.

Also, make sure that you're including the files in your war/ear.
Obvious, but sometimes still the cause :)

On Thu, May 24, 2012 at 8:54 AM, Michael Gentry <mgentry< at >masslight.net> wrote:

Re: Domain configuration file "cayenne.xml" is not found.

Michael Gentry — 2012-05-24T12:54:04

Hi there,

I'm not a servlet guru (I know enough to get by and have my Tapestry
apps run), but I always put my <context-param> section before <filter>
and <filter-mapping>.  May not make a difference, but worth trying.  I
haven't looked through the source extensively, but you seem to be on
the right path from what the JavaDocs say.

mrg


On Thu, May 24, 2012 at 3:13 AM, Kanwar Manish <kanwarmanish< at >gmail.com> wrote:

Re: Queries with multiple tables and results

pk_cayenne — 2012-05-24T12:20:09

OK I understand.

--
View this message in context: http://cayenne.195.n3.nabble.com/Queries-with-multiple-tables-and-results-tp4006413p4013416.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

Domain configuration file "cayenne.xml" is not found.

Kanwar Manish — 2012-05-24T07:13:27

Sorry guys, I am posting this bugger again.

But it has turned out to be a bummer for me.

I am using NetBeans 7.1.1
JDK 1.7

cayenne files are in the folder - "/WEB-INF/config/cayenne-files". Total
three files cayenne.xml, map and node files.

Error:
"[v.3.0.2 Jun 11 2011 09:26:09] Error during Configuration initialization.
[v.3.0.2 Jun 11 2011 09:26:09]
[org.apache.cayenne.conf.DefaultConfiguration] : Domain configuration file
"cayenne.xml" is not found."

My XML File section for cayenne:
"
    <filter>
        <filter-name>CayenneFilter</filter-name>

<filter-class>org.apache.cayenne.conf.WebApplicationContextFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>CayenneFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    <context-param>
        <param-name>cayenne.configuration.path</param-name>
        <param-value>/WEB-INF/config/cayenne-files</param-value>
    </context-param>
"

Thanks in Advance

I have searched this where I can - but not able t

Re: Cayenne cache strategy

Andrus Adamchik — 2012-05-23T13:02:04

Correct. There's no good generic algorithm to efficiently detect which cached lists should be flushed on commit, so yes, commits have no effect on query cache by default.


I would recommend using "cache groups" to categorize queries - query.setCacheGroups("somegroup"). Then you can setup your own cache invalidation calling queryCache.removeGroup(..) when certain types of objects are committed.

In Cayenne 3.1 we went a step further, and created < at >CacheGroups annotations and CacheInvalidationFilter that allow to do the above declaratively. E.g.:

< at >CacheGroups("abc")
class Artist extends _Artist {}

The above declaration would ensure that all cached queries that used "abc" cache group are flushed when any Artist object is committed.

Andrus


On May 23, 2012, at 8:07 AM, cghersi wrote:

Cayenne cache strategy

cghersi — 2012-05-23T12:07:48

Hi all,

I'm trying to use the query cache of Cayenne 3.0.

My code snippet for the typical query is:

private List query(Expression qualifier) {
  DataContext context = config.getDomain("MyDomain").createDataContext();
  SelectQuery select = new SelectQuery(MyClass.class, qualifier);
  select.setCacheStrategy(QueryCacheStrategy.SHARED_CACHE);
  return context.performQuery(select);
}

With this code, if I call my query() method in the following way List b is
empty:
Expression qualifier = ... //my filters
List a = query(qualifier);

DataContext context = config.getDomain("MyDomain").createDataContext();
//this is another context with respect to the one used in query()
MyClass newObj = context.newObject(MyClass .class);
// set props of newObj
context.commitChanges();

List b = query(qualifier); //the same qualifier resulting in List a

The problem seems related to the fact that committing the changes regarding
the newly created object doesn't result in a refresh of the Cayenne cache,
and so the very same resul

Re: Spring Security authentication

Malcolm Edgar — 2012-05-23T07:17:00

You need to put a Cayenne DataContext Filter in front of the SpringSecurity
filter.

regards

On Wed, May 23, 2012 at 3:36 PM, Tony Giaccone <tony< at >giaccone.org> wrote:

Spring Security authentication

Tony Giaccone — 2012-05-23T05:36:20


I'm trying to implement a Spring Security Authentication using Cayenne. 

The problem is that when the spring security gets called, there's no context associated with the thread.  So this method:

  BaseContext.getThreadObjectContext();

Throws an exception.  I'm just not sure at this point how to set up the context and start the process of doing fetches. 


Tony

Re: Queries with multiple tables and results

Aristedes Maniatis — 2012-05-23T04:10:29

I'll chime in with the "you probably aren't doing it the Cayenne way" response. Why do you want a mixture of two different records in the one result set? I can think of two reasons:

1. You have two tables which represent similar things: Customers and Suppliers. You want to query them together to get a list of Contacts. In that case modelling them with a common superclass might be a more helpful approach. Read up on Cayenne inheritance.

2. You have a Contacts table but are trying to optimise the SQL by returning Invoices at the same time since you know you need to iterate through both. In this case, just query on Contacts and ignore Invoices. Cayenne will fetch those as you need them and reference them. contact.getInvoices() will fault them from the database as required.

If you are worried about performance of this approach, prefetching as Michael pointed you in the docs will solve that.


Ari


On 22/05/12 10:58pm, pk_cayenne wrote:

Re: Queries with multiple tables and results

Michael Gentry — 2012-05-22T15:36:07

Hi Pierre,

If you want actual Java objects back (Table1 and Table2), you could do
a normal SelectQuery(Table1.class) and add a prefetch to Table2 to
efficiently read those records in:

http://cayenne.apache.org/doc/prefetching.html

Of course, this will read in all records from Table1 and Table2, which
may be a big memory footprint.

mrg


On Tue, May 22, 2012 at 10:56 AM, pk_cayenne <pierre.kouvel< at >uhb.fr> wrote:

Re: Queries with multiple tables and results

pk_cayenne — 2012-05-22T14:56:18

Hi Emerson,

I try the Option 2  and the result return a list of *DataRow *(which
contains my  expected values) 

 SQLTemplate query = new SQLTemplate(Table1.class,sql);
  query.setFetchingDataRows(true); 
  List <DataRow> rows =(List <DataRow>) context.performQuery(query);


Best Regards.

--
View this message in context: http://cayenne.195.n3.nabble.com/Queries-with-multiple-tables-and-results-tp4006413p4006810.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

Re: Queries with multiple tables and results

Emerson Castañeda — 2012-05-22T13:19:10

Hi Pierre

For that cases with queries with many tables I know about  two options:


Option 1:
Coding an store procedure in you database that includes your query and then
invoque the procedure recovering the composed results from two or more
tables, someway like this:


ProcedureQuery query = new ProcedureQuery("YOURPROCEDURE");
// Set "IN" parameter values
query.addParameter("THEPARAM1", ID1);
// run query
QueryResponse result = getDataContext().performGenericQuery(query);
// QueryResponse result = performNonSelectingQuery(query);
// read OUT parameters
List outList = result.firstList();
if (outList.size() > 0) {
Map outParameterValues = (Map) outList.get(0);
Object[] r = outParameterValues.values().toArray();
 return r;
}
return null;



Option 2:
Using SQLTemplate class:


 String pgTemplate = "SELECT *"
                + " FROM table1, table2 WHERE"
                + " ID1 = ID2  AND ID1=X"

        SQLTemplate query = new SQLTemplate(Observacion.class, pgTemplate);
        query.setFetchingDataRows(true

Re: Queries with multiple tables and results

pk_cayenne — 2012-05-22T12:58:43

Hi,
Unfortunatly i'm not referring to an "inner join" .

What i see in the documentation is that i can  only fetch data from a
*single table   * with  the /SelectQuery(Class<?> objectClass, Expression
e)/.

But in my queries I have at least two tables. I don't how to get a resulset
like as list.
Something like  Object[] result = context.performQuery("myQuery").

 I don't know if what I'm saying is understandable.


--
View this message in context: http://cayenne.195.n3.nabble.com/Queries-with-multiple-tables-and-results-tp4006413p4006594.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

Re: Queries with multiple tables and results

Joe Baldwin — 2012-05-22T12:12:39

If what you are referring to is an "INNER JOIN" then you might look into the documentation here

http://cayenne.apache.org/doc30/qualifier-expressions.html

You would need to create a Qualifier Expression object using the Cayenne JOIN Semantics, to give to the Query object.

Someone else might be able to give an example of a suitable Cayenne Expression.

Joe

On May 22, 2012, at 6:54 AM, pk_cayenne wrote:

Queries with multiple tables and results

pk_cayenne — 2012-05-22T10:54:48

Hello,
I am a newbie with in cayenne and in english too.
I am using cayenne 3.0.2
Here is my probleme
I have two tables let say *table1 (id1, name, surname)* and *table2(id2,
title, amount)* with oracle database
And  my query is like this  
 select name, title, amount  from table1, table2 where id1=id2

Now my  question : Would you show me , how  can I end up with it (concrete
example please)? (I mean my result must be   objetcs []). I did not see
anything in the cayenne doc that meet  my needs.

Thank you very much for your help

--
View this message in context: http://cayenne.195.n3.nabble.com/Queries-with-multiple-tables-and-results-tp4006413.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

Re: External transactions...

Daniel Scheibe — 2012-05-18T15:32:27

Hi Andrus,

thanks for elaborating on this topic. The missing piece in the puzzle 
was that the ObjectContext will request a connection from the DataSource 
on demand. Having the ObjectContext independently available from the 
transaction scope is another benefit for me.

Thanks for clearing this up, wish you guys a nice weekend!

Regards,
Daniel

Am 18.05.2012 09:14, schrieb Andrus Adamchik:

Re: External transactions...

Andrus Adamchik — 2012-05-18T07:14:44

Hi Daniel,


Correct.


Cayenne is not Hibernate. ObjectContext is not connected to DB and is always "valid" until it goes out of scope. 


ObjectContext will request a new connection from the DataSource. Whether it can be granted at a given point or not depends on your app.

So again, unlike in Hibernate, you can keep your context around between multiple transactions. All selects (direct, or when reading lazy relationships) as well as commits result in connection request from a DataSource, so it has to be in a valid state (within an open tx?) when that happens. After an operation is performed, Cayenne closes the Connection and becomes "disconnected" again. 

Does it clarify things a bit?

Andrus


On May 16, 2012, at 11:47 PM, Daniel Scheibe wrote:

Re: multiple database querying

Andrus Adamchik — 2012-05-18T06:53:11

I just merged that to CAY-1152, which is a similar issue.

Andrus


On May 17, 2012, at 9:52 PM, Bryan Lewis wrote:

Re: modeler + db migration NPE

Robert Zeigler — 2012-05-17T19:01:28

Appears to have been fixed in trunk already.

Robert

On May 17, 2012, at 5/171:39 PM , Robert Zeigler wrote:

Re: multiple database querying

Bryan Lewis — 2012-05-17T18:52:18

Right you are.  CAY-1707.


On Thu, May 17, 2012 at 2:21 PM, John Huss <johnthuss< at >gmail.com> wrote: