Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the limitations in Mapping SQL data types to Java types?

April 26, 2017Data Java limitations Mapping sql types

0

Posted

What are the limitations in Mapping SQL data types to Java types?

1 Answer

0

Posted

You should provide appropriate Java mappings for the common SQL data types. Ensure that you have type information to store and retrieve parameters and recover results from SQL statements. A Java data type may not be isomorphic to the SQL data type. For example, you can represent both fixed length and variable length SQL arrays as variable length Java arrays as Java has no fixed length arrays. Server uses Java strings though they are not a precise match for any SQL CHAR type. The following table lists the default Java mappings for various common SQL data types. These types are not entirely supported by all databases.