posted 20 years ago
I don't believe that such a thing exists. The best you can do is look at the "java.sql.Types" API to see what's defined there.
One of the difficulties in doing the mapping you propose is that there might not be one--and only one--way to map. For example, if something is "Numeric" in the database, should that to map to an "int", "long", "float", "double", "Integer", "Long", "Float" or "Double" in Java?
I believe that the Java <--> Database type mapping is defined as a matrix of legal possibilities because there is no one-to-one mapping.
[ October 29, 2003: Message edited by: Wayne L Johnson ]