I have created a model in teiid and have set updatable property of a column to false. I want to take some decision on the basis of value of that property while doing updates using jdbc. I am not able to get this property for that column when i used the DatabaseMetadata approach. what is the approperiate way to get this property?
updatability is not exposed directly through DatabaseMetaData since it is a non-standard property. You may make a system table query to get what you are looking for:
SELECT SupportsUpdates FROM SYS.Columns WHERE SchemaName = ? AND TableName = ? AND Name = ?