I have searched high and low for some solid documentation on how to implement new dialects into hibernate. The original issue was that hiberate was not plugging in the needed characters for nationalization regardless of database.

I could go in a replace all tokens with the name varchar to nvarchar and char to nchar and text or clob to ntext for SQL Server and the same with Oracle with its datatypes but that is sloppy and redundant.

I have come to the conclusion that I wanted to implement an internationalized set of dialects for all supported databases and that the way to do this was to extend existing classes and call those directly when I needed a dialect.

Well the implementation as far as coding went well, but I get an cannot instantiate class dialect error. Is Hibernate using a class loader? Do I need to compile a new jar file any time I want to add a dialect or ugrade an existing version of Hibernate?

Any help is much appreciated.