Re: [eclipselink-users] Problem creating tables

[Tom Ware <tom.ware@xxxxxxxxxx>]

Hi Ellen,

  I have filed the following bug for the DDL issue.

https://bugs.eclipse.org/bugs/show_bug.cgi?id=220769

  We'll try to get back to you soon about the other issues.

-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