Re: rollbackChangesLocally

2007-11-26 Thread Andrus Adamchik
? Thanks -p From: Andrus Adamchik [mailto:[EMAIL PROTECTED] Sent: 07 December 2006 08:13 To: [EMAIL PROTECTED] Subject: Re: rollbackChangesLocally This message has been archived. View the original item

Re: ExtendedType and IN operator

2007-11-26 Thread Andrus Adamchik
Chris, I vaguely remember this being a problem in the past and us fixing it... I couldn't find any references via Google (having IN as a keyword doesn't help). So could you post the code that builds the query and the exact Cayenne version. Thanks Andrus On Nov 23, 2007, at 3:39 AM,

Re: Cayenne and Apache Wicket

2007-11-26 Thread Andrus Adamchik
Me too. Never heard enough motivation to try Wicket, but if somebody does a Cayenne tutorial with it, I might as well do it :-) Andrus On Nov 24, 2007, at 11:01 AM, Adrian Wiesmann wrote: Hello all Has anybody experience using Cayenne with the Apache Wicket Framework? I'd be interested

Re: Cayenne and Apache Wicket

2007-11-26 Thread Andrus Adamchik
oops... heard - had On Nov 26, 2007, at 2:45 PM, Andrus Adamchik wrote: Me too. Never heard enough motivation to try Wicket, but if somebody does a Cayenne tutorial with it, I might as well do it :-) Andrus On Nov 24, 2007, at 11:01 AM, Adrian Wiesmann wrote: Hello all Has anybody

Re: Cayenne 3.0M2 for Production

2007-11-26 Thread Andrus Adamchik
Yeah... Previously existing API that was not marked for deprecation should remain fairly stable. Runtime, while undergoing a number of changes, is still production quality. I am using it on a very active live site... Essentially the biggest risk is that the _new_ API introduced during

Re: [JIRA] Created: (CAY-925) Support Entity/Table scope caching

2007-11-28 Thread Andrus Adamchik
: // For most of the queries QueryMetadata.LOCAL_CACHE // For cached lookup data QueryMetadata.SHARED_CACHE regards Malcolm Edgar On Nov 28, 2007 8:47 PM, Andrus Adamchik [EMAIL PROTECTED] wrote: Malcolm, Cayenne already supports this via query caching. Check SelectQuery.setCachePolicy

Re: Replace Objects in a Database?

2007-11-29 Thread Andrus Adamchik
In the nearest future we'll be adding a merge method to the DataContext that would do exactly what you described here - reattach an already persistent and possibly modified object to the context. For now the closest analog is localObject, but it will require some hacking. A reattach method

Re: ExtendedType and IN operator

2007-11-30 Thread Andrus Adamchik
, true)); return context.performQuery(orderQuery); } On Nov 26, 2007 7:42 AM, Andrus Adamchik [EMAIL PROTECTED] wrote: Chris, I vaguely remember this being a problem in the past and us fixing it... I couldn't find any references via Google (having IN as a keyword doesn't

Re: jpa provider

2007-12-07 Thread Andrus Adamchik
You will need to start your code with an instrumentation agent: http://cayenne.apache.org/doc/jpa-agent.html Andrus On Dec 7, 2007, at 10:00 PM, Gilberto C Andrade wrote: After put those dependences: dependency groupIdasm/groupId artifactIdasm/artifactId

Re: jpa provider

2007-12-07 Thread Andrus Adamchik
wrote: Andrus Adamchik wrote: Rather a dependency of the aggregate cayenne-server module (the one you should be using in your app), and this is exactly what I fixed earlier today: http://svn.apache.org/viewvc?view=revrevision=602126 Ok, I'm using it! Other thing, do you recommends

Re: jpa provider

2007-12-11 Thread Andrus Adamchik
Are you seeing this line in the logs prior to the unit tests? *** CayenneAgent starting... This should indicate that the agent is started. If not, check that both forkMode and argLine match what I posted, of course with $ {version} replaced with the actual Cayenne version. Andrus On

Re: jpa provider

2007-12-11 Thread Andrus Adamchik
On Dec 11, 2007, at 7:07 PM, Gilberto C Andrade wrote: Other thing, I've setup toplink and openjpa, the test works! Out of ideas... Would it be possible to open a bug report in Jira attaching an entity class in question (and any other JPA artifacts you might have - persistence.xml,

Re: Suggestion: Don't Fault Relationship On Add

2007-12-11 Thread Andrus Adamchik
Yep, that's the manual API for people who really know what their are doing with their object graph :-) Andrus On Dec 11, 2007, at 10:24 PM, Peter Karich wrote: Hi Daniel, it seems to me that CayenneDataObject.addToManyTarget(String targetName, DataObject obj, boolean reverse); and

