Eclipse Community Forums: EclipseLink » DDL & MySQL & Primary Key

Home

Home » Eclipse Projects » EclipseLink » DDL & MySQL & Primary Key

DDL & MySQL & Primary Key [message #1769021]

Tue, 25 July 2017 14:32

Eclipse User

Hello,

I am trying to use DDL to generate my database automatically BUT this case causes an error :

@Id on a String
MySQL database

It generates this code with an "AUTO_INCREMENT" on a "VARCHAR" :

CREATE TABLE t_systeme (PARAM VARCHAR(255) AUTO_INCREMENT NOT NULL, DESCRIPTION VARCHAR(255), VALEUR VARCHAR(255), REF_SOCIETE INTEGER, PRIMARY KEY (PARAM))

Why ? How to fix this ?

Thanks in advance.

Re: DDL & MySQL & Primary Key [message #1769112 is a reply to message #1769021]

Wed, 26 July 2017 11:29

Eclipse User

Not sure what you are looking for. Why are you using ID generation on a string value, should it not be an Integer type in your object?

Your Id likely has the @GeneratedValue(strategy=GenerationType.IDENTITY) annotation that you either need to remove and set the values yourself, or switch it to a numeric like Integer.

[Updated on: Wed, 26 July 2017 11:43] by Moderator

Previous Topic:	Persist with secondaryTable from non PK field
Next Topic:	Setting up cache coordination with Payara

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Oct 26 23:37:26 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter