Re: Queries against to-many relationships with 'NOT' subexpressions

2010-08-24 Thread Aristedes Maniatis
as expected - roles in 'Admin' group will be returned. This is because DB query with double-joined Group table selects record with self-joined 'Active' group name. So question is simple - is there any way to do such queries? Thanks, Victor. -- -- Aristedes Maniatis GPG

Re: Queries against to-many relationships with 'NOT' subexpressions

2010-08-24 Thread Aristedes Maniatis
On 25/08/10 12:57 AM, Victor Antonovich wrote: Hello! 24.08.2010 16:05, Aristedes Maniatis wrote: You need to create an outer join. http://cayenne.apache.org/doc/path-expressions.html Thanks for the response. AFAIR outer join can widen query results, but I need to narrow them excluding

Re: Entity Attribute Value model with Cayenne?

2010-08-23 Thread Aristedes Maniatis
Naturally you'd add to your Attribute table all sorts of validation definitions. You might want to restrict values to be numerical (but you are still storing them in the db as blob or string). Or restrict the entry length. Cheers Ari -- -- Aristedes Maniatis GPG fingerprint

Re: Cayenne 3.0 and DataViews/DVModeler

2010-08-21 Thread Aristedes Maniatis
with it. Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Testing for Pagination

2010-06-29 Thread Aristedes Maniatis
records have been completely retrieved and the others just the IDs. Records after the first 10 will have a status of hollow. Ari -- -- Aristedes Maniatis ish http://www.ish.com.au Level 1, 30 Wilson Street Newtown 2042 Australia phone +61 2 9550 5001 fax +61 2 9550 4001 GPG

Re: Testing for Pagination

2010-06-29 Thread Aristedes Maniatis
-- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Some doubts about DataContext and memory allocation

2010-06-06 Thread Aristedes Maniatis
'shared' context for displaying data. Developers from a WO background will be familiar with this approach. Cayenne doesn't have a special shared context, but you can use it that way if you like. Ari -- -- Aristedes Maniatis ish http://www.ish.com.au Level 1, 30 Wilson Street

Re: Blobs in the DataContext

2010-05-21 Thread Aristedes Maniatis
through to your import/export process. Cheers Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: How to integrate Cayenne with non persisting object

2010-05-21 Thread Aristedes Maniatis
mean that you are required to save it to the database. You can throw away the context or remove it from the context before committing. You code can do anything it like with that object in terms of validating it before you decide to commit. Ari -- -- Aristedes Maniatis GPG

Re: Cayenne Connection Pool Monitoring - to solve out of connections error

2010-05-12 Thread Aristedes Maniatis
YourKit to the running application: that also lets you get a thread dump at any time. And Andrus mentioned subclassing DriverDataSourceFactory earlier. Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Cayenne 'the book', Was: Cayenne 3.0 is released

2010-05-08 Thread Aristedes Maniatis
to create. Regards Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Cayenne 3.0 is released

2010-05-07 Thread Aristedes Maniatis
On 7/05/10 11:13 AM, gyhe wrote: By the way, what will be the major changes in the next version? Too early to say. But improvements to the configuration injection are well underway. Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A

Re: Cayenne 3.0 is released

2010-05-07 Thread Aristedes Maniatis
the mysterious open source users with a DVCS who each hold one part of the puzzle until finally he can piece together his identity... Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Tutorial Persistent Objects

2010-04-27 Thread Aristedes Maniatis
On 20/04/10 9:22 AM, timk519 wrote: On Mon, Apr 19, 2010 at 7:13 PM, Aristedes Maniatis [via Cayenne] ml-node+731010-1607425418-237...@n3.nabble.com wrote: On 20/04/10 2:04 AM, timk519 wrote: I was in the same boat - what's happened is the web page uses a SCRIPT type=syntaxhighlighter

Re: Fetching Specified Raw Rows with SelectQuery

2010-04-25 Thread Aristedes Maniatis
the list. I'm not sure if this also happens when you fetch raw rows, since I've never used that Cayenne functionality. Ari -- -- Aristedes Maniatis ish http://www.ish.com.au Level 1, 30 Wilson Street Newtown 2042 Australia phone +61 2 9550 5001 fax +61 2 9550 4001 GPG

Re: long table names

2010-02-18 Thread Aristedes Maniatis
of when that was done. i use sqlserver2005 and cayenne 3.01M1... You definitely want to run the latest release candidate and not an early milestone. Ari Maniatis -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Adding Unique Column to a Table

2010-02-12 Thread Aristedes Maniatis
. Ari Maniatis -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Using Postgresql's table inheritance or other advanced DDL

2010-02-09 Thread Aristedes Maniatis
with caches, etc Is there a reason you aren't using inheritance from Cayenne itself? For horizontal and single-table inheritance that works very nicely. Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Cayenne RC2 release

2010-02-05 Thread Aristedes Maniatis
of Cayenne 2.x and earlier are recommended to upgrade their development environments and perform testing to ensure your application can be upgraded smoothly. http://cayenne.apache.org/download.html Best regards from the Cayenne development team. -- Aristedes Maniatis

Re: String-with-number sort and insert order preservation

2010-02-02 Thread Aristedes Maniatis
-- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: MySQL case sensitive search

2010-02-01 Thread Aristedes Maniatis
-td14852.html ThanksNishant Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: MySQL case sensitive search

2010-02-01 Thread Aristedes Maniatis
On 1/02/10 7:30 PM, Aristedes Maniatis wrote: That task is just about optimising the use of indexes for searching case insensitive. Just use Cayenne's normal case insensitive flag on the query and it will work fine. Just not use any index. Just ignore me. I misread your question, sorry. Ari

Re: split expressions

2010-01-13 Thread Aristedes Maniatis
to carry the extra information about aliases. Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: split expressions

2010-01-13 Thread Aristedes Maniatis
created with matchAll with another expression with an overlapping path? Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: split expressions

2010-01-13 Thread Aristedes Maniatis
(|paintings.gallery.name, foo); Then you could even define an expression Expression e1 = Expression.fromString(|paintings.gallery.name = foo and |paintings.gallery.name = bar) Is this making some forward progress? Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C

Cayenne 3.0 RC1 released

2010-01-06 Thread Aristedes Maniatis
-- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Cayenne 3.0 RC1 released

2010-01-06 Thread Aristedes Maniatis
On 6/01/10 8:18 PM, Malcolm Edgar wrote: Great news guys, thanks for all the hard work. Will there be any publicity push or will this wait for 3.0 final? The final release Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49

Re: Cayenne 3.0 RC1 released

2010-01-06 Thread Aristedes Maniatis
://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=truepid=12310903status=1status=3status=4fixfor=-1version=-3sorter/field=issuekeysorter/order=DESC Ari Maniatis -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: notification of query

2009-12-29 Thread Aristedes Maniatis
is called even when a query is in the cache. tx Hans -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

[ANN] new committer: Evgeny Ryabitskiy

2009-12-10 Thread Aristedes Maniatis
on the banking industry. Right now Evgeny is working on improving Cayenne's ability to work with specific Oracle features. -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: [ANNOUNCEMENT] Success story

2009-11-24 Thread Aristedes Maniatis
-- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

New Committer: Olga

2009-11-20 Thread Aristedes Maniatis
The Cayenne team would like to congratulate Olga (Ольга Ткачева) on her appointment as a committer. As recognition for her ongoing contributions over the last year, this status allows Olga to make changes to the source control repository of Cayenne directly. Although Olga works under the

Re: Object Caching

2009-11-13 Thread Aristedes Maniatis
for that matter) is not the best way to batch process that many rows. Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Cayenne 3.0 beta 1 released

2009-11-09 Thread Aristedes Maniatis
team. -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: deleting tomany objects

2009-10-22 Thread Aristedes Maniatis
On 22/10/09 5:33 PM, Mark Fraser wrote: What is the delay with declaring 3.x stable? There is discussion about getting beta 1 out the door in a matter of days. Or a week. But very soon :-) Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA

Re: Cayenne and H2 on the desktop

2009-10-20 Thread Aristedes Maniatis
simpler (or faster). * whatever you do, you cannot have two database engines (standalone or embedded) using the same files on disk. I'd guess that holds true for any database in existence today. Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A

