How do I map database specific ( non-standard ) types to JDBC types?
Created May 4, 2012
Joe Sam Shirah The first answer is to stick with SQL standard types whenever possible; otherwise you'll have costly migration headaches when moving to or working with other databases.
If that's not possible, then the SQL/JDBC manuals for the specific database SHOULD provide this information. See Where can I find online documentation for database xyz? for links.
The JDK documentation, particularly for 1.3, also has mapping information and a section on database specific type mapping. See: 8 Mapping SQL and Java Types , subsection 8.9.7 JDBC Types Mapped to Database-specific SQL Types.