Re: Suggestion: Don't Fault Relationship On Add

2007-12-11 Thread Andrus Adamchik
We are doing the extra clever thing for to-many, avoiding tripping the list on add. We don't for to-one. Is that the case you are talking about? (Address - State is a bit confusing... wouldn't a State have many Addresses? It appears to be the other way around in your example) Anyways, I

Re: Register object in multiple dataMaps environment

2007-12-17 Thread Andrus Adamchik
Hi there, Per you second message, this is more of a multiple cayenne.xml environment... So is the intention to access multiple DataMaps via a single DataContext? If so you the simplest thing would be to combine all mappings in a single project with one cayenne.xml. If this is not an

Re: jpa provider

2007-12-17 Thread Andrus Adamchik
hoping that the holidays will be a good quiet time to work on some of that, but you never know... Andrus On Dec 17, 2007, at 3:32 PM, Gilberto C Andrade wrote: Andrus Adamchik wrote: No... Didn't have time to take a look yet. There's million of different things going on at the same time

[SOLVED] Re: jpa provider

2007-12-17 Thread Andrus Adamchik
Turned out we've been bitten by this in Cayenne This is a surefire Maven plugin bug that breaks the Cayenne agent. Once I added version 2.2 to the plugin declaration I was able to run the test successfully: groupIdorg.apache.maven.plugins/groupId

Re: [SOLVED] Re: jpa provider

2007-12-17 Thread Andrus Adamchik
: useSystemClassLoadertrue/useSystemClassLoader After that I was able to run your original unit test under JUnit 4 and Surefire 2.3. Andrus On Dec 17, 2007, at 11:09 PM, Andrus Adamchik wrote: Although ... I am not so sure that it was all that successful, as the message is There are no tests

Re: Help with ROP and Cayenne 3.0M2 on Glassfish

2007-12-18 Thread Andrus Adamchik
Hi Adam, 3.0M2 ROP works just fine. However you'll need Hessian 3.0.20. Could you try to upgrade Hessian and deploy 3.0M2 on both client and server. And then let's see if you have any errors in such setup. Thanks Andrus On Dec 17, 2007, at 5:10 AM, Adam Yocum wrote: I am deploying

Re: jpa provider

2007-12-18 Thread Andrus Adamchik
Hi Gilberto, The test case that you sent before did not have any annotations on Produto class, so I can't say what's wrong... So I need to get more info. Also I suggest to switch to Jira and/or the dev list for this discussion, as JPA testing discussion can get boring quickly for the

Re: Setting Default Values for Entities

2007-12-22 Thread Andrus Adamchik
Syncing DB defaults with entities is indeed a painful exercise as JDBC provides no callback mechanism to let the app know which defaults were set. Here is one more brute force mechanism to achieve that - invalidate all newly inserted objects. E.g., using 3.0 API: List newObjects =

Re: Setting Default Values for Entities

2007-12-23 Thread Andrus Adamchik
On Dec 23, 2007, at 6:05 AM, Aristedes Maniatis wrote: Since the method for setting defaults in the db is the same accross the database depending only on field type I can put together something like the following to initialize objects following our rules... still it does not work ROP

Re: Changing relationships using only PK

2008-01-07 Thread Andrus Adamchik
Hi Dan, On Jan 7, 2008, at 3:06 PM, Daniel Kvasnička jr. wrote: Hi people, I would like to add an object to a M:N relationship. Cayenne generated those convenience methods starting with addTo. These take DataObject as a parameter and I noticed that it has to be a context-registered object --

Re: Selective commit

2008-01-07 Thread Andrus Adamchik
it's important. Thanks again! Andrus Adamchik escribió: Hi Álvaro, It is hard to give a precise advice on multithreading without knowing the nature of your application. So here is a few general notes: * DataContext instance is your isolated area for making in-memory changes to objects

Re: Several questions about Cayenne

2008-01-07 Thread Andrus Adamchik
Hi Andrey, On Jan 7, 2008, at 5:43 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: 1. I'm currently using two types of database - Oracle and Postgresql. I'm currently using reverse engineering because I already have a database full with data. And i have a lot of tables with PK and FK

Re: Re[2]: Several questions about Cayenne

2008-01-07 Thread Andrus Adamchik
[Taking this thread back to the list] On Jan 7, 2008, at 10:43 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello again, Andrus! Thanks for such quick answer! As for questions 1, 2 and 3 that's exactly what i needed. Although i have no plans to recompile Cayenne. In such cases i simply

Re: Selective commit

