Databases
StackOverflow2013
Postsdbo
POWhen accessing ResultSets in JDBC, is there an elegant way to distinguish between nulls and actual zero values?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhen accessing ResultSets in JDBC, is there an elegant way to distinguish between nulls and actual zero values?
    primarykey
    data
    text
    <p>When using JDBC and accessing primitive types via a result set, is there a more elegant way to deal with the null/0 than the following:</p> <pre><code>int myInt = rs.getInt(columnNumber) if(rs.wasNull())? { // Treat as null } else { // Treat as 0 } </code></pre> <p>I personally cringe whenever I see this sort of code. I fail to see why ResultSet was not defined to return the boxed integer types (except, perhaps, performance) or at least provide both. Bonus points if anyone can convince me that the current API design is great :) </p> <p>My personal solution was to write a wrapper that returns an Integer (I care more about elegance of client code than performance), but I'm wondering if I'm missing a better way to do this. </p> <p>Just to clarify, what bothers me about this code is not the length, but the fact that a it creates a state dependency between subsequent calls, and what appears like a simple getter actually has a side effect within the same row. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USUri
    1. USUri
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhen accessing ResultSets in JDBC, is there an elegant way to distinguish between nulls and actual zero values?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhen accessing ResultSets in JDBC, is there an elegant way to distinguish between nulls and actual zero values?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhen accessing ResultSets in JDBC, is there an elegant way to distinguish between nulls and actual zero values?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COClearly the people responsible for replacing a > b with a.compare(b) > 0 couldn't imagine a world where you wouldn't want to use getBigDecimal in place of any of the other options!
      singulars
      1. POWhen accessing ResultSets in JDBC, is there an elegant way to distinguish between nulls and actual zero values?
      1. USAffe
    2. CONot an answer but a hint. This "dilemma" is handled in http://www.jooq.org, where all numeric types are treated as object, and this JDBC "fact" is abstracted... So with jOOQ, there's no need to write your own wrapper for JDBC shortcomings
      singulars
      1. POWhen accessing ResultSets in JDBC, is there an elegant way to distinguish between nulls and actual zero values?
      1. USLukas Eder
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload