That sounds like https://issues.apache.org/jira/browse/OPENJPA-282
It should be a trivial fix; we just need to update our Postgres
DBDictionary.
-Patrick
On 8/28/07, ben short <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have upgraded to 1.0.0-SNAPSHOT and see a different error..
>
> 31 openjpa INFO [main] openjpa.Runtime - Starting OpenJPA
> 1.0.0-SNAPSHOT
> 469 openjpa TRACE [main] openjpa.jdbc.SQL - <t 6206601, conn
> 27182317> executing prepstmnt 23103355 SELECT NULL AS SEQUENCE_SCHEMA,
> relname AS SEQUENCE_NAME FROM pg_class WHERE relkind='S'
> 469 openjpa TRACE [main] openjpa.jdbc.SQL - <t 6206601, conn
> 27182317> [0 ms] spent
> 484 openjpa TRACE [main] openjpa.jdbc.SQL - <t 6206601, conn
> 25086455> executing stmnt 3874616 CREATE TABLE AttributeAndValue (id
> BIGSERIAL NOT NULL, mAttribute VARCHAR(255), mValue VARCHAR(255),
> version INTEGER, mProductInstance BYTEA, PRIMARY KEY (id), UNIQUE
> (mAttribute, mValue) DEFERRABLE)
> 484 openjpa TRACE [main] openjpa.jdbc.SQL - <t 6206601, conn
> 25086455> [0 ms] spent
> Exception in thread "main" <openjpa-1.0.0-SNAPSHOT-r420667:564688
> nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: ERROR: syntax
> error at or near "DEFERRABLE" {stmnt 3874616 CREATE TABLE
> AttributeAndValue (id BIGSERIAL NOT NULL, mAttribute VARCHAR(255),
> mValue VARCHAR(255), version INTEGER, mProductInstance BYTEA, PRIMARY
> KEY (id), UNIQUE (mAttribute, mValue) DEFERRABLE)} [code=0,
> state=42601]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(
> MappingTool.java:549)
> at org.apache.openjpa.jdbc.meta.MappingTool.record(
> MappingTool.java:449)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(
> JDBCBrokerFactory.java:170)
> at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(
> JDBCBrokerFactory.java:130)
> at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(
> AbstractBrokerFactory.java:186)
> at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(
> DelegatingBrokerFactory.java:142)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager
> (EntityManagerFactoryImpl.java:190)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager
> (EntityManagerFactoryImpl.java:143)
> 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
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean$ManagedEntityManagerFactoryInvocationHandler.invoke
> (AbstractEntityManagerFactoryBean.java:375)
> at $Proxy0.createEntityManager(Unknown Source)
> at com.daisytechnologies.jpatest.Main.insert(Main.java:45)
> at com.daisytechnologies.jpatest.Main.main(Main.java:39)
> 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.intellij.rt.execution.application.AppMain.main(AppMain.java
> :90)
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR:
> syntax error at or near "DEFERRABLE" {stmnt 3874616 CREATE TABLE
> AttributeAndValue (id BIGSERIAL NOT NULL, mAttribute VARCHAR(255),
> mValue VARCHAR(255), version INTEGER, mProductInstance BYTEA, PRIMARY
> KEY (id), UNIQUE (mAttribute, mValue) DEFERRABLE)} [code=0,
> state=42601]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(
> LoggingConnectionDecorator.java:192)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(
> LoggingConnectionDecorator.java:57)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate
> (LoggingConnectionDecorator.java:754)
> at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(
> DelegatingStatement.java:114)
> at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(
> SchemaTool.java:1185)
> at org.apache.openjpa.jdbc.schema.SchemaTool.createTable(
> SchemaTool.java:949)
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java
> :526)
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java
> :344)
> at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java
> :321)
> at org.apache.openjpa.jdbc.meta.MappingTool.record(
> MappingTool.java:497)
> ... 20 more
>
> Im using Postgres version 8.1 with Postgres Jdbc driver version
> 8.1-408.jdbc3.
>
> Heres the sql,
>
> CREATE TABLE AttributeAndValue (id BIGSERIAL NOT NULL, mAttribute
> VARCHAR(255), mValue VARCHAR(255), version INTEGER, mProductInstance
> BYTEA, PRIMARY KEY (id), UNIQUE (mAttribute, mValue) DEFERRABLE)
>
> if I remove the DEFERRABLE then the ddl executes without errors.
>
> The Postgres 8.1 docs [1] say..
>
> DEFERRABLE
> NOT DEFERRABLE
>
> This controls whether the constraint can be deferred. A constraint
> that is not deferrable will be checked immediately after every
> command. Checking of constraints that are deferrable may be postponed
> until the end of the transaction (using the SET CONSTRAINTS command).
> NOT DEFERRABLE is the default. Only foreign key constraints currently
> accept this clause. All other constraint types are not deferrable.
>
> Regards
>
> Ben
>
> On 8/28/07, Patrick Linskey <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I think that this is actually a limitation of OpenJPA currently --
> > OpenJPA ignores unique constraints and some (most?) index definitions
> > when generating a schema.
> >
> > Could you attach the full stack trace to
> > https://issues.apache.org/jira/browse/OPENJPA-340 please? It'll be
> > useful for resolving the issue.
> >
> > -Patrick
> >
> > On 8/28/07, Ignacio Andreu <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > Regarding the documentation about OpenJPA you can define a unique
> column
> > > with something like that:
> > >
> > > @Entity
> > > @Table(name="ART", [EMAIL PROTECTED](columnNames="TITLE"))
> > > public class Article {
> > > ...
> > > }
> > >
> > > And in XML
> > >
> > > <entity class="org.mag.Article">
> > > <table name="ART">
> > > <unique-constraint>
> > > <column-name>TITLE</column-name>
> > > </unique-constraint>
> > > </table>
> > > ...
> > > </entity>
> > >
> > > For more information see the "Unique Constraints" section [1]
> > >
> > > - Ignacio
> > >
> > >
> > > [1]
> > >
> http://openjpa.apache.org/docs/latest/manual/manual.html#jpa_overview_mapping_unq
> > >
> > > On 8/28/07, ben short <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Hi,
> > > >
> > > > I am trying to use the @UniqueConstraint annotation but get the
> > > > following error message..
> > > >
> > > > OpenJPA does not yet support the @UniqueConstraint annotation.
> > > >
> > > > Is that any plan to implement this feature in the near future? Can I
> > > > define the mapping for the class that I'm trying to annotate in xml
> > > > rather than use the annotations to use the UniqueConstraint feature?
> > > >
> > > > Regards
> > > >
> > > > Ben Short
> > > >
> > >
> >
> >
> > --
> > Patrick Linskey
> > 202 669 5907
> >
>
--
Patrick Linskey
202 669 5907
