Community
Participate
Working Groups
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729) Build Identifier: 20090621-0832 Database: Informix 11.50 (windows 32) EclipseLink: version 1.1.1 JDK: java version "1.6.0_15" eclipselink is creating the wrong query to create the table. This created: "CREATE TABLE USER (ID NUMERIC(19) SERIAL NOT NULL, PRIMARY KEY (ID))" when would that be: "CREATE TABLE USER (ID SERIAL NOT NULL, PRIMARY KEY (ID))" @Entity public class User { @Id @GeneratedValue(strategy=GenerationType.IDENTITY) private Long id; } /*persistence.xml (connection)*/ eclipselink.jdbc.url=jdbc:informix-sqli://localhost:9088/test:informixserver=ol_test;user=informix;password=adminadmin eclipselink.jdbc.driver=com.informix.jdbc.IfxDriver"/> eclipselink.jdbc.user=informix eclipselink.jdbc.password=adminadmin /*createDLL.jdbc*/ CREATE TABLE USER (ID NUMERIC(19) SERIAL NOT NULL, PRIMARY KEY (ID)) /*dropDLL.jdbc*/ DROP TABLE USER Reproducible: Always Steps to Reproduce: 1. Create an empty project. 2. Create an entity bean with a field id. add this annotation. @GeneratedValue(strategy=GenerationType.IDENTITY) 3. Create de persistence.xml 4. Add all the necessary libraries. 5. Run.
Please Help.
*** Bug 290928 has been marked as a duplicate of this bug. ***
To workaround this issue, you can set the persistence property eclipselink.ddl-generation.output-mode to sql-script, edit the output file, and apply it manually.
Updating target and priority. For an explanation of these values see: http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink