Incorrect column specifier for column 'ssid SSID'

When a data table is generated using hibernate, Hibernate executes the following SQL statement:

 

Create Table address (addressid varchar (255) not null auto_increment, name varchar (255), primary key (addressid ))

 

When log4j check is used: hibernat prompts the following error:

10:56:24, 546 error schemaexport: 274-unsuccessful: Create Table address (addressid varchar (255) not null auto_increment, name varchar (255), primary key (addressid ))
10:56:24, 546 error schemaexport: 275-incorrect column specifier for column 'ssid SSID'

 

 

The original auto-increment column uses the int data type instead of varchar.

 

Hibernate uses the code in address. Java

Private string addressid;
Private string name;

 

This specifies the "addressid varchar (255) not null auto_increment"

 

If the column is automatically increased, you can either change the addressid to the integer type or change the ing file to another primary key generation policy.