ISPN-4686 Provide binary compatible deprecated options for 6.x

* Provide deprecated classes in old package locations.
* Provide deprecated methods when possible to keep same functionality.
ISPN-4686 Undo renaming of DatabaseType to Dialect

* Since Enums cannot be extended, the best way to keep binary
compatibility is to rename the enum back to its original name.
* New methods added still keep dialect name.
ISPN-4633 Local transaction not removed from transaction table after a size() operation