You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by "Andres L." <an...@gmail.com> on 2013/10/13 15:50:33 UTC

Primary key problem with Cayenne

Made a mistake on subject.

---------- Forwarded message ----------
From: Andres L. <an...@gmail.com>
Date: 2013/10/13
Subject: Public key problem with Cayenne
To: user@cayenne.apache.org


Hi. I've reengineered my database schema using Cayenne modeler to use it
with cayenne. But, when I make this:

            Parametro a = context.newObject(Parametro.class);

            a.setRutaauditoria("Primera ruta");
            a.setNombresoftware("Software name goes here");
            a.setProduccionadicional(100f);
            a.setEstado(1);

            context.commitChanges();

I get this error:
--- ERROR --
Exception in thread "main" org.apache.cayenne.CayenneRuntimeException:
[v.3.0.2 Jun 19 2011 09:29:50] Commit Exception
    at
org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1149)
    at
org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1060)
    at dp1.titandevelop.titano.Main.main(Main.java:29)
Caused by: org.postgresql.util.PSQLException: ERROR: relation
"public.pk_parametro" does not exist
  Position: 16
    at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
    at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
    at
org.apache.cayenne.dba.postgres.PostgresPkGenerator.longPkFromDatabase(PostgresPkGenerator.java:91)
    at
org.apache.cayenne.dba.JdbcPkGenerator.generatePk(JdbcPkGenerator.java:270)
    at
org.apache.cayenne.access.DataDomainInsertBucket.createPermIds(DataDomainInsertBucket.java:172)
    at
org.apache.cayenne.access.DataDomainInsertBucket.appendQueriesInternal(DataDomainInsertBucket.java:77)
    at
org.apache.cayenne.access.DataDomainSyncBucket.appendQueries(DataDomainSyncBucket.java:79)
    at
org.apache.cayenne.access.DataDomainFlushAction.preprocess(DataDomainFlushAction.java:182)
    at
org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:134)
    at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824)
    at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791)
    at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
    at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788)
    at
org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1121)
    ... 2 more
--- END OF ERROR ---

I'm using postgresql 9.2 and Cayenne 3.0.2. It's for a course project in
the university I study in.

Sorry for my bad english.


Thank you.

Re: Primary key problem with Cayenne

Posted by "Andres L." <an...@gmail.com>.
Hi, It finally worked with that instructions. Thank you very much.


2013/10/13 Andrus Adamchik <an...@objectstyle.org>

> Default PK genration mechanism in Cayenne for PostgreSQL is to use a
> sequence pk_[tablename]. So this is what Cayenne is attempting here. You
> may want to generate all required sequences in DB using the Modeler:
>
> http://cayenne.apache.org/docs/3.0/generate-primary-key-support.html
>
> Andrus
>
>
> On Oct 13, 2013, at 5:50 PM, Andres L. <an...@gmail.com> wrote:
> > Made a mistake on subject.
> >
> > ---------- Forwarded message ----------
> > From: Andres L. <an...@gmail.com>
> > Date: 2013/10/13
> > Subject: Public key problem with Cayenne
> > To: user@cayenne.apache.org
> >
> >
> > Hi. I've reengineered my database schema using Cayenne modeler to use it
> > with cayenne. But, when I make this:
> >
> >            Parametro a = context.newObject(Parametro.class);
> >
> >            a.setRutaauditoria("Primera ruta");
> >            a.setNombresoftware("Software name goes here");
> >            a.setProduccionadicional(100f);
> >            a.setEstado(1);
> >
> >            context.commitChanges();
> >
> > I get this error:
> > --- ERROR --
> > Exception in thread "main" org.apache.cayenne.CayenneRuntimeException:
> > [v.3.0.2 Jun 19 2011 09:29:50] Commit Exception
> >    at
> >
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1149)
> >    at
> >
> org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1060)
> >    at dp1.titandevelop.titano.Main.main(Main.java:29)
> > Caused by: org.postgresql.util.PSQLException: ERROR: relation
> > "public.pk_parametro" does not exist
> >  Position: 16
> >    at
> >
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
> >    at
> >
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
> >    at
> >
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> >    at
> >
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
> >    at
> >
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
> >    at
> >
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
> >    at
> >
> org.apache.cayenne.dba.postgres.PostgresPkGenerator.longPkFromDatabase(PostgresPkGenerator.java:91)
> >    at
> >
> org.apache.cayenne.dba.JdbcPkGenerator.generatePk(JdbcPkGenerator.java:270)
> >    at
> >
> org.apache.cayenne.access.DataDomainInsertBucket.createPermIds(DataDomainInsertBucket.java:172)
> >    at
> >
> org.apache.cayenne.access.DataDomainInsertBucket.appendQueriesInternal(DataDomainInsertBucket.java:77)
> >    at
> >
> org.apache.cayenne.access.DataDomainSyncBucket.appendQueries(DataDomainSyncBucket.java:79)
> >    at
> >
> org.apache.cayenne.access.DataDomainFlushAction.preprocess(DataDomainFlushAction.java:182)
> >    at
> >
> org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:134)
> >    at
> org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824)
> >    at
> org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791)
> >    at
> >
> org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
> >    at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788)
> >    at
> >
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1121)
> >    ... 2 more
> > --- END OF ERROR ---
> >
> > I'm using postgresql 9.2 and Cayenne 3.0.2. It's for a course project in
> > the university I study in.
> >
> > Sorry for my bad english.
> >
> >
> > Thank you.
>
>

