<div>
Have you tried ps.setFloat() or setDouble() passing in the value.<br />
Something like ps.setFloat(1,Float.NaN);<br />
And besides that have you checked your SQL statement ?? YOu have forgotten your erm.. Table name .
</div>


Have you tried ps.setFloat() or setDouble() passing in the value.
Something like ps.setFloat(1,Float.NaN);
And besides that have you checked your SQL statement ?? YOu have forgotten your erm.. Table name .

<div>
I tried this solution yet with no succes. In fact, i think it is probably due to the bite value of the Float.NaN in java comparing to the his value on the database (I use Sybase).
</div>


I tried this solution yet with no succes. In fact, i think it is probably due to the bite value of the Float.NaN in java comparing to the his value on the database (I use Sybase).

<div>
<div class="content wysiwyg-content">
I try to retrieve rows that include columns with an NaN value as Float.<br />
I use preparedStatement.<br />
<br />
ex : select c1,c2,c3 where c1 = ?<br />
<br />
java code is like :<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ps = con.preparedStatement(sele<wbr />ct c1,c2,c3 where c1 = ?);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ps.setObjet(1,new Float(Float.NaN);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;rs = ps.executeQuery();<br />
<br />
I know that some rows match this case, but rs.next() return false<br />
<br />
Can somebody help me ?<br />
<br />

</div>
</div>


I try to retrieve rows that include columns with an NaN value as Float.
I use preparedStatement.

ex : select c1,c2,c3 where c1 = ?

java code is like :

               ps = con.preparedStatement(select c1,c2,c3 where c1 = ?);
               ps.setObjet(1,new Float(Float.NaN);
               rs = ps.executeQuery();

I know that some rows match this case, but rs.next() return false

Can somebody help me ?



JDBC and NaN in where condition

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.