2008-01-08 Thread Andrus Adamchik
Could you also try it with 3.0M2? I wonder if there is a difference, before I start looking into that. Thanks Andrus On Jan 8, 2008, at 4:11 PM, Álvaro Martínez wrote: Of course, sorry, 2.0.4 Andrus Adamchik escribió: Could you confirm the exact version of Cayenne you are using

Re: Selective commit

2008-01-08 Thread Andrus Adamchik
... So I can't map data contexts to some particular condition. So then I have to create one data context per operation (that means a set of actions). Is this expensive? We are developing a heavy loaded cluster of servers, so it's important. Thanks again! Andrus Adamchik escribió: Hi

Re: Selective commit

2008-01-08 Thread Andrus Adamchik
(GenerateNewDistribution.java:162) java.util.TimerThread.mainLoop(Timer.java:512) java.util.TimerThread.run(Timer.java:462) Andrus Adamchik escribió: Could you also try it with 3.0M2? I wonder if there is a difference, before I start looking into that. Thanks Andrus On Jan 8, 2008, at 4:11 PM, Álvaro Martínez

Re: Selective commit

2008-01-08 Thread Andrus Adamchik
BTW, while I am investigating the bug with nested contexts ... do you have to use them at all? Can you just use multiple peer DataContexts instead? Andrus On Jan 8, 2008, at 5:39 PM, Andrus Adamchik wrote: Ok, let me look into it. Andrus On Jan 8, 2008, at 5:16 PM, Álvaro Martínez wrote

Re: Selective commit

2008-01-09 Thread Andrus Adamchik
); newContext.setValidatingObjectsOnCommit(true); return newContext; } With this one: public DataContext getNewContext() { return DataContext.createDataContext(true); } And everything is ok now. I didn't touch any other piece of code. Thank you very much! Andrus Adamchik escribió: BTW, while I am investigating

Re: Commit Exception Error

2008-01-09 Thread Andrus Adamchik
Hi Marco, I think what you need is a reconnect parameter in your MySQL URL. E.g.: jdbc:mysql://localhost/test?autoReconnect=true Andrus On Jan 8, 2008, at 8:02 PM, marco turchi wrote: Dear experts, I'm running a java software that gets some data from the DB, computes them and the

Re: Commit Exception Error

2008-01-10 Thread Andrus Adamchik
, 2008 3:17 PM, Andrus Adamchik [EMAIL PROTECTED] wrote: Hi Marco, I think what you need is a reconnect parameter in your MySQL URL. E.g.: jdbc:mysql://localhost/test?autoReconnect=true Andrus On Jan 8, 2008, at 8:02 PM, marco turchi wrote: Dear experts, I'm running a java software

Re: Commit Exception Error

2008-01-10 Thread Andrus Adamchik
10, 2008 10:51 AM, Andrus Adamchik [EMAIL PROTECTED] wrote: On Jan 10, 2008, at 12:33 PM, marco turchi wrote: DataSource load failed - Can not load JDBC driver named 'com.mysql.jdbc.Driver ?autoReconnect=true': com.mysql.jdbc.Driver?autoReconnect=true But this is what generates an error

Re: Commit Exception Error

2008-01-11 Thread Andrus Adamchik
going to try... Marco On Jan 11, 2008 9:39 AM, Andrus Adamchik [EMAIL PROTECTED] wrote: This is still a connection timeout issue. I dug up some of my own production configurations developed to address a similar issue. Here is another URL parameter you may try - connectTimeout. E.g

Re: Commit Exception Error

2008-01-11 Thread Andrus Adamchik
;@1551f60 I do not know what it is... sorry aout that thanks Marco On Jan 10, 2008 12:50 PM, marco turchi [EMAIL PROTECTED] wrote: sorry about that... :-) Thanks Marco On Jan 10, 2008 12:47 PM, Andrus Adamchik [EMAIL PROTECTED] wrote: Ah cool. I thought I was going crazy :-) Andrus

Re: Commit Exception Error

2008-01-13 Thread Andrus Adamchik
, Andrus Adamchik [EMAIL PROTECTED] wrote: At this point it is hard to recommend anything specific with no access to your environment... Now that the client side is setup to handle connection timeouts, you may have to start digging on the server side, tweaking appropriate MySQL options (e.g

Re: CayenneRuntimeException: Can't find id

2008-01-15 Thread Andrus Adamchik
) at java.lang.Thread.run(Thread.java:619) On Jan 15, 2008 11:38 AM, Andrus Adamchik [EMAIL PROTECTED] wrote: Hi Dan, Not even sure at this point that this is an issue of int vs. long... I wonder how the *new* object even appears in the paginated list that was created *before* the new object? Or did I

Re: CayenneRuntimeException: Can't find id