Re: Id problem when trying to make a component decoupling a module

2009-10-05 Thread Aristedes Maniatis
component mainly because it is the wrong approach for code like this. Ari Maniatis -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Model Refactor, move table from one Map to Another

2009-10-01 Thread Aristedes Maniatis
be fairly sure it will still work once you have edited it by hand. Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Prefetching has no effect

2009-09-28 Thread Aristedes Maniatis
structure built using a single query, maybe due to memory issues? Do you have paging switched on? What action in your code causes the second query to be executed? Are the objects it is fetching at that time hollow? Ari Maniatis -- -- Aristedes Maniatis GPG fingerprint CBFB

Re: Set a query logging level

2009-09-24 Thread Aristedes Maniatis
On 25/09/09 5:37 AM, Lawrence Gerstley wrote: Also, just an FYI: the Wiki link on the home page seems to be quite dead. I've been trying to fix it, but something in the Confluence exporter is just breaking it every time. Argh... Ari -- -- Aristedes Maniatis GPG

Re: Memory Management using Tomcat

2009-09-17 Thread Aristedes Maniatis
is small, medium, or large. What do you recommend? Joe -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Memory Management using Tomcat

2009-09-17 Thread Aristedes Maniatis
. Regards Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Using Cayenne Servlet Filter can bring the web application down

2009-09-15 Thread Aristedes Maniatis
in the JIRA? Cheers, Borut -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Sorting and Pagination in Many-to-Many relationship

2009-09-15 Thread Aristedes Maniatis
-and-fresh-data.html Ari Maniatis -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: [Modeler] DbEntity:Primery Key:PK Generation Strategy - Is there any option for natural primary key?

2009-09-10 Thread Aristedes Maniatis
indexing. Ari -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Using Join Table

2009-09-10 Thread Aristedes Maniatis
thing for you. That is normally done when the join table has no information you care about, but in this case 'subscriptions' is a table with other data you need to access. Ari Maniatis -- -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E

Re: [Modeler] DbEntity:Primery Key:PK Generation Strategy - Is there any option for natural primary key?

2009-09-09 Thread Aristedes Maniatis
don't need a PK generation strategy since, as the page you reference states, you just need to put data in the PK field before you commit the object. It is up to you to ensure that it is unique, deal with threading and collisions. Ari Maniatis -- Aristedes Maniatis GPG

Re: Simple Select Query

2009-08-25 Thread Aristedes Maniatis
that approach while you are learning Cayenne. Instead, just perform the query to return full objects. The whole point of Cayenne is so that you can stop worrying about columns and start thinking in terms of Java objects. Ari Maniatis -- Aristedes Maniatis GPG fingerprint CBFB

Re: Simple Select Query

2009-08-25 Thread Aristedes Maniatis
optimisation which precludes a lot of useful functionality. Ari Maniatis -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Cayenne POJO inheritance

2009-08-16 Thread Aristedes Maniatis
/browse/CAY-1090 -- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Online/Offline

2009-08-08 Thread Aristedes Maniatis
-- Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

Re: Cayenne POJO inheritance

2009-08-07 Thread Aristedes Maniatis
On 8/08/09 6:51 AM, Tore Halset wrote: Take a look at the examples: (the formatting of the code-examples look strange..) Hmmm... yes. This would be the Confluence upgrade. I'll see if I can fix that this weekend. Ari -- Aristedes Maniatis GPG fingerprint CBFB 84B4

Re: Simple callback question

2009-07-23 Thread Aristedes Maniatis
On 24/07/09 1:15 PM, Dave Lamy wrote: Should the preUpdate callback event get fired for both new and existing objects? The behavior I'm seeing (3.0M5) is that preUpdate is not getting called when saving my new object, but does get called when saving an existing object. prePersist is not the

Travel to ApacheCon US 2009

2009-07-22 Thread Aristedes Maniatis
The Travel Assistance Committee is taking in applications for those wanting to attend ApacheCon US 2009 (Oakland) which takes place between the 2nd and 6th November 2009. The Travel Assistance Committee is looking for people who would like to be able to attend ApacheCon US 2009 who may need some

