Automatic conversion of datatypes

[AGM]

Please let me know how can I automatically convert particular DB datatypes to specific language datatypes.

Here is the problem:

I tried importing a DB Schema, with Database as SQL Server 2000. I could generate all tables. Next I tried to Generate Code and Java was selected as the target language. But then the datatypes remained as 'varchar', 'smallint' etc in the source code.

How can I generate source code that maps the datatypes? I tried modifying the Code Datatypes and Database Datatypes by providing the same required 'Common type'. But this did not work.

Please help.

Regards,
AGM