2008-01-15 Thread Andrus Adamchik
, Andrus Adamchik wrote: Hi Dan, Your diagnostics is correct... I just tested your case on MySQL with PK defined as BIGINT, and got the exact same error. As a temporary fix I suggest mapping your PK column as INTEGER in the Modeler without changing the DB (I *think* that should work... unless

Re: CayenneRuntimeException: Can't find id

2008-01-16 Thread Andrus Adamchik
an object at the end of the existing list... Andrus On Jan 16, 2008, at 1:54 PM, Daniel Kvasnička jr. wrote: On Jan 16, 2008 10:59 AM, Andrus Adamchik [EMAIL PROTECTED] wrote: On Jan 16, 2008, at 11:51 AM, Daniel Kvasnička jr. wrote: What troubles me now is that paginated query still

Re: CayenneRuntimeException: Can't find id

2008-01-19 Thread Andrus Adamchik
When I remove setPageSize, caching works, so it's paradoxically better than with paging. With paging, on every page cayenne retrieves full table + records relevant for the page. Yes, the cache settings are skipped for paginated queries for various technical reasons (except for the ROP

Re: Interoperability with ExtJS

2008-01-20 Thread Andrus Adamchik
I wanted to implement this kind of technology for some time. Unfortunately given all other things we are working on, I didn't get too far in actually doing it. My first idea was to provide a JS client for Cayenne ROP, but then we'd have to code ObjectContext implementation for the client

Re: DataRow.createObjectId deprecated without mention of alternative...

2008-01-23 Thread Andrus Adamchik
No replacement API in Cayenne. This was not deemed a useful user-level functionality, and Cayenne itself uses a private method elsewhere to create ObjectId's, hence the deprecation. Andrus On Jan 23, 2008, at 3:26 AM, Lachlan Deck wrote: Hi there, now that DataRow.createObjectId is

Re: Problems running Cayenne ORM Tier and CWS Client Tier on the same JVM.

2008-01-25 Thread Andrus Adamchik
something like that too? E.g. initialize DefaultConfiguration instance and store it in a ServletContext (if that's applicable for your environment) Andrus On Jan 25, 2008, at 2:09 PM, Andrus Adamchik wrote: Hi Andrey, the most efficient way to use LocalConnection

Re: DataRow.createObjectId deprecated without mention of alternative...

2008-01-25 Thread Andrus Adamchik
On Jan 24, 2008, at 6:57 AM, Lachlan Deck wrote: On 23/01/2008, at 9:12 PM, Andrus Adamchik wrote: No replacement API in Cayenne. This was not deemed a useful user- level functionality, It was useful to me ;-) e.g., ObjectId rowId = dataRow.createObjectId(anObjEntity); Map ids

Re: Problems running Cayenne ORM Tier and CWS Client Tier on the same JVM.

2008-01-25 Thread Andrus Adamchik
Hi Andrey, the most efficient way to use LocalConnection is with LocalConnection.NO_SERIALIZATION, and this is certainly the way to go if you are to instantiate the ROP stack in the same JVM as the server. So regarding the exception - what are the server and client classes mapped for the

Re: Problems running Cayenne ORM Tier and CWS Client Tier on the same JVM.

2008-01-25 Thread Andrus Adamchik
On Jan 24, 2008, at 9:38 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: So i want to 'use this reuse'. Right now you can reuse the *model*, not the java classes (except via LocalConnection, as you've already figured out)... Class reuse is definitely the goal, but we are notb there

Re: Re[2]: Problems running Cayenne ORM Tier and CWS Client Tier on the same JVM.

2008-01-26 Thread Andrus Adamchik
On Jan 26, 2008, at 11:01 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: What i understood from chapter 'Running Client Without CWS' at the http://cayenne.apache.org/doc/remote-object-persistence-coding-client.html page is that i can use data from the same library of my ObjEntity

Re: Problem concerning Prefetching

2008-01-28 Thread Andrus Adamchik
On Jan 28, 2008, at 3:31 PM, Jean-Paul Le Fèvre wrote: then ~4 queries : SELECT DISTINCT t0.* FROM galaxies t0, galaxy_component_properties t1 WHERE t0.id = t1.galaxy_id AND (t1.id = n) Yes, this is not normal. How do you build the query? Andrus

Re: Problem with 3.0M3 (Null pointer)

2008-02-05 Thread Andrus Adamchik
On Feb 5, 2008, at 11:02 AM, Alexander Lamb (dev) wrote: Caused by: java.lang.NullPointerException at org .apache .cayenne .map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:265) at org .apache .cayenne

Re: Problem with 3.0M3 (Null pointer): More info

2008-02-05 Thread Andrus Adamchik
and M3 ? In other words, can I continue to work with M3 modeler whatever version M2 or M3 of Cayenne I am using? Thanks, Alex Le 5 févr. 08 à 10:13, Andrus Adamchik a écrit : On Feb 5, 2008, at 11:02 AM, Alexander Lamb (dev) wrote: Caused by: java.lang.NullPointerException at org

Re: Problem with 3.0M3 (Null pointer): More info

2008-02-05 Thread Andrus Adamchik
DBEntities and instead use class inheritance on the object entities side :-) I ought to be able to do that without changing the code, only the model ? Alex Le 5 févr. 08 à 12:35, Andrus Adamchik a écrit : Aha... That must be it: https://issues.apache.org/cayenne/browse/CAY-921 Andrus

