Re: How to disable Transactions in Cayenne

Hi Andrus, sorry, but for Informix it didn't help (last tested version 3.0.1) ... but for me it is OK, because I think tansactions should be standard and for addons on old applications all is ok if there is a workaround! - Juergen - 2011/12/9 Andrus Adamchik > Checking "Container-managed tran

Re: How to disable Transactions in Cayenne

Hi, we have the same problem ... we wrote our own Driver based on the original jdbc-Driver for our database ... The 2 needed Class definitions you can find below ... We actually run about 100 Installations with this Driver ... We also ran into some trouble with the join statements ... so we ha

Re: sorted to many relations

: > http://svn.apache.org/repos/asf/cayenne/main/trunk/docs/doc/src/main/resources/UPGRADE.txt > > Andrus > > > On Sep 30, 2010, at 5:16 PM, Juergen Saar wrote: > > > Fine .. > > > > Is there already a time frame for Version 3.1? > > > > > > 2

Re: sorted to many relations

is narrow enough to > not stir much controversy and we can probably apply it to 3.1 branch. > > At the same time don't see it going in 3.0.x, as it introduces a change in > the mapping file structure (though backwards-compatible). > > Andrus > > > On Sep 30, 201

sorted to many relations

Hi, with CAY-477 there was described an enhancement of the ObjRelation, so that an ordering can be configured. I hoped it would be part of Release 3.0.1, because after that I could kick my own workaround ... Are there any plans in which relaease this will be included? Thanx ... -Juergen-

Re: DB2 stored procedure

I have the same problem with Informix ... still using a SQLTemplate ... 2010/6/14 Kuhns, John > I am attempting to call a DB2 stored proc that returns a result set, so far > no luck. The procedure takes two input params, and the docs imply I'm doing > this correctly, but I must be missing someth

Re: Primary Key

Assign a value for the PK-Attribute[s] before commit ... that's the way we solved this problem for our old fashion meaningful keys You can do it in validateForInsert() ... 2010/6/5 Mike Kienenberger Define an ObjAttribute for your manual primary keys, and do not > specify automatic pk generatio

Re: OutOfMemory with large number of inserts

First try: use a new ObjectContext for each csv-File ... If this doesn't solve the memory-problem you should try to make a commit after let's say 200 inserts and then create a new ObjectContext ... 2010/5/24 Steve Wells > Hi All, > > I am importing from a lot of csv files (2200+) and each csv h

Re: JSON serialization

Years ago we implermented a serialization into xml ... if not only attributes, but also relations are serialized, you run into deep trouble ... we stopped this experiment ... 2010/5/20 Kuhns, John > I am looking for the best method of serializing/de-serializing > CayenneDataObjects as JSON. I've

Success Stories: dead link

http://www.objectvisualizer.com/

Re: Order By Expression

ession is probably more meaningful and complicated. > >>> > >>> However, it's unlikely to be supported on many database platforms, and > >>> those that do support it probably do so using different custom sql > >>> syntaxes. For instance, in ora

Re: Order By Expression

Don't know what you expect, but the statement is really strange ... I Know: SELECT * FROM artist where artist_name = 'Tom'; Or SELECT * FROM artist ORDER BY artist_name DESC; or did you mean: SELECT * FROM artist where artist_name like 'Tom%' ORDER BY artist_name DESC; I think you should know a

Solved with Cayenne3: Temporary ID hasn't been replaced on commit

mal or Integer depending on how object was obtained). > Could be something related. > > Andrus > > > > On Nov 25, 2009, at 10:32 AM, Juergen Saar wrote: > > I'm using Version 2.0.4 ... >> >> 2009/11/25 Andrus Adamchik >> >> Don't yet k

Re: Temporary ID hasn't been replaced on commit

Sorry, my fault ... it seems, I hat the wrong API-Docs selected 2009/12/10 Andrus Adamchik : > Hmm.. Where did you see it? It can't be in the Javadocs (as it's not in the > interface). I found one piece of old docs though:

Re: Temporary ID hasn't been replaced on commit

ecause of it's small footprint. 2009/12/10 Michael Gentry : > I haven't used it before, but I see a nextRow() method in > ResultIterator that may be what you are looking for. > > mrg > > > On Thu, Dec 10, 2009 at 4:21 AM, Juergen Saar wrote: >> Hi, >> >> t

Re: Temporary ID hasn't been replaced on commit

it becomes final. Timewise, I don't know, maybe a > couple of months? > > Andrus > > On Nov 25, 2009, at 3:47 PM, Juergen Saar wrote: > >> I'm in preparations for 3.0 ... but there was a lot of trouble this year, so >> I didn't get as far as I planned ..

Re: Temporary ID hasn't been replaced on commit

