Re: Duplicate entry '4183884' for key 'PRIMARY'

2013-05-17 Thread Amedeo Mantica
I agree. I started working with WebObjects and databases in 2001 about and I know very little about databases. I used MyISAM and after a while was a mess. I moved then to OpenBase and everything fine. Later I moved to FrontBase that was become free and I totally love it. It is fully transactiona

Re: Duplicate entry '4183884' for key 'PRIMARY'

2013-05-17 Thread Kieran Kelleher
InnoDB is all or nothing . don't waste your time mixing InnoDB and MyISAM in transactions - makes the results even more confusing. Convert them all. evidently, InnoDB is faster nowadays anyway. innoDB can cache everything in memory. MyISAM IIRC only can cache PKs in memory and must alwa

Re: Duplicate entry '4183884' for key 'PRIMARY'

2013-05-17 Thread Mark Gowdy
Thanks Paul, it looks like you are correct. Two 'Kieran Kelleher' email stated: > There is also no row locking on EO_PK_TABLE with myisam, so you will get > primary key clashes and subsequent failed inserts if the db is sufficiently > contended. and > (1) Never use MyISAM - no transactional

Duplicate entry '4183884' for key 'PRIMARY'

2013-05-17 Thread Mark Gowdy
Hi, We have started getting more of these errors recently, now that the system is under more load. EvaluateExpression failed: primaryKeyForNewRowWithEntity(EOEntity entity){ return null; } Any advise would be appreciated, Thanks, Mark

Re: chainable key path Qualifier question.

2013-05-17 Thread James Cicenia
Ah! Missed that key little method. Thanks On May 17, 2013, at 11:04 AM, Jesse Tayler wrote: > > have you seen the method called dot() ? > > stuff like: > > (Article.AUTHOR.dot(User.POSTER_ID)) > > dot rocks the box. > > > > On May 17, 2013, at 11:50 AM, James Cicenia wrote: > >> I am t

Re: chainable key path Qualifier question.

2013-05-17 Thread Jesse Tayler
have you seen the method called dot() ? stuff like: (Article.AUTHOR.dot(User.POSTER_ID)) dot rocks the box. On May 17, 2013, at 11:50 AM, James Cicenia wrote: > I am trying to get handy with ERXKey. > > However, how does one go across relationships? > > Say I want to find all order items

chainable key path Qualifier question.

2013-05-17 Thread James Cicenia
I am trying to get handy with ERXKey. However, how does one go across relationships? Say I want to find all order items for a store: It doesn't know to traverse ORDER_ERXKEY to the STORE_ERXKEY OrderItems.ORDER_ERXKEY.STORE_ERXKEY.eq(store); How does one properly construct this query? Thanks