We officially support only MySQL,MSSQL and Apache Derby databases wrt to the DCD-CF stack.
However we could help you with the problems your are facing.
Could you please attach your databse schema and your modified template CFC(if possible) so that we could check out from our end.
Please mail me the attachments to balajs AT adobe DOT com.
thanks for responding ,
I've come accross a similar problem with SQL Server and was getting the 'Object' datatype set by default.
It turns out that the table I was trying to add a datatype to had no data at all. I've added a single row to see what would happen and hey presto I am able to add specific data types.
Perhaps this is how the feature needs to function by analysing the actual data in the table? Took me an age to discover though!
but the table that i am generating the service and return type have more then 19000 records
This might be an issue with the way the db driver is returning the data type. If you have ColdFusion builder can you check what are the datatypes that it is displaying for the column names in the RDS view.