Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Problem creating tables

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




Back to the top