This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes Setting the column witdth Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Setting the column witdth " Watch "Setting the column witdth " New topic
Author

Setting the column witdth

amarshi mohanty
Ranch Hand

Joined: Jul 01, 2008
Posts: 110
Hi All,
In the resultsetmetadata object , we have getColumnDisplaySize(),but there is no method to set.
setColumnDispalySize() method is present in RowSetMetadata().
In my case i have to populate the CachedRowset with Resultset.The width of a paticular column is varchar(65) in postgresql,but in the java side this is coming as -5.
So i have to re-set the width size before populating to CachedRowset,otherwise i am getting

java.sql.SQLException: Invalid column display size. Cannot be less than zero

Please suggest me.
Thanks
Amarshi



SCJP (97%), SCWCD (95%))
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Setting the column witdth