Re: Primary key problem with Cayenne

Posted by Andrus Adamchik <an...@objectstyle.org>.
Default PK genration mechanism in Cayenne for PostgreSQL is to use a sequence pk_[tablename]. So this is what Cayenne is attempting here. You may want to generate all required sequences in DB using the Modeler:

http://cayenne.apache.org/docs/3.0/generate-primary-key-support.html

Andrus


On Oct 13, 2013, at 5:50 PM, Andres L. <an...@gmail.com> wrote:
> Made a mistake on subject.
> 
> ---------- Forwarded message ----------
> From: Andres L. <an...@gmail.com>
> Date: 2013/10/13
> Subject: Public key problem with Cayenne
> To: user@cayenne.apache.org
> 
> 
> Hi. I've reengineered my database schema using Cayenne modeler to use it
> with cayenne. But, when I make this:
> 
>            Parametro a = context.newObject(Parametro.class);
> 
>            a.setRutaauditoria("Primera ruta");
>            a.setNombresoftware("Software name goes here");
>            a.setProduccionadicional(100f);
>            a.setEstado(1);
> 
>            context.commitChanges();
> 
> I get this error:
> --- ERROR --
> Exception in thread "main" org.apache.cayenne.CayenneRuntimeException:
> [v.3.0.2 Jun 19 2011 09:29:50] Commit Exception
>    at
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1149)
>    at
> org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1060)
>    at dp1.titandevelop.titano.Main.main(Main.java:29)
> Caused by: org.postgresql.util.PSQLException: ERROR: relation
> "public.pk_parametro" does not exist
>  Position: 16
>    at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
>    at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
>    at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
>    at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
>    at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
>    at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
>    at
> org.apache.cayenne.dba.postgres.PostgresPkGenerator.longPkFromDatabase(PostgresPkGenerator.java:91)
>    at
> org.apache.cayenne.dba.JdbcPkGenerator.generatePk(JdbcPkGenerator.java:270)
>    at
> org.apache.cayenne.access.DataDomainInsertBucket.createPermIds(DataDomainInsertBucket.java:172)
>    at
> org.apache.cayenne.access.DataDomainInsertBucket.appendQueriesInternal(DataDomainInsertBucket.java:77)
>    at
> org.apache.cayenne.access.DataDomainSyncBucket.appendQueries(DataDomainSyncBucket.java:79)
>    at
> org.apache.cayenne.access.DataDomainFlushAction.preprocess(DataDomainFlushAction.java:182)
>    at
> org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:134)
>    at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824)
>    at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791)
>    at
> org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
>    at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788)
>    at
> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1121)
>    ... 2 more
> --- END OF ERROR ---
> 
> I'm using postgresql 9.2 and Cayenne 3.0.2. It's for a course project in
> the university I study in.
> 
> Sorry for my bad english.
> 
> 
> Thank you.