I need to be able to deploy my application on multiple platforms with varying database products. I'm using long text fields (over 4k), which means (I guess) that I must use different set of commands for fetching data when using Oracle compared to, say, MySQL. We are not living in a perfect world and I can l live with that - all I need is to find out the current db used and pick the correct method for perfoming the task on that db. However, I did find any documentation about how to do it. So my question is: how to find out what dialect is currently used? If that is not possible, then is there some other way to solve this issue?

Use the Configuration class and get the dialect property [getProperty(...)].