My Persistent Objects uses JDBC to import and export the database schemas. It is also used in some bundles. So it is very important to me to have a deep knowledge about how Java types are mapped to SQL types in the most important databases.
The best source information about mapping SQL and Java Types can be found in the Sun technotes: Mapping SQL and Java Types. In that document you can read about what are the differences between the FLOAT, DOUBLE, NUMERIC, DECIMAL types, the differences between BINARY, VARBINARY and LONGVARBINARY and how they should be mapped to Java types, the mapping of the new SQL3.0 data types, the specific mapping of JDBC types in the most important databases and much more. Especially interesting are the tables at the end of the document.
