Hi All,
I believe this bug has been addressed in JIRAs OPENJPA-557 and OPENJPA-582.
Only not-yet-released OpenJPA versions 2.0 and 1.3 contain the fix but you will
find a workaround in one of these JIRAs.
Cheers,
Milosz
> Hi Peter,
> I seem to remember some problem that Jeremy found with not processing the
> schema name for id generation. But, maybe my memory isn't what it was...
> :-) I'll copy Jeremy on this reply to see if this rings a bell with him.
>
> Thanks,
> Kevin
>
> On Wed, May 13, 2009 at 5:26 PM, Peter Henderson wrote:
>
> > I've an entity bean [1] which maps to a table [2] in a specific schema.
> > The entity bean has an Integer id column which is generated using a
> > sequence. The database in question is Postgresql 8.3.x
> >
> > When I used TopLinkEssentials I could specify
> > @GeneratedValue(strategy = GenerationType.IDENTITY)
> > and the correct sequence was used
> > "summary_charts.mappings_layout_chart_mapping_id_seq"
> >
> > but...
> >
> > using OpenJPA I get an exception saying sequence
> > "mappings_layout_chart_mapping_id_seq" not being found [3]
> > is this a bug with OpenJPA in that it is not using the schema of the table
> > or a bug in my code? Shouldn't OpenJpa be looking for a sequence called
> > .__seq
> >
> > e.g.
> > it should be looking for
> >
> > summary_charts + "." + // schema name
> > mappings "_" // table name
> > layout_chart_mapping_id "_seq" // column name
> >
> > "summary_charts.mappings_layout_chart_mapping_id_seq"
> >
> >
> >
> >
> > In the mean time I have a work around using
> > @SequenceGenerator(
> >
> > name="summary_charts.mappings_layout_chart_mapping_id_seq",
> >
> > sequenceName="summary_charts.mappings_layout_chart_mapping_id_seq")
> >
> > and
> > @GeneratedValue(generator =
> > "summary_charts.mappings_layout_chart_mapping_id_seq",
> > strategy = GenerationType.SEQUENCE)
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Cheers
> >
> > Peter.
> >
> >
> >
> >
> >
> >
> > [1] Entity bean
> > /**
> > *
> > * @author peter
> > */
> > @Entity
> > @Table(name = "mappings", schema="summary_charts")
> > public class SummaryMapping implements Serializable {
> > @Id
> > @GeneratedValue(strategy = GenerationType.IDENTITY)
> > @Column(name = "layout_chart_mapping_id", nullable = false)
> > private Integer mappingId;
> >
> > .. SNIP other fields getters/setters/hashcode/equals/toString ..
> > }
> >
> > [2] Database table
> > CREATE SCHEMA summary_charts;
> >
> > CREATE TABLE summary_charts.mappings
> > (
> > layout_chart_mapping_id serial NOT NULL,
> > layout_id integer NOT NULL,
> > chart_id integer NOT NULL,
> > layout text NOT NULL,
> > CONSTRAINT mappings_pkey PRIMARY KEY (layout_chart_mapping_id),
> > CONSTRAINT mappings_chart_id_fkey FOREIGN KEY (chart_id)
> > REFERENCES summary_charts.charts (chart_id) MATCH SIMPLE
> > ON UPDATE NO ACTION ON DELETE NO ACTION,
> > CONSTRAINT mappings_layout_id_fkey FOREIGN KEY (layout_id)
> > REFERENCES summary_charts.layouts (layout_id) MATCH SIMPLE
> > ON UPDATE NO ACTION ON DELETE NO ACTION
> > )
> > WITH (OIDS=FALSE);
> > ALTER TABLE summary_charts.mappings OWNER TO dbadmin;
> >
> >
> >
> > [3] Exception message
> >
> > org.apache.openjpa.persistence.RollbackException: The transaction has been
> > rolled back. See the nested exceptions for details on the errors that
> > occurred.
> > at
> > org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:523)
> > at
> > com.starjar.starjarenterprise5.api.ServiceBase.returnEntityManager(ServiceBase.java:98)
> > at
> > com.starjar.starjarenterprise5.api.SummaryChartService.createSummaryMapping(SummaryChartService.java:80)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> > at
> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:597)
> > at
> > com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:192)
> > at
> > com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:110)
> > at
> > com.caucho.hessian.server.HessianServlet.service(HessianServlet.java:416)
> > at
> > com.starjar.starjarenterprise5.api.ServiceBase.service(ServiceBase.java:107)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
> > at
> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:290)
> > at
> > org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
> > at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
> > at
> > org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
> > at
> > org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
> > at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
> > at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
> > at
> > org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
> > at
> > org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
> > at
> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
> > at
> > org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
> > at
> > org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
> > at
> > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
> > at
> > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
> > at
> > org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
> > at
> > com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
> > at
> > com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
> > at
> > com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
> > at
> > com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
> > at
> > com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
> > at
> > com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
> > at
> > com.sun.enterprise.web.portunif.PortUnificationPipeline$PUTask.doTask(PortUnificationPipeline.java:380)
> > at
> > com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
> > at
> > com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
> > Caused by:
> > org.apache.openjpa.persistence.PersistenceException: The transaction has
> > been rolled back. See the nested exceptions for details on the errors that
> > occurred.
> > at
> > org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2163)
> > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2010)
> > at
> > org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1908)
> > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1679)
> > at
> > org.apache.openjpa.kernel.DelegatingBroker.flush(DelegatingBroker.java:989)
> > at
> > org.apache.openjpa.persistence.EntityManagerImpl.flush(EntityManagerImpl.java:592)
> > at
> > com.starjar.starjarenterprise5.service.helpers.SummaryApi.createSummaryMapping(SummaryApi.java:113)
> > at
> > com.starjar.starjarenterprise5.api.SummaryChartService.createSummaryMapping(SummaryChartService.java:77)
> > ... 35 more
> > Caused by:
> > org.apache.openjpa.persistence.PersistenceException: ERROR: relation
> > "mappings_layout_chart_mapping_id_seq" does not exist {prepstmnt 1646550480
> > SELECT CURRVAL('mappings_layout_chart_mapping_id_SEQ')} [code=0,
> > state=42P01]
> > at
> > org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
> > at
> > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
> > at
> > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> > at
> > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
> > at
> > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> > at
> > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:74)
> > at
> > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
> > at
> > org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:105)
> > at
> > org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
> > at
> > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
> > at
> > org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
> > at
> > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:717)
> > at
> > org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
> > ... 42 more
> > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR:
> > relation "mappings_layout_chart_mapping_id_seq" does not exist {prepstmnt
> > 1646550480 SELECT CURRVAL('mappings_layout_chart_mapping_id_SEQ')} [code=0,
> > state=42P01]
> > at
> > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
> > at
> > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
> > at
> > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852)
> > at
> > org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
> > at
> > org.apache.openjpa.jdbc.sql.PostgresDictionary$PostgresPreparedStatement.executeQuery(PostgresDictionary.java:520)
> > at
> > org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
> > at
> > org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1595)
> > at
> > org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
> > at
> > org.apache.openjpa.jdbc.sql.DBDictionary.executeQuery(DBDictionary.java:4453)
> > at
> > org.apache.openjpa.jdbc.sql.DBDictionary.getGeneratedKey(DBDictionary.java:4010)
> > at
> > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:98)
> > at
> > org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72)
> > ... 49 more
> >
> >
> >
> >
> >
> >
> > --
> > Peter Henderson
> > Director Starjar Limited.
> >
> > Mobile: +44 (0) 778 233 8645
> > Email: [email protected]
> > Web: www.starjar.com
> >
> >
>
