Re: Web Performance

2011-08-18 Thread John Armstrong
How about 'throwing a hundred million dollars++ at engineering can do wonders.' You could throw that at COBOL and probably get an insane featureset. Anyone who uses facebook as an example and is not currently employing 1000+ hard core developers in pursuit of a singular goal is being somewhat of a

Re: Cayenne pattern quesiton

2010-03-30 Thread John Armstrong
My latest project has a lot of DAO going on and while it made sense (for some reason, habit?) at first I regret going that way and will, over time, be migrating into the same pattern that Michael highlights. Its really just a big useless layer for all the reasons he highlights, at least in my conte

Re: Cayenne Modeler - Local DataSources

2010-03-29 Thread John Armstrong
I see this as well. I also saw this behavior in some of the early M-series and think it had to do with preference corruption or old vs new style prefs? John- On Mon, Mar 29, 2010 at 9:42 AM, Joe Baldwin wrote: > More info: > > Cayenne Version: cayenne-3.0RC2 > OS: OSX > CM: OSX > > I just did a

Re: AUTO_PK_SUPPORT, mysql and join tables

2010-03-28 Thread John Armstrong
a bug, albeit a minor one, not affecting the > app correctness. I will open a bug report. > > Andrus > > > > On Mar 28, 2010, at 6:56 PM, John Armstrong wrote: > > Hi Andrus, >> I downgraded to 3.0M6 from RC2 a few weeks ago to troubleshoot some >> problems. I tes

Re: AUTO_PK_SUPPORT, mysql and join tables

2010-03-28 Thread John Armstrong
Mar 28, 2010, at 9:43 AM, John Armstrong wrote: > > Hi all, >> I am using mysql with all database generated pks and auto_increment. >> >> This works fine for all tables except join tables. When accessing a join >> table cayenne tries to access the AUTO_PK_TABLE rathe

AUTO_PK_SUPPORT, mysql and join tables

2010-03-27 Thread John Armstrong
Hi all, I am using mysql with all database generated pks and auto_increment. This works fine for all tables except join tables. When accessing a join table cayenne tries to access the AUTO_PK_TABLE rather then relying on the auto_increment. My join tables are configured identically :

Re: Cayenne and GWT

2010-03-09 Thread John Armstrong
asses are generared in client folder of your project (e.g. > > foo.bar.client package) > > 2. your foo.bar.FooBar.gwt.xml includes this line; > > > > > > Of course this project is startup and never used in production, so > anything > > can not work. > > >

Re: Cayenne and GWT

2010-03-07 Thread John Armstrong
th that (or separate > open-source project). Does anyone find this interesting?? > > 2010/1/28 John Armstrong > > > The way I am handling 'what gets mapped' is with a BeanFactory class > > that uses Dozer to do basic mapping on a per CDO/Bean basis. BeanUtils > >

Re: Cayenne code generation - pointers requested

2010-01-28 Thread John Armstrong
WT. For now we can do the task of converting the objects to POJOs, this > must be quite easy. Still I'm not sure, how you're going to decide what part > of Cayenne object graph is to be sent on client (this is what I use XML > descriptions BTW) > > 2010/1/28 John Armstrong

Re: Cayenne code generation - pointers requested

2010-01-28 Thread John Armstrong
criptions (which look much like json-taglib, but are > standalone) and use only JSON-based data on client side. > What do you think? > > 2010/1/28 John Armstrong > >> I'm finding myself generating a lot of Beans that mirror my cayenne >> entities (plus Dozer mappings) as

Re: Cayenne code generation - pointers requested

2010-01-28 Thread John Armstrong
mplates > located in the distribution under "src/dotemplates/v1_2". They also contain > comments on what variables can be included in the template, etc. > > Andrus > > > > On Jan 28, 2010, at 9:50 AM, John Armstrong wrote: >> >> I'm finding myself generating

Cayenne code generation - pointers requested

2010-01-27 Thread John Armstrong
I'm finding myself generating a lot of Beans that mirror my cayenne entities (plus Dozer mappings) as I delve into GWT. This is crying out for automation and I'm sure a few others would enjoy it. It may even make Cayenne very GWT Friendly. To move this ball forward (for me minimally) can anyone p

Re: [ANNOUNCEMENT] Success story