re were a few bug fixes > related to unstable data types in ObjectIds (e.g. the same ID can have a PK > mapping as a BigDecimal or Integer depending on how object was obtained). > Could be something related. > > Andrus > > > > On Nov 25, 2009, at 10:32 AM, Juergen

Re: Temporary ID hasn't been replaced on commit

I'm using Version 2.0.4 ... 2009/11/25 Andrus Adamchik > Don't yet know what might be causing it, but what version of Cayenne are > you using? > > Andrus > > > On Nov 25, 2009, at 9:49 AM, Juergen Saar wrote: > > Hi, >> >> we're using cayen

Temporary ID hasn't been replaced on commit

Hi, we're using cayenne for the web-interface of a 20 year old project with meaningful keys. We don't use tapestry. The keys are handled in the validateForSave(). In some cases after commit there is an Exception: "Temporary ID hasn't been replaced on commit" The values of the Dataobject are OK an

Re: When can cached objects be garbage-collected?

If they have to be in one transaction ... there is no way for garbage collection. I had the same problem some time ago and had to fight the OutOfMemoryException. The Container for the Objects and the transaction ist the DataContext. I splitted the Import into slices of about 10.000 Object. For ev

Re: The right way to populate meaningful keys

ne.apache.org/doc/to-dep-pk-checkbox.html > > > > I'm not sure if the To Dep PK will work that way, but it is > > worth a > > try. If you assign all the keys, though, it should > > work. > > > > > > On Thu, Jul 30, 2009 at 10:53 AM, Juergen Sa

Re: The right way to populate meaningful keys

to see if > Cayenne will auto-copy your meaningful PK for you. > > http://cayenne.apache.org/doc/to-dep-pk-checkbox.html > > I'm not sure if the To Dep PK will work that way, but it is worth a > try. If you assign all the keys, though, it should work. > > > On Thu

Re: The right way to populate meaningful keys

he keys to set/get them. If you > set a key on a new object before you commitChanges(), Cayenne will use > your key instead of trying to generate one. > > mrg > > > On Thu, Jul 30, 2009 at 1:24 AM, Juergen Saar wrote: > > Hi all, > > > > I'm using cayenn

The right way to populate meaningful keys

Hi all, I'm using cayenne within an old 4GL-Project with meaningful Primary Keys. Is there a 'best practice' to get this keys into the DataObject-Instance? Actually I've various trouble with this ... Any hint or code-sniplet would be helpful ... -Juergen-

Re: Refresh ObjectId for meaningful PK

dy been registered in context > with > another ObjectId. What CayenneRuntimeExeptions are you having and what is > your version of Cayenne? > > 2009/7/29 Juergen Saar > > > Hi, > > > > I'm working on an 20 year old project with meaningful primary keys. >

Refresh ObjectId for meaningful PK

Hi, I'm working on an 20 year old project with meaningful primary keys. Till now, we used cayenne only for reading but now we are working on the first 'real' Web-Components that handle Order-Data. So I have to create the primary key myself. In the Modeller I created ObjAttributes for the PK-Fie

Re: Sometimes no data from Relation to small tables

2009/5/29 Andrus Adamchik > > On May 29, 2009, at 12:07 PM, Juergen Saar wrote: > > The modeler says no dependent PK >> In all cases (actual 3) where this problem exists, the relation-target is >> a >> kind of enumeration. >> The relation points from nonPK-

Re: Sometimes no data from Relation to small tables

tionship mapped? Is this a PK to dependent PK? > > Andrus > > > > On May 28, 2009, at 5:16 PM, Juergen Saar wrote: > > Hi, >> >> there is strange behavior on 1:1 Relations where the target-table has only >> a >> small amount of data. >> In this ca

Sometimes no data from Relation to small tables

Hi, there is strange behavior on 1:1 Relations where the target-table has only a small amount of data. In this cases I can see in the logfile, that there is no select for data at all. I found a workaround ... I do an explizit select ... this works but the relation always brings hollow object perh

Re: Importing DataMaps

Never tried something like this but this problem may be caused by missing file-rights for this user 2009/3/30 Dave Lamy > Hey guys-- > > We have a number of different clients, each of which make use of a common > foundation of code. I want each client's codebase to have its own > cayenne.xml, b

Re: Relationships without FK constraints?

l (and fast) in simple > implementations (ex: JSP form assignments) but may still be a bit too > "fuzzy" for the larger scaleable projects. > > These are my current opinions. I am interested in how others look at it. > > Joe > > > > > On Mar 28, 2009

Re: Relationships without FK constraints?

There are 2 ways ... you can do it in database or in a framework like cayenne The framework way is best for being database independent The database way is best for databases being accessed on different way ... let's say java and .net ... in those constellations you otherwiese would have to do mul

Re: Table with no sequence

