java.sql.SQLException: Field 'supplier_id' doesn't have a default value

Question

I got an error message from this：

 java.sql.SQLException: Field 'supplier_id' doesn't have a default value
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
    at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1402)
    at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1317)

Everyone can help me ? my database fields are not empty . but i want to get this results:

insert into xxx(name,password)values('xxx','xxx'); and insert into xxx(name,password,man)values('xxx','xxx','xxx'); both success (both of that in client is success ,but in java code is error,error code at top title), instead of insert into xxx(name,password)values('xxx','xxx') is false; my mysql jar is mysql-connector-java-5.0.8

It means your supplier id doesn't have a default value, and you have to insert one. — Jhecht
– Jhecht, Commented Oct 13, 2014 at 9:18
The solution for a similar problem could be found in: stackoverflow.com/questions/804514/… — Viktor Reinok
– Viktor Reinok, Commented Feb 27, 2017 at 11:38

Deval Khandelwal · Accepted Answer · 2014-10-13 09:20:23Z

34

The error is self explanatory. Your column supplier_id does not have a default value. So during insertion, mysql cannot figure out what to insert in the column supplier_id. You can do either of the three things :-
1. Add a default value to the column supplier_id Using -

ALTER TABLE `xxx` ALTER `supplier_id` SET DEFAULT NULL

2. Supply some value to the supplier_id column during insertion.
3. Add an auto increment to the column and add a primary key to it using the code :-

ALTER TABLE `xxx` CHANGE `supplier_id` `supplier_id` INT(10)AUTO_INCREMENT PRIMARY KEY;

answered Oct 13, 2014 at 9:20

Deval Khandelwal

3,5581 gold badge29 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

chendurex Over a year ago

my fields type is VARCHAR and it is not PRIMARY KEY , is there not anthor way to solve this error?

Deval Khandelwal Over a year ago

OK, so 3rd option is not applicable. So, go with the 1st option (recommended). Add a default value to the column

Deval Khandelwal Over a year ago

pass the sql query that I mentioned in the 1st option to make the default value as null for the supplier_id column

peter.petrov · Accepted Answer · 2014-10-13 09:22:06Z

4

To solve this, either supply a value for supplier_id when you do the INSERT, or make the column nullable in the DB.

answered Oct 13, 2014 at 9:22

peter.petrov

39.6k24 gold badges114 silver badges193 bronze badges

Comments

K81094 · Accepted Answer · 2018-03-14 11:01:35Z

1

There might be two cases.

You have declared the column's default value as NONE and are not not passing any value to it while inserting.
You have declared the column in database, but you have not declared the same in your entity object, which is causing the error.

answered Mar 14, 2018 at 11:01

K81094

111 bronze badge

Comments

Giorgi Tsiklauri · Accepted Answer · 2019-12-09 05:35:29Z

1

I added this property

<property name="hbm2ddl.auto">create</property>

into hibernate.cfg.xml file, and it worked for me.

edited Dec 9, 2019 at 5:35

Giorgi Tsiklauri

11.5k9 gold badges59 silver badges84 bronze badges

answered May 18, 2016 at 1:59

Deepak

1,7581 gold badge20 silver badges20 bronze badges

1 Comment

Vipul Verma Over a year ago

This is very dangerous, it will drop all the existing tables and create new ones as blank tables to match our requirements.

Pranav Barot · Accepted Answer · 2022-02-24 10:56:56Z

1

This Error say Field has a Default value means it not to be auto incremental So first thing you do is,

go for Mysql and select Alter Table and check the Auto Increment

Even So, you Getting this Error Follow below instruction.

Sometimes changes made to the model or to the ORM may not reflect accurately on the database even after execution of SchemaUpdate. the error actually seems to lack a sensible explanation, try recreating the database or at least creating a new one and scaffolding it with SchemaExport

answered Feb 24, 2022 at 10:56

Pranav Barot

591 silver badge3 bronze badges

Comments

praveen_programmer · Accepted Answer · 2014-10-13 09:20:28Z

0

You are using table where you have supplier_id column . it does not have default value ,at insertion time this column not getting any value . initialize supplier_id column with some default value , or use auto increment if you are using supplier_id as a primary key.

answered Oct 13, 2014 at 9:20

praveen_programmer

1,06212 silver badges25 bronze badges

Comments

Julian · Accepted Answer · 2020-08-27 19:39:21Z

-1

In my case, the problem was that the primary key column was not set as AUTO_INCREMENT

Here's how I solved it:

alter table library modify column Id int NOT NULL AUTO_INCREMENT;

edited Aug 27, 2020 at 19:39

Julian

37.3k24 gold badges138 silver badges196 bronze badges

answered Aug 27, 2020 at 17:34

MKT2408

11 bronze badge

Collectives™ on Stack Overflow

java.sql.SQLException: Field 'supplier_id' doesn't have a default value

7 Answers 7

3 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

3 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related