Re: [eclipselink-users] Problem creating tables

[Ellen Kraffmiller <ekraffmiller@xxxxxxxxxxxxxxxx>]

We are using annotations - here is an example:

  @Id @GeneratedValue(strategy=GenerationType.SEQUENCE, 
generator="study_gen")
   @SequenceGenerator(name="study_gen", sequenceName="study_id_seq")
       private Long id;
  

> Hi Ellen,
>
>   Could you post the annotations and/or xml you are using to define 
> the sequence causing the issue?
>
> Thanks,
> Tom
>
> Ellen Kraffmiller wrote:
>
> > Hi Tom,
> > I added the property and the tables are being generated  now, thanks.
> >
> > Two difference I noticed between TopLink Essentials DDL and 
> > EclipseLink DDL (and target database of Postgres):
> > 1) The primary key in TopLink DDL is type serial; in EclipseLink it's 
> > type int8. 2) The sequences generated with TopLink have increment 
> > value of 1, in EclipseLink it's 50.
> > The first difference is causing a problem because we have a sql 
> > script for setting reference data that contains insert statements, 
> > which don't call nextval() to set the primary key.  I can change the 
> > script, but I just was curious if there's a property I can use to 
> > tell EclipseLink to use type serial.
> >
> > The second difference I think is causing a problem when I run the 
> > application with EclipseLink, but keep the sequences originally 
> > generated by TopLink  (something we will need to do if we switch to 
> > EclipseLink in production).  When I try to persist a new entity I get 
> > this Exception -
> >       The sequence named [study_id_seq] is setup incorrectly.  Its 
> > increment does not match its pre-allocation size.
> >    at 
> > org.eclipse.persistence.internal.jpa.EntityManagerImpl.persist(EntityManagerImpl.java:191) 
> >
> >    at 
> > com.sun.enterprise.util.EntityManagerWrapper.persist(EntityManagerWrapper.java:440) 
> >
> >
> > Any suggestions for workarounds for this error?
> > Thanks,
> > Ellen
> >
> >
> > Tom Ware wrote:
> >
> > > Hi Ellen,
> > >
> > >   What happens when you add the following property?
> > >
> > > <property name="eclipselink.ddl-generation.output-mode" 
> > > value="database"/>
> > >
> > > -Tom
> > >
> > > Ellen Kraffmiller wrote:
> > >
> > > > Hi Tom,
> > > > I am using  EclipseLink DDL generation, here is the persistence 
> > > > unit metadata:
> > > >
> > > > <persistence-unit name="VDCNet-ejbPU" transaction-type="JTA">
> > > >    
> > > > <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
> > > >    <jta-data-source>jdbc/VDCNetDS</jta-data-source>
> > > >    <properties>
> > > >         <property name="eclipselink.logging.level" value="FINEST"/>
> > > >      <property name="eclipselink.ddl-generation" 
> > > > value="create-tables"/>
> > > >    </properties>
> > > >  </persistence-unit>
> > > >
> > > > Thanks,
> > > > Ellen
> > > >
> > > > Tom Ware wrote:
> > > >
> > > > > Hi Ellen,
> > > > >
> > > > >   Are you using the DDL generation feature of EclipseLink?  If so, 
> > > > > can you forward the persistence unit properties you are using to 
> > > > > enable it?  If not, how are you generating your tables.
> > > > >
> > > > >   I suspect the problem is related to the way GlassFish does table 
> > > > > generation.   It expects EclipseLink to provide some files it can 
> > > > > use to add and drop tables. I am wondering if it is having trouble 
> > > > > finding them because of an integration issue.
> > > > >
> > > > > -Tom
> > > > >
> > > > > Ellen Kraffmiller wrote:
> > > > >
> > > > > > I am able to use the nightly build in Glassfish, and the 
> > > > > > persistence unit deploys correctly, as long as my tables already 
> > > > > > exist.  However I'm running into a problem when I drop my tables 
> > > > > > and redeploy the application - no tables are created in the 
> > > > > > database.  I'm not seeing any error messages in my server log, 
> > > > > > but I noticed the nightly build had some test failures relating 
> > > > > > to create table.  Could the failures in the nightly build be 
> > > > > > related to the problem I'm seeing?
> > > > > > Thanks,
> > > > > > Ellen
> > > > > > _______________________________________________
> > > > > > eclipselink-users mailing list
> > > > > > eclipselink-users@xxxxxxxxxxx
> > > > > > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > eclipselink-users mailing list
> > > > > eclipselink-users@xxxxxxxxxxx
> > > > > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> > > >
> > > > _______________________________________________
> > > > eclipselink-users mailing list
> > > > eclipselink-users@xxxxxxxxxxx
> > > > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> > >
> > >
> > > _______________________________________________
> > > eclipselink-users mailing list
> > > eclipselink-users@xxxxxxxxxxx
> > > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> >
> > _______________________________________________
> > eclipselink-users mailing list
> > eclipselink-users@xxxxxxxxxxx
> > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users