I also have such a project ... I think it's pretty easy doing such work with cayenne. We use the validateForInsert method for generating the PrimaryKey. We started development with cayenne 1.x ... since Version 2 there are more ways to solve this isssue but you know "newer touch ..." 2009/3/20

Re: Two tables with the same name in two different data model !

I created an alias, or for databases without this posibility a view, for the second table ... so the names are different, but in database the tables have identical names. Best regards ... - Juergen - 2008/12/18 Marc Gabriel-Willem > Dears, > > > > We are facing a very annoying problem regard

Re: Adding own ordering algorithm

The 'normal' way of ordering is done by database. In your special case there is problem in database-design, not in the ordering itself. There should be 3 columns in database to get a perfect ordering. The other way is ordering with the java classes for ordered maps, there you can write your own

Re: Relationships across databases

ecause for this there is the cayenne ObjectStore 2007/6/21, Øyvind Harboe <[EMAIL PROTECTED]>: On 6/21/07, Juergen Saar <[EMAIL PROTECTED]> wrote: W.r.t. foreign key references, my problem is that I don't know how to implement a get/set relationship methods in the CayenneDataObjec

Re: Relationships across databases

yvind Harboe <[EMAIL PROTECTED]>: On 6/21/07, Juergen Saar <[EMAIL PROTECTED]> wrote: > Cayenne is a Framework that brings one of the best ORM available > and it would be foolish to implement such a horrible scenarium. I don't know what you find "horrible" about this

Re: Relationships across databases

Cayenne is a Framework that brings one of the best ORM available and it would be foolish to implement such a horrible scenarium. I think this special problem has to be solved by YOU and not by the cayenne-team Sorry ... --- Juergen --- 2007/6/20, Øyvind Harboe <[EMAIL PROTECTED]>: In the link

Re: Non persistent attributes

The actual way for cayenne is the defintion of getter/setter pairs an so a non persistent attribute is born. So far so good, but it would be fine if I could see them in the modeler/map-definition. It would be very helpful for the project-informations within the project-team. We have the separati

Re: Non persistent attributes

Yes, it would be nice ... waiting for this since a long time ... 2007/3/16, syrinx <[EMAIL PROTECTED]>: I am looking for a way to declare non persistent attributes using the cayenne modeler? I know that I can add my own attributes manually in the subclasses generated by the modeler, but it wo

Re: Improvement ? code generation (templates)

I can't see why you don't implement your own template. I use my own template since starting my project, because I found it useful to have some additional getters and setters ... Some central functionality we have implemented in our DataObject-Class derived from CayenneDataObject. Perhaps this wo

Re: entities with calculated fields

I'm not really sure about your needs For solving such kind of problem, we created views in the database. As far as we could do performance tests it seems, that it is the fastest way and if you have several software-products working on the same database, all products can have a benefit of th

Re: How do I retrieve a record with two fields for PK

*** RTFM *** *objectForPK *(DataContext context, java.lang.Class dataObjectClass, java.util.Map pk) 2007/2/14, Frank <[EMAIL PROTECTED]>: Hello, I have this defined: DataContext context = DataContext.getThreadDataContext(); Bsypemp emp = null; emp = (Bsypemp) DataObjectUtils.objectForPK(cont

Re: OutOfMemoryErrors (solved)

This is a workaround, but not a solution ... -sorry- --- Juregen --- 2007/2/14, Frank <[EMAIL PROTECTED]>: Hi Andrus, I bumped the JVM up to 512m This resolved my issue. I also removed AS400 fields not needed in my query to help reduce memory requirements. Regards, Frank

Re: security

at you have done? Carl On 1/31/07, Juergen Saar <[EMAIL PROTECTED]> wrote: > > What I'm still missing are user-depended DataNodes ... > we have several installations with usergroups with different databases > > 2007/1/31, Carl Mosca <[EMAIL PROTECTED]>: > > >

Re: security

What I'm still missing are user-depended DataNodes ... we have several installations with usergroups with different databases 2007/1/31, Carl Mosca <[EMAIL PROTECTED]>: I am wondering about security (user, query, role level). What approaches have been taken by those using ROP for a some time?

Re: converting property-names to db-names

Just 1 more hint: getDataContext().getEntityResolver().lookupObjEntity(DataObject) brings back the ObjEntity for this DataObject. There you can find a list of all ObjAttributes and each ObjAttribute includes the information about the DbAttribute 2007/1/24, Peter Schröder <[EMAIL PROTECTED]>:

Re: converting property-names to db-names

getDataContext().getEntityResolver().lookupDbEntity(DataObject) brings back the DbEntity for this DataObject. There you should find all you need ... Good Luck --- Jürgen --- 2007/1/24, Peter Schröder <[EMAIL PROTECTED]>: hi, is there a cayenne method that gives me the db-name of a prope