Java sql set null value

Now, if one of the column values contains no value, i. This problem stems from the fact that the column field is NULL allowed in the database. That means your problem is not that the String value is null, rather some other object is, perhaps your ResultSet or maybe you closed the connection or something like this. Provide the stack trace, that would help.

The String being null is a very good chance, but when you see values in your table, yet a null is printed by the ResultSet, it might mean that the connection was closed before the value of ResultSet was used.

I came across with the same issue. But I believe , handling null in the sql is not a good option. Again, with this you can use null check, that is fine. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Handling the null value from a resultset Ask Question. Asked 10 years, 8 months ago. Active 6 months ago. Viewed k times. Improve this question. Mark Rotteveel If the column is null, the ResultSet should return null.

Are you sure the ResultSet is not null? I don't see why an NPE would be thrown here. I'm decidedly curious as to why this was downvoted. Add a comment. Active Oldest Votes. Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search.

You need to do some conditional logic in your java code to determine what your sql query will be. If you want the birth date set to null, your statement has to be.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years ago. Active 8 years ago. Viewed times. The statement is correct I checked it in phpMyAdmin console. I just want to insert a null value, not check anything — Pauli. Null is also a reserved java command and won't work without double quotes either.

I'm stuck — Pauli. You need prepared statement,when your variable String is null, prepared statement will insert as NULL values not String 'null' — thecupu.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.

Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.