What all things you need to take care if you want to write Database Independent Tool in Java? I know we can use hiberante and corresponding HQL queries to make sure that there is no database specific queries. We also need to maintain the DDLs for different databases or we can use ddlutils to maintain the DDLs(I am not sure how stable is this.)? Is there anything else we need to take care of?
I just want to know from your past experience.