Andrus Adamchik created CAY-2740: ------------------------------------ Summary: Mapping Proposal: DbAttribute should have its own Java type Key: CAY-2740 URL: https://issues.apache.org/jira/browse/CAY-2740 Project: Cayenne Issue Type: Improvement Reporter: Andrus Adamchik
Let's make "javaType" a property of DbAttribute. By default it will be auto-generated from JDBC type. And we can allow to optionally override it at the ObjAttribute level (with an explicit conversion when creating objects from DataRows). h2. Problems it Solves * Non-standard type mapping (the whole OTHER type implies we provide some Java class for it). This provides runtime consistency and eliminates the internal hacks such as when Cayenne would try to guess which ObjEntities might use this DataRow, and populate DataRows with values corresponding to the ObjAttribute type definitions. This clearly breaks layer separation and doesn't always work. * Unexpected PK types. PK columns are often not mapped as ObjAttributes, so their type is guessed by Cayenne, and if the type is something vague such as NUMBER, you may get BigDecimals, and other inappropriate types, and you can no longer reliably compare objects. h2. Prior discussions: * http://markmail.org/message/6bs2suislyfp3apk * http://markmail.org/message/icr7seqazgsdtewc -- This message was sent by Atlassian Jira (v8.20.10#820010)