At some point I read that Compiere was interested in using CMP to achieve database independence. Have you considered other persistence frameworks that can help achieve this? There are many open source persistence frameworks that might help achieve this for a smaller cost, such as hibernate or OJB.
Compiere will not be using CMP. It will use its own persitence engines