Bruno, While I cannot comment specifically on Cayenne, most persistance frameworks issue a 'dummy' SQL command known to return extremely fast in order to test a connection. For Oracle, the DUAL table is most often used, usually in a SELECT * FROM DUAL context. Persistance frameworks that also include connection pools (like Cayenne) may issue these commands to ensure connections are still up and attempt to reconnect if they are not.
--Steve On Tue, May 3, 2011 at 9:15 AM, Bruno René Santos <brunor...@holos.pt>wrote: > Hello all, > > I have a table with 3 foreign keys that are also the composite primary key. > On cayenne modeler the primary key generation is Default but even so during > the commit phase Cayenne tries to call the following command: > > SELECT SCHEMA.pk_TABLENAME.nextval from DUAL > > which is a sequence that does not exist anywhere.... Why is it trying to > generate a sequence with a default generation behaviour? > > Thanx > Bruno > -- > Bruno René Santos | brunor...@holos.pt <mailto:brunor...@holos.pt> | > Gestor de Projectos | Analista | Programador | Investigador > > Holos - Soluções Avançadas em Tecnologias de Informação S.A. > Parque de Ciência e Tecnologia de Almada/Setúbal . Edifício Madan Parque > Rua dos Inventores . Quinta da Torre . 2825 - 182 Caparica . Portugal > Phone: +351 210 438 686 . Fax: +351 210 438 687 . Web: www.holos.pt > > > This email and any files transmitted with it are confidential and intended > solely for the use of the individual or entity to whom they are addressed. > If you are not the intended recipient or the person responsible for > delivering the email to the intended recipient, be advised that you have > received this email in error and that any use, dissemination, forwarding, > printing, or copying of this email is strictly prohibited. If you have > received this email in error please notify Bruno René Santos by telephone on > +351 210 438 686 > >
