On 10/9/07, Michael Gentry <[EMAIL PROTECTED]> wrote: > In the modeler, for the DbEntity, try using the NUMERIC (or maybe even > DECIMAL, but try NUMERIC first) type and for the ObjEntity it should > sync up as a java.math.BigDecimal. Set the scale to 2 (if you want 2 > places after the decimal point).
When I follow the recipe above I get ERROR: column "charge" is of type money but expression is of type numeric Which is typical when strongly typed PostgreSQL gets its feathers ruffled. I was really hoping that the simple and elegant solution would work. I think I've found the correct solution, again, involving an ExtendedType. PostgreSQL JDBC driver comes with a PGmoney class. If you specify Types.OTHER and org.postgresql.util.PGmoney and create an ExtendedType and register it with your datanode it appears to work as expected. > Also, according to the PostgreSQL documentation, the money > type is deprecated: It's been deprecated for something like 6 years now. I'm still waiting for the other shoe to drop! It seems like more work to retool for numeric(10,2) than to shoehorn yet another type into Cayenne. Cayenne seems to be able to do anything I want it to. Thank you again for your fantastic work on this product. You'll hear me say it over and over. CG
