Joe Wilson a écrit : > --- XR <[EMAIL PROTECTED]> wrote: > >> The "java.sql.ResultSet.getLong(int columnIndex)" specification said: >> [...] if the value is SQL <code>NULL</code>, the value returned is >> <code>0</code> [...] >> >> However, the "org.sqlite.RS.getLong(int columnIndex)" method thows a >> NullPointerException when the value is NULL. >> I tried with some other accessors: it seems all accessors but >> "getInt(int columnIndex)" and "getString(int columnIndex)" have the >> same behaviour. >> >> Is this behaviour normal ? >> > > Probably not, but fixing this should be pretty straightforward. > Take a look at RS.java in the source code and submit a patch. >
This bug occurs only with nested DB. Here is the stack trace (for Double values, but is the same thing for Long values). java.lang.NullPointerException at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:991) at java.lang.Double.parseDouble(Double.java:482) at org.sqlite.NestedDB.column_double(NestedDB.java:124) at org.sqlite.RS.getDouble(RS.java:203) at org.sqlite.RS.getDouble(RS.java:205) at com.st.sqlite.Main.main(Main.java:37) So the bug seems located in org.sqlite.NestedDB class. Did you know how I can patch it ? Another solution can be to add try/catch blocks in org.sqlite.RS class, but I'm not convinced... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLiteJDBC" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlitejdbc?hl=en -~----------~----~----~----~------~----~------~--~---