Re: Remove SQL logging in M2 or M3

2008-02-05 Thread Andrus Adamchik
As a background to what Kevin just said, Cayenne itself no longer attempts to configure Log4J (something it did prior to 3.0). Log4J is optional and is expected to be configured by the user. http://cayenne.apache.org/doc/guide-to-30-features.html (search for logging on this page).

Re: Remove SQL logging in M2 or M3

2008-02-06 Thread Andrus Adamchik
pool: jdbc:mysql://localhost/roles_new Driver class: com.mysql.jdbc.Driver Min. connections in the pool: 1 Max. connections in the pool: 20 Followed by the second model loading and then all the SQL logging... What did I do wrong? Alex Le 5 févr. 08 à 18:07, Andrus

Re: Specifying connection URL at runtime?

2008-02-12 Thread Andrus Adamchik
On Feb 12, 2008, at 7:30 PM, Colin Bankier wrote: (1) I have subclassed DefaultConfiguration and DriverDataSourceFactory, and overridden DefaultConfiguration's getDataSourceFactory to return my DriverDataSourceFactory subclass, and DriverDataSourceFactory's getDataSource to return a new

Re: questions

2008-02-13 Thread Andrus Adamchik
On Feb 13, 2008, at 3:31 PM, Kevin Menard wrote: I've been trying to get the channel going, but most people prefer the email list. There is a reason for that. All of us are volunteers, none of us work for the same company and many are in different time zones. The only way to get an

Re: Imports

2008-02-18 Thread Andrus Adamchik
Just use your own transactions, then 'commitChanges' turns into 'flush': http://cayenne.apache.org/doc/understanding-transactions.html Andrus On Feb 18, 2008, at 7:49 AM, Malcolm Edgar wrote: Hi Ari, thanks for the response. This would be a very good 3.0 feature if it is not already

Re: Specifying PK when creating a new object in DB generated PK mode

2008-02-20 Thread Andrus Adamchik
Cayenne should not disregard user-made decisions: it isn't Cayenne's responsibility to enforce PK integrity. It will not disregard the user decisions. If I understood correctly what you are trying to do, my recommendation would be this: MyObject object =

Re: How to migrate from Hibernate to Cayenne?

2008-02-20 Thread Andrus Adamchik
AFAIK no such thing exists as of now. Not sure about others, but luckily I was spared from any such migrations. Would be nice if somebody with a real experience could document what they needed to do. My guess on the high level approach would be to start with reverse engineering the DB

Re: How to migrate from Hibernate to Cayenne?

2008-02-20 Thread Andrus Adamchik
If you have a regular generated structure in your data layer, you can hack up a Velocity cgen template to match what you have for the Hibernate project and run it either with the Modeler or better - with cgen Ant task. For some sample templates, check out src/dotemplates/v1_2 folder in

Re: how to get update/insert SQL without committing to db

2008-02-21 Thread Andrus Adamchik
Hi Tobias, Could you elaborate a bit on how are you going to use this SQL? SQL generated by Cayenne is in a PreparedStatement format, so it will not be usable for say manual execution from a SQL client. Andrus On Feb 21, 2008, at 2:55 PM, Tobias SCHOESSLER wrote: Hi, is there a way to

Re: Queries based on relationship size

2008-02-21 Thread Andrus Adamchik
EJBQL query with outer joins should help: 1. select c from Customer c JOIN c.orderHistory (inner join filters customers with Orders, so this is like a regular SelectQuery) 2. select c from Customer c LEFT JOIN c.orderHistory d WHERE d is null (outer join combined with the WHERE

Re: Queries based on relationship size

2008-02-21 Thread Andrus Adamchik
changes than I was hoping for. At least it'll give me an excuse to finally play with EJB QL. -- Kevin Menard Servprise International, Inc. Remote reboot power control for your network www.servprise.com +1 508.892.3823 x308 -Original Message- From: Andrus Adamchik [mailto

Re: Determining changes in a dataobject / modification diff

2008-02-22 Thread Andrus Adamchik
One more way of doing that, based on the internal Cayenne mechanism for tracking all object changes as instances of GraphDiff: http://cayenne.apache.org/doc20/api/cayenne/org/apache/cayenne/graph/GraphDiff.html There is no public API to access the diffs directly, but you can intercept

Re: Migrate from Hibernate3 to Cayenne :) ?

2008-02-23 Thread Andrus Adamchik
How similar is the Cayenne JPA annotation pack to the EJB3/ Hibernate3 ? JPA is a subset of EJB3 spec. So the annotations are EJB3. Our implementation of the JPA provider is still in alpha though. I would like to know if there's a trick to quickly migrate a Hibernate3 application to

Re: CayenneObjectManager - alternative API for using Apache Cayenne

2008-02-24 Thread Andrus Adamchik
Hi Ari, thanks for pointing to that dev discussion thread. I was going to do the same. In fact my own interest in this approach started as a result of David posting his first example: https://issues.apache.org/cayenne/browse/CAY-877 And I hope to reuse his work if possible (and at the

Re: Raising an exception in a callback

2008-02-26 Thread Andrus Adamchik
On Feb 26, 2008, at 11:45 AM, Alexander Lamb (dev) wrote: Hello List, I want to prevent a delete of an object if certain attributes have certain values (e.g. do not delete an invoice which has already been sent). I registered the callback in the Modeler. Works fine. I do my test in the

Re: ROP listener semantics

2008-02-26 Thread Andrus Adamchik
Per my other reply to a similar question, there are no callbacks or listeners on the client at all (and for that matter they do not work with nested contexts either - only the topmost parent context's object events will cause mapped callbacks to fire). While this is consistent, it is far

Re: Re[3]: ROP: validation and callbacks

2008-02-27 Thread Andrus Adamchik
Agreed, totally makes sense. Could you please open a feature request in Jira: http://issues.apache.org/cayenne/ Thanks, Andrus On Feb 27, 2008, at 7:27 PM, Razumovsky Andrey wrote: I've found the answer: it turns out that client 'ObjAttribute' descendant, 'ClientObjAttribute' needed

Re: Cayenne and Spring (a Hibernate inspired question)

2008-02-28 Thread Andrus Adamchik
3.0 EJBQLQuery should be able to handle that. Andrus On Feb 28, 2008, at 2:44 PM, Marcin Skladaniec wrote: Hi Short comment on the cayenne sorted queries, they work great but be aware of a limitation: (the query examples assume one to many relation Artist-Painting) SelectQuery query =

Re: Cayenne and Spring (a Hibernate inspired question)

2008-02-28 Thread Andrus Adamchik
, t2.id, t2.x FROM table1 AS t1 LEFT JOIN table2 AS t2 ON t2.id = t1.t2_fk ORDER BY t2.x would never return results from t1 that do not have a related t2 record. Of course it's been a while since SQL theory lectures :) Cheers, Marek Wawrzyczny On Thu, 28 Feb 2008 23:56:07 Andrus Adamchik wrote

Re: EJBQLQuery and LEFT JOIN FETCH

2008-03-01 Thread Andrus Adamchik
Hi David, FETCH joins is one of the few features of EJBQL that are not yet supported. Working on it... Now, the error is of course totally confusing (what actually happens is Cayenne trying to treat the fetch join as a regular join). I just committed a small change to this code to simply

Re: Expressions objects state

2008-03-01 Thread Andrus Adamchik
On Mar 1, 2008, at 11:55 AM, Razumovsky Andrey wrote: First is about expressions. Suppose i have two entities, A and B. A has pk 'aid' and fk (non-mandatory) 'bid'. B has pk 'bid'. I want to build two separate expressions for A like those (1) 'aid=1' and (2) 'bid=2'. Since 'aid' and 'bid'

Re: Expressions objects state

2008-03-01 Thread Andrus Adamchik
On Mar 1, 2008, at 1:27 PM, Andrus Adamchik wrote: I know i can do this using 'db:' prefix, but this is not a solution for me, because i'm using ROP and 'db:' do not work on client since DBEntities are not being sent through hessian. So how i can create such queries (note than i prefer

Re: Big list'o questions.....

2008-03-02 Thread Andrus Adamchik
On Mar 2, 2008, at 7:25 PM, Frits Jalvingh wrote: 1. When Cayenne accesses the database, are PreparedStatements used (and cached) within a single DataContext? That is: if code causes 100x the same SQL to be generated and executed (select xxx from yyy where id=?) is this prepare once,

Re: Big list'o questions.....

2008-03-02 Thread Andrus Adamchik
On Mar 2, 2008, at 9:11 PM, Andrus Adamchik wrote: 3. The documentation states that when you call rollbackChanges() a transaction the DataContext state is restored to the state it had before. Does it do this by using copies of the objects it has read or is the database re-queried? Rollback

Re: Big list'o questions.....

2008-03-02 Thread Andrus Adamchik
Hi Frits, On Mar 3, 2008, at 1:37 AM, Frits Jalvingh wrote: The later. This is not configurable in Cayenne. I strongly suspect that PreparedStatement caching is never a bottleneck in the case of update (and in any event, if we issue a set of different UPDATE queries for each entity, each

Re: SQLTemplate - multiple statements

2008-03-03 Thread Andrus Adamchik
No (although a SQLTemplate created in the API supports multiple sets of parameters that are applied to the same template). If you need multiple queries to appear as a single query (and run in the same transaction with default Cayenne transaction settings), you can use a QueryChain:

Re: Expression string

2008-03-03 Thread Andrus Adamchik
Two options: 1. SQLTemplate 2. Cayenne 3.0/EJBQL (with EJBQL is still sort of alpha, so for subqueries I'd suggest grabbing a nightly building following the link on the download page: http://cayenne.apache.org/download.html Andrus On Mar 3, 2008, at 11:19 PM, Eric Polino wrote: Alright,

Re: Expression string

2008-03-03 Thread Andrus Adamchik
On Mar 3, 2008, at 11:05 PM, Michael Gentry wrote: I could be mistaken here, but I don't believe that Expression.fromString() supports select Exactly. The closest thing it resembles is EJBQL syntax [1]. But that would require Cayenne 3.0 and a different type of query - EJBQLQuery.

Re: Expressions objects state

2008-03-04 Thread Andrus Adamchik
On Mar 4, 2008, at 6:36 PM, Razumovsky Andrey wrote: Hi Andrus, AA to find objects by FK you can match against a relationship target AA object ObjectId: AA AA ExpressionFactory.matchExp(relationshipName, new AA ObjectId(TargetEntity, pk, 2); AA Thanks, this is exactly what i need. However,

Re: Expressions objects state

2008-03-05 Thread Andrus Adamchik
On Mar 4, 2008, at 6:36 PM, Razumovsky Andrey wrote: By the way, i assume you're from Belarus? So i can email you directly in Russian?) Андрей, А ты в каких краях вообще обитаешь? Андрусь

Re: Expressions objects state

2008-03-05 Thread Andrus Adamchik
Sorry, this was not intended for the list. Treacherous Reply-To header :-) Andrus On Mar 5, 2008, at 10:45 AM, Andrus Adamchik wrote: On Mar 4, 2008, at 6:36 PM, Razumovsky Andrey wrote: By the way, i assume you're from Belarus? So i can email you directly in Russian?) Андрей, А ты в

Re: caching documentation

2008-03-05 Thread Andrus Adamchik
On Mar 4, 2008, at 1:26 AM, Marcin Skladaniec wrote: Hi The documentation on caching (http://cayenne.apache.org/doc/caching-and-fresh-data.html and http://cayenne.apache.org/doc/object-caching.html) isn't very comprehensive, Agreed. There are lots of new features related to caching in

Re: ClickIDE now support Cayenne and Spring Framework

2008-03-06 Thread Andrus Adamchik
Nice! I haven't evaluated it yet (which I will do soon), but I am very much in favor of the direction taken - integration of the existing Modeler with Eclipse (vs. writing a Cayenne plugin from scratch, as was attempted during 2006 Summer of Code IIRC). Thanks, Andrus On Mar 6, 2008, at

Re: From DataView location to DataView object?

2008-03-06 Thread Andrus Adamchik
Hi Mary-Anne, Sorry for not answering your question, but rather giving you a big picture on the state of DV technology. DataViews support has always suffered due to the lack of volunteers to develop it, and finally got dropped in Cayenne 3.0 [1]. DV in Cayenne 2.0 is documented here [2]

Re: Can I disable SELECT logging?

2008-03-06 Thread Andrus Adamchik
Or just filter logs with 'grep'. Andrus On Mar 7, 2008, at 12:36 AM, Aristedes Maniatis wrote: On 07/03/2008, at 8:10 AM, Scott Anderson wrote: Is there a way to tell Cayenne to log only INSERT, UPDATE, and DELETE operations? In the production database, we have triggers that record each

Re: Can I disable SELECT logging?

2008-03-07 Thread Andrus Adamchik
On Mar 7, 2008, at 7:38 PM, Scott Anderson wrote: How did I know someone was going to say that? :) -Original Message- From: Andrus Adamchik [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2008 2:52 AM To: user@cayenne.apache.org Subject: Re: Can I disable SELECT logging? Or just filter

Re: Imports

2008-03-09 Thread Andrus Adamchik
, Malcolm Edgar [EMAIL PROTECTED] wrote: Great! Thanks for that. regards Malcolm Edgar On Feb 19, 2008 11:18 AM, Andrus Adamchik [EMAIL PROTECTED] wrote: Just use your own transactions, then 'commitChanges' turns into 'flush': http://cayenne.apache.org/doc/understanding

Re: Imports

2008-03-09 Thread Andrus Adamchik
BTW, if there's no commit or rollback, and the transaction stays open indefinitely, this would result in quick connection pool exhaustion. So why would you do that? Andrus On Mar 9, 2008, at 7:19 PM, Andrus Adamchik wrote: This could be a DB artifact. E.g. with MySQL MyISAM tables. Which

Re: 3-tier architecture

2008-03-10 Thread Andrus Adamchik
Architecture-wise ROP is ideally suited for work over RMI (not sure how different Spring RMI compared to Java RMI?). It just that nobody cared to implement an appropriate service so far. Maybe worth poking around porting ROP to RMI (there may be issues, like CAY-979, but I am sure they can

Re: Wrong data type for source attribute of a relationship?

2008-03-10 Thread Andrus Adamchik
We stopped supporting FireBird some time back due to the lack of qualified volunteers, so I don't remember all the issues that we had with it. But still this seems weird... Just to doublecheck, what Java and DB type you entered for the object attribute and the corresponding column in the

Re: 3-tier architecture

2008-03-13 Thread Andrus Adamchik
On Mar 13, 2008, at 1:44 AM, Borut Bolčina wrote: How likely it is this service to be implemented by you or any active team member by the end of April? Very unlikely. Nobody yet claimed to have plans to do that. Wouldn't this feature push Cayenne more into enterprise league? It seems

Re: Using JPA orm.xml with Cayenne3M3

2008-03-14 Thread Andrus Adamchik
.jpax.usecases.HalloWorldMain.insert(Unknown Source) at oopex.cayenne3.jpax.usecases.HalloWorldMain.main(Unknown Source) Java Result: 1 If you like, I can provide you the sample. Regards, Frank Andrus Adamchik schrieb: Hi Frank, is the application started with cayenne-agent? Andrus

Re: Using JPA orm.xml with Cayenne3M3

2008-03-14 Thread Andrus Adamchik
.TypeCheckingEntityManager.persist(TypeCheckingEntityManager.java:150) at oopex.cayenne3.jpax.usecases.HalloWorldMain.insert(Unknown Source) at oopex.cayenne3.jpax.usecases.HalloWorldMain.main(Unknown Source) Andrus Adamchik schrieb: To ensure that the agent discovers all classes

Re: 3-tier architecture

2008-03-14 Thread Andrus Adamchik
On Mar 14, 2008, at 1:06 AM, Borut Bolčina wrote: Can you please write a tutorial on advanced usage of Cayenne? That would include patterns and best practices on how to implement and configure 3-tier architecture without the missing rmi client-server services. ROP docs are there... You

Re: Pb to cast Expression to ejbql string

2008-03-16 Thread Andrus Adamchik
Looks like a bug to me. Andrus On Mar 16, 2008, at 10:59 PM, Francois Eyl wrote: Hi all, I'm getting a strange behavior using expression and its toEJBQL method. I'm using this to create my where close from a given Expression. This works for me in many cases except for this sample :

Re: Cayenne 3.0M3 : select query with LIMIT and OFFSET clauses

2008-03-16 Thread Andrus Adamchik
MySQL, Postgresql or Apache-Derby as a DB backend. Thanks again. JFS 2008/3/16, Andrus Adamchik [EMAIL PROTECTED]: Specifying offset is not (yet) supported. Aside from SQLTemplate there are various ways to solve it depending on your requirements. So can you explain how do you know which

Re: Cayenne in j2ee - message beans

2008-03-17 Thread Andrus Adamchik
The simplest thing to do is to limit the scope of the thread DataContext to the 'onMessage' method. I.e. create a new context on entry, bind it to the current thread, and unbind it in the finally block... The performance impact is of course that you need to refetch everything related to

Re: Optional quoting for table and column names?

2008-03-17 Thread Andrus Adamchik
Some people tried quoting identifiers directly in the Modeler. Not sure whether this worked or not, but certainly worth a try. And yes, we need to fix the Jiras quoted :-/ Andrus On Mar 15, 2008, at 9:28 PM, Walter Haas wrote: Hello, I'm hit by CAY-289 and CAY-878 on a legacy, fixed domain

<    1   2   3   4   5   6   7   8   9   10   >