Bug 290848 - eclipselink is creating the wrong query to create the table. (informix 11.50)
Summary: eclipselink is creating the wrong query to create the table. (informix 11.50)
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard: informix
Keywords:
: 290928 (view as bug list)
Depends on:
Blocks:
 
Reported: 2009-09-29 16:46 EDT by ale CLA
Modified: 2022-06-09 10:03 EDT (History)
3 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description ale CLA 2009-09-29 16:46:42 EDT
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.
Comment 1 ale CLA 2009-09-29 16:49:08 EDT
Please Help.
Comment 2 ale CLA 2009-09-30 12:36:52 EDT
*** Bug 290928 has been marked as a duplicate of this bug. ***
Comment 3 Tom Ware CLA 2009-10-01 09:23:28 EDT
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.
Comment 4 Tom Ware CLA 2009-10-07 15:08:37 EDT
Updating target and priority.  For an explanation of these values see:

http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines
Comment 5 Eclipse Webmaster CLA 2022-06-09 10:03:39 EDT
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink