Jdbc null long

Method Detail values public static JDBCType [] values Returns an array containing the constants of this enum type, in the order they are declared. The string must match exactly an identifier used to declare an enum constant in this type. Extraneous whitespace characters are not permitted. Parameters: name - the name of the enum constant to be returned.

You would think that having a nullable numeric column in a database would be common enough that the ResultSet API would accommodate it a little more elegantly. Philosophically this comes down to whether the DB should conform to the app, or vice versa. ResultSet , I opt to handle it at the DB when possible. This, of course, assumes that conceptually NULL and zero are equivalent for your purposes. Just write Add a comment. Active Oldest Votes.

Improve this answer. Richard Richard 9, 2 2 gold badges 23 23 silver badges 15 15 bronze badges. The truth is, indeed, ridiculous. The devs really messed this one up. Also it is a very low level API, that shouldn't enforce the potential extra cost of wrapping raw bytes from a database inside a Java Integer object.

Show 15 more comments. So it should even be possible to do something like: if rs. Andreas Dolk Andreas Dolk k 16 16 gold badges silver badges bronze badges. Hm, at least in my case, the problem with this is that calling getObject doesn't necessarily return an Integer, due to the nature of the column type in the oracle db I'm using "Number".

Same problem of Matt Could also do rs. BalusC BalusC 1. No, but it will construct an unnecessary Integer object in the non-null case. It depends on fetch size. In most drivers, the default is 10 rows and once the fetch has been retrieved, they will be processed, but the next fetch won't be retrieved until processing has been finished.

I'm surprise that your answer is not the better answer :- I vote up because it is the proper answer that avoid the very tricky unsafe wasNull method. Collectives on Stack Overflow. Learn more. Asked 7 years, 9 months ago. Active 3 years, 3 months ago. Viewed 6k times. Any inputs ideas, or suggestions.

Improve this question. Each method can be used with column name or by its ordinal position. The java. Time and java. Following example shows how the Date and Time classes format the standard Java date and time values to match the SQL data type requirements. Use wrapper classes for primitive data types, and use the ResultSet object's wasNull method to test whether the wrapper class variable that received the value returned by the getXXX method should be set to null.

Use primitive data types and the ResultSet object's wasNull method to test whether the primitive variable that received the value returned by the getXXX method should be set to an acceptable value that you've chosen to represent a NULL.