This week's book giveaway is in the JDBC forum. We're giving away four copies of Make it so: Java DB Connections & Transactions and have Marcho Behler on-line! See this thread for details.

hii, i am retriving table's cloumn sizes in which i am getting String column sizes perfectly by getColumnDisplaySize() method.but it doesnt give the size of any number field.it gives the 22 for all the integer columns....so is there any other method for this??? please give me quick reply...

hey, i am using ResultsetMetaData,thru which i am taking max value which can be inserted in the database.i am getting right values thru getCloumnDisplaySize() method for String column of a table.but it gives length of 22 for all integer values of all the tables in the database.i am creating dynamic insert query for which i am requing this..