Re: Database change detection?

2009-07-19 Thread Aristedes Maniatis
On 20/07/09 5:18 AM, Karen Harper wrote: I want to monitor for ADD, DELETE, and MODIFY events in a specific table in my database which will be driven by another application. I have not come up with a straightforward way to do this through searching the docs. Is there a way to set TRIGGERS in the

Re: update / modify data object

2009-07-17 Thread Aristedes Maniatis
On 18/07/09 5:37 AM, sridhar devatha wrote: Hi , I am using cayenne 2. I want to update an employee object. This object is related to employee table in the db. I generated this data object(along with it's super class) and table query using modeler. I am able to write insert, delete and select

Re: update / modify data object

2009-07-17 Thread Aristedes Maniatis
On 18/07/09 1:39 PM, sridhar devatha wrote: Thank you for the reply. sorry. ignore the line of code for local object. Assume employeeDBProto is the object to be saved. It has the modified data. Do I need to write the entire update query to update and populate the data from the proto object into

Re: Foreign key constraint problem.

2009-06-17 Thread Aristedes Maniatis
On 18/6/09 7:51 AM, Michael Shea wrote: It looks to me like Cayenne is attempting to insert the new row before deleting the old one; I notice that in DataNode.performQueries, the collection of queries contains 3 queries: An InsertBatchQuery, an UpdateBatchQuery and a DeleteBatchQuery. Looks like

Re: Cayenne logging

2009-06-13 Thread Aristedes Maniatis
On 14/6/09 12:58 AM, Joe Baldwin wrote: When Andrus said that he thought that log4j was an abandoned project, I became hesitant about relying on it as a stable component for the future.) I would certainly recommend log4j. It is easy to use and completely robust. It may not have been updated

Re: Cayenne logging

2009-06-11 Thread Aristedes Maniatis
On 12/6/09 12:13 AM, Jason Ward wrote: log4j.logger.org.objectstyle.cayenne = OFF log4j.logger.org.objectstyle.cayenne.access.QueryLogger = OFF log4j.logger.org.objectstyle.cayenne.conf = OFF log4j.logger.org.objectstyle.cayenne.util = OFF Note that the packaging changed from org.objectstyle

Cayenne 3.0M6 released

2009-05-29 Thread Aristedes Maniatis
Another release on the journey to Cayenne 3.0! This milestone adds a plethora of new features including quoting of identifiers (useful for db column names with spaces), nested contexts in ROP, and EJBQL/ SQLTemplate/ProcedureQuery queries now support the full range of configuration options

Re: 3.0 cache documentation

2009-05-07 Thread Aristedes Maniatis
On 04/05/2009, at 8:33 PM, Andrus Adamchik wrote: I tried to stay away from the implementation details and give a user perspective instead. If there is still a feeling that the docs are lacking in this area, please share your thoughts. I will try to address any reasonable suggestions.

Re: 3.0 cache documentation

2009-05-04 Thread Aristedes Maniatis
On 04/05/2009, at 8:33 PM, Andrus Adamchik wrote: I tried to stay away from the implementation details and give a user perspective instead. If there is still a feeling that the docs are lacking in this area, please share your thoughts. I will try to address any reasonable suggestions. I

Re: Remote Example

2009-04-28 Thread Aristedes Maniatis
On 26/04/2009, at 7:22 AM, Peter Karich wrote: finally I got the mavenized tutorial in the subversion working. So, again step by step: This is very helpful. If you have the time, perhaps you could create a Jira task with this content. Ideally attach the changes as a diff, but even if

Re: Cayenne 3.0.M5 fetch offset

