hi ranchers im a bit stuck on a problem so i need your help!
i have a very easy piece of code that uses a Connection and a DatabaseMetaData to retrieve tables and their columns .. so far so good .. for a bunch of tables the number of columns is doubled!! and i dont know why ..
then i get "MYTABLE cols=8" for .. say ..a table with only 4 cols ..
i know it may be trivial for some of you but that's my first attempt at using DatabaseMetaData
thanks for any help [ March 28, 2006: Message edited by: Lukas Alamar ]
Lukas, I suspect there may be some hidden columns. The easiest way to confirm that or see what is going on is to print out colRset.getString("COLUMN_NAME") within your loop. Then you can see precisely what is being returned.