does anyone understand the difference between "data_types" and "type_name" when it comes to jdbc meta data?

Perhaps a better question for #sql than #architecture ? Are you referring to https://docs.oracle.com/javase/8/docs/api/java/sql/JDBCType.html

yes and yes