2009-11-24 Thread John Armstrong
Congratulations! I (and I am sure others) would love to read a blog post or a technical paper about how you scaled Cayenne, what in cayenne helped, what was difficult etc. I'm midway through a large project and already getting concerned about how to scale it.. John- On Tue, Nov 24, 2009 at 3:18

Query against flattened relationship w/attribute

2009-10-22 Thread John Armstrong
I have a flattened relationship in Cayenne and my table looks like this : +-+- | Field | Type +-+--- | CLIENT | int(11) // Foreign key to CLIENT table | CLIENTPRINTERID | varchar(1024) // String id assigned outside of app t

Re: Cayenne and H2 on the desktop

2009-10-20 Thread John Armstrong
I implemented a DataSourceFactory to obtain this same functionality. specifically around having a single executable JAR and derby not finding its schema creation file. The DSF lets the system auto-detect schema existence and use embedded ant to create it as required. Your mileage may vary John- O

Re: Cayenne and SqlLite, Cayenne 3.0 vs. 2.0

2009-10-16 Thread John Armstrong
I use Derby for this. Its embedded. Its java. It works exceptionally well. John- On Fri, Oct 16, 2009 at 2:09 PM, Eric Lazarus wrote: > Folks > > Are people building new systems on Cayenne 3.0 or 2.0, mostly? What is > recommended? (We have been deeply back versioned, successfully using 1.1 for

Re: Cayenne-3: Core JAR Files

2009-09-18 Thread John Armstrong
ou still have to add the right JAR file.  (You > have to specify server, client, etc.) > > > On Fri, Sep 18, 2009 at 10:26 AM, John Armstrong wrote: >> Or use Maven. Once you start using Maven its hard to go back. >> >> J >> >> On Fri, Sep 18, 2009 at

Re: Cayenne-3: Core JAR Files

2009-09-18 Thread John Armstrong
Or use Maven. Once you start using Maven its hard to go back. J On Fri, Sep 18, 2009 at 6:06 AM, Michael Gentry wrote: > We should probably have a README file in the lib directory that, at a > minimum, includes that link ... > > > On Fri, Sep 18, 2009 at 8:06 AM, Andrus Adamchik > wrote: >>> I

Re: Problem with Database Generated IDs and Firebird

2009-08-17 Thread John Armstrong
tively using firebird. > > I would expect that fixing the Firebird adaptor, especially when you > have the mysql adaptor as a reference, would be an entry-level > contribution. > > On Mon, Aug 17, 2009 at 1:50 AM, John Armstrong wrote: >> I am attempting to use database generated

Problem with Database Generated IDs and Firebird

2009-08-16 Thread John Armstrong
I am attempting to use database generated IDs with Cayenne 3.0M5 and Firebird. Even though isGenerated="true" on the proper column it still queries the AUTO_PK_SUPPORT table. Even more problematic is that the SQL generated seems invalid: === updated 1 row. INSERT INTO CLIENT (ACTIVECLIENT, CLIENT

Re: Different DataContext

2009-07-22 Thread John Armstrong
Rather then pull the context from the object I always pull from the thread I am executing within: public static ObjectContext getCayenneContext() { try { ObjectContext context = DataContext.getThreadObjectContext(); return co

Re: CayenneModeler Drop-Down-Menu Items Disappear on OSX 10.5.7

2009-07-06 Thread John Armstrong
Unrelated but I have noticed in M6 on OS X it generates empty classes when I reverse engineer a database. When I go back to M5 it works as expected. Working on getting a reproducible test case. John- 2009/7/6 Atli Páll Hafsteinsson : > Yes, this is happening for me to. Cant say if its because of

Re: Two minor modeler feature requests

2009-06-23 Thread John Armstrong
Thanks Andrus, that explains some of the problems I see with the modeler today, not remembering my classpath, my last selected directory etc and is what sparked my request in the first place. John- On Tue, Jun 23, 2009 at 8:27 AM, Andrus Adamchik wrote: > > On Jun 23, 2009, at 5:08 PM

Re: Two minor modeler feature requests

2009-06-23 Thread John Armstrong
ding on the platform.  I've actually got > some code that already does that (different project), so maybe it > could be added.  The FileDialog also remembers the size of the open > window, the directory you were last in, etc.  Just like you'd expect > it to operate on a Mac

Two minor modeler feature requests

2009-06-23 Thread John Armstrong
Two items for the Modeler: 1) Is there a reason it set to use a FileBrowser rather the the FileDialog which is more powerful and 'user friendly' on Mac/Win? 2) Whichever we use should default to the users homedir. I can knock these changes out but before I did I wanted to see if there was a spec

Ordering of relationship retrievals

2009-05-09 Thread John Armstrong
Hi all, I have a simple relationships, template -> configuration_options, that I access as follows: theTemplate.getConfigurationDefArray() I'd like to be able to specify the order by for this retrieval in SQL rather then sorting each item in the retrieved list. Any tips much appreciated! Other

Re: Reengineering Overwrites

2009-04-09 Thread John Armstrong
hat I make in Modeler and merge in any database changes > (such as new tables, new columns, altered column definitions, deleted > columns) to the map. > > Unfortunately, these kinds of operations are not uncommon here and so > this would likely be a major issue for us. However, being a n

Re: Reengineering Overwrites

2009-04-08 Thread John Armstrong
Under to Tools menu in the modeler you can select the 'Migrate Database Schema' command. This will diff the db against your current current map. You can then, per change, decide if you want to take the DB version, the Cayenne version or ignore. Its the best feature ever, I use it daily. This may

Re: API wish(es)

2009-04-06 Thread John Armstrong
Andrey, you left me in suspense :) > BTW right here's a method which returns one object of query result Are you saying use ObjectIdQuery to get one result or is there another normal query that will do it? John- 2009/4/6 Andrey Razumovsky : > The correct way to get fresh object is similiar to th

Re: Internal row comparison in ExpressionFactory

2009-03-26 Thread John Armstrong
drey Razumovsky wrote: > Hi John, > > You should try EJBQL: > select t0 from License t0 where t0.claimedunits < t0.totalunits AND > > http://cayenne.apache.org/doc/ejbqlquery.html > > 2009/3/26 John Armstrong > >> Hi, I need to do a selection on a table parti

Internal row comparison in ExpressionFactory

2009-03-26 Thread John Armstrong
Hi, I need to do a selection on a table partially based on comparing two elements of that table. Basically a 'total' and a 'current' where total is a changing value and needs to be compared to current to see if the row is valid. Its a floating license system for an app I am building. This obviousl

Re: How to create Meaningful Primary Keys? JUST SAY NO TO MEANINGFUL POINTERS!

2009-02-02 Thread John Armstrong
I made this mistake once. We spent a LOT of money getting rid of them and in our case using a meaningful primary key actually stalled our business for the few months it took to get rid of them. Don't Do It! J On Mon, Feb 2, 2009 at 6:22 AM, Pierre Lavignotte < pierre.lavigno...@gmail.com> wrote:

Re: A little help w/ session state please

2009-01-07 Thread John Armstrong
are missing the point and that looked promising. But it > looks like RefreshQuery is a 3.0 bean and not available in 2.0.4. > > -Chad > > ----- Original Message - > From: "John Armstrong" > To: user@cayenne.apache.org > Sent: Wednesday, January 7, 2009 8:

Re: A little help w/ session state please

2009-01-07 Thread John Armstrong
This I think may be more of a cayenne problem. You have to reload the object to destroy the cayenne cache using something like RefreshQuery. Thats what I have to do in many cases. Like this: context.deleteObject(theFeed); context.commitChanges(); context.commitChangesToParent(); context.performQu

Pre-persist not firing

2008-12-30 Thread John Armstrong
This is really basic but I am a bit sick and am just not finding my answer (thats my excuse, sick..) In my map I have this (generated via M5 Modeler): In my com.printgate.model.Company object I have this method: public void

Re: Hinting for datatype in Modeler?

2008-12-30 Thread John Armstrong
ore. > > On Dec 29, 2008, at 23:07, "John Armstrong" wrote: > >> Hi everyone, >> My database (Firebird) does not support boolean types. Cayenne helps >> me with this by letting me use a char(1) to emulate booleans. Thanks! >> >> The problem I h

Hinting for datatype in Modeler?

2008-12-29 Thread John Armstrong
Hi everyone, My database (Firebird) does not support boolean types. Cayenne helps me with this by letting me use a char(1) to emulate booleans. Thanks! The problem I have is that I am doing a lot of back and forth in my database design and I treat the database as authoritative rather then usin

pre-persist not firing

2008-12-29 Thread John Armstrong
This is really basic but I am a bit sick and am just not finding my answer (thats my excuse, sick..) In my map I have this (generated via M5 Modeler): In my com.printgate.model.Company object I have this method: public

Re: Teradata + Cayenne

2008-10-28 Thread John Armstrong
Wouldn't plain old JDBC work? I use JDBC adapter with Firebird in production and it seems to work pretty well. John- On Tue, Oct 28, 2008 at 9:14 AM, Michael Gentry <[EMAIL PROTECTED]> wrote: > Does Teradata use a database supported by Cayenne under-the-hoods (like > Oracle)? > > If not, you'll

Re: PK ID retrieval code generation seems to fail

2008-08-19 Thread John Armstrong
pe of the id attribute? > > Andrus > > > > On Aug 18, 2008, at 7:20 PM, John Armstrong wrote: > >> 3.0M4 on MacOS X (using the native tool). >> >> J >> >> On Mon, Aug 18, 2008 at 9:19 AM, Andrus Adamchik <[EMAIL PROTECTED]> >> wrote: >

RefreshQuery

2008-08-18 Thread John Armstrong
Hello all, Can someone point me to a source of info for RefreshQuery? The guide is pretty thin on it and I *think* it will solve my problem but can't get it to actually do what I think it should do :) Entirely user error on my side. Scenario: I have an object that is updated via stored procedur

Re: PK ID retrieval code generation seems to fail

2008-08-18 Thread John Armstrong
3.0M4 on MacOS X (using the native tool). J On Mon, Aug 18, 2008 at 9:19 AM, Andrus Adamchik <[EMAIL PROTECTED]> wrote: > Which version of Cayenne is this? I vaguely recall a bug that we fixed > already... > > Andrus > > > On Aug 18, 2008, at 7:16 PM, John Armstrong w

Re: PK ID retrieval code generation seems to fail

2008-08-18 Thread John Armstrong
s Maniatis <[EMAIL PROTECTED]> wrote: > > 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; >

PK ID retrieval code generation seems to fail

2008-08-17 Thread John Armstrong
Using M4 I map my PK field (id) to an object field as per the wiki here : http://cwiki.apache.org/CAY/mapping-primary-keys.html In my generated class these two functions are added: public void setId(int id) { writeProperty("id", id); } public $classGen.formatJavaType(${attr.Ty

Dynamic database attribute

2008-06-15 Thread John Armstrong
Hello Cayenne people, First off, thank god for Cayenne. Its made my life a lot better and Hibernate is but a nightmare now. Thanks. Ok so my issue. I have a stand-alone app. In this app it uses the ant api to create a derby database in the users home directory. Some snippets: I config ant as :

Re: Java Client

2007-06-26 Thread John Armstrong
I can only speak to my swing experience. I'm mid-way through building a Cayenne backed swing app and its been really smooth sailing. Not sure how to answer your questions more specifically around that, are you having troubles? John- On 6/26/07, Florijan Stamenkovic <[EMAIL PROTECTED]> wrote: Hi

Re: Creating Compound PKs

2007-06-04 Thread John Armstrong
answer my newbie questions. Just starting into Cayenne and am enjoying it greatly. Its reducing the development time on my app substantially. John- On 6/4/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote: On Jun 4, 2007, at 9:52 AM, John Armstrong wrote: > I can enforce it unique in the

Re: Creating Compound PKs

2007-06-03 Thread John Armstrong
columns in your table? Andrus On Jun 4, 2007, at 9:25 AM, John Armstrong wrote: > Yes, sorry misplaced that bit of important information. > > ImapServer > account > id > password > serverip > > Tx > John- > > > > On 6/3/07, Andrus Adamchik <[EMAIL PR

Re: Creating Compound PKs

2007-06-03 Thread John Armstrong
Yes, sorry misplaced that bit of important information. ImapServer account id password serverip Tx John- On 6/3/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote: Hi John, A question - is "serverid" a foreign key to another table by any chance? Andrus On Jun 4, 2007,

Creating Compound PKs

2007-06-03 Thread John Armstrong
Does Cayenne allow for the creation of a compound PK? I searched the archives and google more generally and could only find hints at this. The docs did not clarify either (although it was also hinted at. .I think, its a bit late :) ). My table looks like this: id name serverid status enabled I