2009-04-24 Thread Aristedes Maniatis
On 24/04/2009, at 7:00 PM, Marco Gattei wrote: Hi everyone, a newbie question Is fetchOffset supported on Sybase ? i did some test with cayennne 3 with SelectQuery and fetch offset and running code like this: SelectQuery query = new SelectQuery(MyClass.class,

Re: Can't get primary key from temporary id :(

2009-04-22 Thread Aristedes Maniatis
On 23/04/2009, at 12:53 AM, Joseph Schmidt wrote: Of course I demonstrated. The snippet in the parent just works with MySQL (with InnoDB of course). There's no need for a last_insert_id(), since the PK are autoincrement. Inside the same transaction, the consequent selects will simply pick

Re: Best Practices Question

2009-04-21 Thread Aristedes Maniatis
On 22/04/2009, at 6:40 AM, Ylan Segal wrote: In a web app where each session has a DataContext, do I need to worry about data caching in different DataContexts? I'd like to add just one further point. It is a common design pattern to create one read-only 'shared' context which is used to

Re: Slow Return on Paginated SelectQuery

2009-04-12 Thread Aristedes Maniatis
On 13/04/2009, at 10:42 AM, Paul Logasa Bogen II wrote: I have a table with ~683k entries in it. I have a maintenance task that requires me to hit every entry. Since I know the results are much too big to return all at once, I've set the page size to 50. However, Cayenne appears to be

Re: Reengineering Overwrites

2009-04-08 Thread Aristedes Maniatis
On 09/04/2009, at 1:18 PM, Weddle, Anthony wrote: We occasionally make database schema changes. We also modify some of the attributes of ObjEntity entries. It looks like a reverse engineering run would ignore any changes to ObjEntity entries. Is there any way to have changes merged?

Re: Can't get primary key from temporary id :(

2009-04-07 Thread Aristedes Maniatis
On 08/04/2009, at 8:26 AM, Joseph Schmidt wrote: Can't get primary key from temporary id while trying to access the 'id' of a newly created object entity A. I need this 'id' to write the value together with some other fields in some other object entity B inside the same

Re: Can't get primary key from temporary id :(

2009-04-07 Thread Aristedes Maniatis
On 08/04/2009, at 11:03 AM, Joseph Schmidt wrote: * write the record to database, fetch it back again and then you'll have the primary key Than this is not the same transaction :(. Correct. This is a limitation of how databases work, not Cayenne. You can't have a primary key until you

Re: What 3rd party jars are a must?

2009-04-01 Thread Aristedes Maniatis
On 02/04/2009, at 6:15 AM, Joseph Schmidt wrote: http://cayenne.apache.org/doc/jar-files-and-dependencies.html describes some of them but not all :(. What about?: asm-3.0.jar asm-commons-3.0.jar geronimo-jpa_3.0_spec-1.0.jar ? Are they required when using a pure cayenne server, i.e. no JPA?

Re: Conditional relationship mapping?

2009-03-31 Thread Aristedes Maniatis
On 29/03/2009, at 4:28 AM, Joseph Schmidt wrote: Is it possible for Cayenne(and the Modeler) to map conditional relationships? I have a table, e.g. tag that relates to too many other tables, but one row is always related only to one table. This is done by having instead of many

Re: Conditional relationship mapping?

2009-03-31 Thread Aristedes Maniatis
On 31/03/2009, at 10:26 PM, Joseph Schmidt wrote: This would sound cool to me too, but from the Cayenne documentation example, this approach seems to have the problem that Java has single inheritance :(. If there's only one such table than it would work (single inheritance). E.g. In the

Re: How to map/model files?

2009-03-21 Thread Aristedes Maniatis
On 22/03/2009, at 6:18 AM, Joseph Schmidt wrote: How to model/map files (with their content) e.g. in webapplications? What is the best practice? (1) To put their content as blob fully in the DB plus fields for properties, or (2) to put the metadata about files only in the DB and the content

Re: How to map/model files?

2009-03-21 Thread Aristedes Maniatis
On 22/03/2009, at 9:41 AM, Joseph Schmidt wrote: I mean that in the case of a file system based approach, where the metadata is in the database, the operations on files are not guarded by transactions, nor can they be process in the same Cayenne transaction like on the metadata of those

Re: Table with no sequence

2009-03-19 Thread Aristedes Maniatis
On 20/03/2009, at 10:07 AM, h...@welinux.cl wrote: Hi, We have a legacy table that have a meaningful primary key, many code depends on it and it's not possible to alter it. We are building new java applications that need to insert in it. We would like to cayenne it and not use any

Re: Object state after persist: consistent with JPA?

2009-03-12 Thread Aristedes Maniatis
On 13/03/2009, at 5:12 AM, Francisco Peredo wrote: As I stated before, I really think someone should build a Cayenne like API that used any JPA compliant as its internal storage engine, JPA is just too low level That doesn't really make sense because JPA is a description of an

Re: First time writer/Design ideas

2009-03-01 Thread Aristedes Maniatis
On 02/03/2009, at 5:38 AM, Dave Lamy wrote: What pitfalls/concerns would you voice regarding a completely programmatic Configuration/DataMap buildup? The plan is for the entire cayenne model, data nodes and all, to be built up in code during system init (hot model deploys are for

Re: Commits not visible across contexts in ROP

2009-02-12 Thread Aristedes Maniatis
On 13/02/2009, at 3:30 PM, Tarik Cherkovi wrote: Hi,I just had a strange behavior from ROP and maybe missing something basic. I have multiple clients connecting to the same server, and when one of them performs a commit, the changes are not visible to the other client(s). Is there a way

Re: Commits not visible across contexts in ROP

2009-02-12 Thread Aristedes Maniatis
On 13/02/2009, at 4:43 PM, Tarik Cherkovi wrote: How are people getting around it if at all?Building event propagation on the server would be great, but as you say, it's non trivial. So in the meantime, I would need to find another solution (other than rewriting my entire swing gui in

Re: blank characters in field names

2009-02-09 Thread Aristedes Maniatis
On 09/02/2009, at 9:12 PM, puschteblume wrote: Hello, this is my first experience with Cayenne. I started to try it with an existing FileMaker database. Generally it looks fine. But in the existing FileMaker database there are attributes from tables where the field names contains blanks.

Re: Encrypted Fields

2009-02-07 Thread Aristedes Maniatis
Except that credit cards are not a good example here. Speak to your gateway provider, but here in Australia they all let you run transactions against the same credit card *without storing the card number/expiry date/cvv*. Instead you store the previous transaction reference and you can use

Re: Encrypted Fields

2009-02-05 Thread Aristedes Maniatis
On 06/02/2009, at 9:36 AM, Joe Baldwin wrote: What design (or pattern) is best for fields that are to be encrypted? MySQL has quite a few simple functions that can be used to encrypt data. However, when using Cayenne to fetch the data I have not found a simple solution. I think the

Re: nested contexts

2009-01-13 Thread Aristedes Maniatis
On 13/01/2009, at 7:03 PM, Andrus Adamchik wrote: Another thing is that the http://cayenne.apache.org/doc/nested-datacontexts.html states that nested contexts are not available in ROP, is that still? Andrey has been working on the ROP version of nested contexts. I think it is (partially?)

Re: nested contexts

2009-01-13 Thread Aristedes Maniatis
On 13/01/2009, at 11:09 PM, Andrus Adamchik wrote: On Jan 13, 2009, at 1:26 PM, Aristedes Maniatis wrote: I think it is a bug, and relating objects should be allowed between parent/child contexts. Not so. Parent/child relationship determines the path of the select and commit

Re: Include modeler.bat back in the distribution?

2008-11-16 Thread Aristedes Maniatis
On 17/11/2008, at 3:04 AM, Andrus Adamchik wrote: We test things on Vista and see what we can do to make the exe work I notice that maven-japplication-plugin has been updated a few times in the last few months and our maven target doesn't specify a release version number. Has the problem

Re: Any other ROP examples?

2008-10-08 Thread Aristedes Maniatis
On 08/10/2008, at 9:26 PM, Demetrios Kyriakis wrote: I wanted to use DataViewes too because it looks much closer to what I need (from a Swing perspective), but it doesn't look to work with the ROP transport style (or maybe I don't get the big picture of how to make it work). Dataviews

Re: Any other ROP examples?

2008-10-07 Thread Aristedes Maniatis
On 08/10/2008, at 3:59 AM, Demetrios Kyriakis wrote: Are there any ROP based projects that could be used as example? I mean some non-trivial examples (not like those from the SVN) I have a non-trivial ROP client/server desktop application. But unfortunately the source is not available at

Re: Stack overflow with Derby adapter

2008-09-12 Thread Aristedes Maniatis
On 12/09/2008, at 5:50 PM, Øyvind Harboe wrote: I've got an obscure bug in our app that is caused by a stack overflow with Derby. The problem is that 'OR' is implemented recursively inside Derby, so when using ExpressionFactoyr.inExp() w/a *long* list, the stack overflows. Can this be

Re: Result Set Filters?

2008-09-03 Thread Aristedes Maniatis
On 04/09/2008, at 3:43 AM, Joe Baldwin wrote: Lets say that I might want to filter my result set by eliminating certain entries. What is the recommended (i.e. best practice) method of filtering the result set so that you can produce a Java List that is a subset of the original result

Re: Result Set Filters?

2008-09-03 Thread Aristedes Maniatis
On 04/09/2008, at 4:26 AM, Joe Baldwin wrote: do you know if result sets can be combined? They are simply Java Collections. Combine them as you would any regular list. Nothing special you need to do. Ari -- ish http://www.ish.com.au Level 1, 30 Wilson Street

Re: Handling of database NULL - default value column to modeler?

2008-08-27 Thread Aristedes Maniatis
On 28/08/2008, at 1:38 AM, Scott Anderson wrote: For something as cool and impressive as the DbGenerator is, I think it deserves a priority higher than someday :) Please remember that Cayenne is a volunteer project. If this feature is of great importance to you I encourage you to submit

Re: Handling of database NULL - default value column to modeler?

2008-08-20 Thread Aristedes Maniatis
On 21/08/2008, at 3:54 AM, Andrus Adamchik wrote: If we are to bring this to Cayenne as a feature, I am very much in favor of an generic solution with the ability to define arbitrary metadata in the model. It has been mentioned in this thread already that this is a very popular request,

Re: PK ID retrieval code generation seems to fail

2008-08-17 Thread Aristedes Maniatis
On 17/08/2008, at 7:38 PM, John Armstrong wrote: public $classGen.formatJavaType(${attr.Type}) getId() { Object value = readProperty(id); return (value != null) ? (Integer) value : 0; } The getId() doesn't compile as it looks like something is not interpolating cleanly

Re: hashing, best practices?

2008-08-07 Thread Aristedes Maniatis
On 08/08/2008, at 5:00 AM, Michael Gentry wrote: public void setPassword(String newPassword) { super.setPassword(sha1(newPassword)); } That's close to what we do too. Some small caveats: * think carefully about how you implement validation like 'password length is more than 4 characters'

Re: Commiting changes

2008-08-04 Thread Aristedes Maniatis
On 05/08/2008, at 11:58 AM, Ian Jamieson wrote: Is there a way to commit just a specific set of changes, without commiting all the changes in the context? Should I create separate DataContext instances if I want to do this? Yes, you should be creating separate contexts for this purpose.

Re: Update in cascade

2008-08-01 Thread Aristedes Maniatis
On 01/08/2008, at 8:12 PM, Francois Eyl wrote: Is there a way with Cayenne to do an update in cascade with relationships (something like the delete in cascade already implemented) ? Not 100% sure what you are wanting to achieve, but will lifecycle callbacks do what you need?

Re: MissingSessionException

2008-07-23 Thread Aristedes Maniatis
On 23/07/2008, at 9:58 AM, Andrey Razumovsky wrote: Part of me says that I've seen the same issue before, but I can't find it now. I'm using ROP, Tomcat, Postgresql 8. I get MissingSessionException [No session associated with request.] in two cases: 1. When I restart a server and continue

Re: estimating proper object cache size

2008-07-05 Thread Aristedes Maniatis
On 05/07/2008, at 11:51 AM, Andrus Adamchik wrote: Yes it won't. SelectQuery always refreshes objects in the cache, unless you call 'setRefreshingObjects(true)' (I am actually thinking of deprecating this method). Does that mean that this page [1] is incorrect when it says: The query

<    1   2   3   4   >