Hi, I've got a question for database experts. In DatabaseQueryPlugIn, the following JDBC methods are used to get numeric attributes from database features - ResultSet.getInt() - ResultSet.getDouble() those methods return an int and a double, even if the database contains NULL NULL : getInt() --> 0 NULL : getDouble() --> 0.0 I think that OpenJUMP should get a null value each time the database contains a NULL value.
If this there is no special reason to use those methods, I'll change the code to get null instead of 0 in this special cases. Thanks for any suggestion Michaël NB : I noticed another problem with null handling in SimpleQueryPlugIn. I fixed it in the svn that way : select features from layer1 where name = (empty combo box) now returns empty strings AND nulls (empty strings and null are very similar from the end-user point of view) I added "is null" as a function to be able to differentiate null from empty string cases There maybe some corner cases which are still not perfectly handled (when there are null in the dataset and the operator is not "equal" for example) ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
