How do I map database specific ( non-standard ) types to JDBC types?

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.