cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Springett <st...@springett.us>
Subject Re: Composite Primary Key in Oracle
Date Tue, 03 May 2011 16:47:10 GMT
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 <brunorene@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 | brunorene@holos.pt <mailto:brunorene@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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message