How to insert `null` values to database using Hibernate?

Question

Please have a look at the below code.

 String textName=request.getParameter("textName");
 String textadr1=request.getParameter("textadr1");
 String textadr2=request.getParameter("textadr2");
 String textcntry=request.getParameter("textcntry");
 String textregNo=request.getParameter("textregNo");

     AgentContact agentContact=new AgentContact();
     AgentContact agentContact2=new AgentContact();
     Agent agent=new Agent();

     agent.setName(textName);
     agent.setRegistrationNumber(textregNo);
     agent.setDateOfDealStart(textDateDealing);
     agent.setRegistrationDate(textregDate);

     session.save(agent);  
     session.save(agentContact);  
     session.save(agentContact2);          
     session.getTransaction().commit();

In the above code, we get the values from a form, that is why request.getParameter() is used. However, user may or may not fill some fields like name, so the txtName will be empty.

However when this code is executed, I noticed Hibernate added "empty" string to these non specified Strings, instead of entering null. How can I set the code so it enters null values when the text are actually empty?

@djb: It is nullable, yes. No default values, which means if you didn't enter anything it will be NULL — PeakGen
– PeakGen, Commented Feb 12, 2015 at 8:44

Community · Accepted Answer · 2017-05-23 12:27:20Z

2

This is not a Hiberate issue.

See here:

Are empty fields in form of JSP null or ""?

You simply need to check for an empty String and act accordingly:

agent.setName(textName.equals("") ? null : textName);

The above is a somewhat simplistic solution however: what if the user enters a space? You can use methods of Apache Commons StringUtils for more robust checking:

e.g.

http://commons.apache.org/proper/commons-lang/apidocs/org/apache/commons/lang3/StringUtils.html#isBlank(java.lang.CharSequence)

agent.setName(StringUtils.isBlank(textName) ? null : textName);

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Feb 12, 2015 at 9:19

Alan Hay

23.3k4 gold badges64 silver badges119 bronze badges

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

3 Comments

home Over a year ago

+1, or simply StringUtils.trimToNull: commons.apache.org/proper/commons-lang/apidocs/src-html/org/…

djb Over a year ago

ah yeah that makes sense. the request params will come in as "", not null.

PeakGen Over a year ago

Thanks. Appreciate your help.

Collectives™ on Stack Overflow

How to insert `null` values to database using Hibernate?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related