Maximum Number of Columns a ResultSet can support

> Can someone tell me what the maximum number of

> columns a result set can support? I'm using a

> cachedrowset to retrieve about 50 columns from a

> table and it seems to stop collecting columns after

> 33.

>

33 is a suspiciously low number.

Why do you think it 'stopped'? Explain exactly how you determined this.

What are the data types of fields 30-34?

Why do you think that the java program is actually getting 50 columns?

Finally in general everything in a computer is limited. However 33/50 would be significantly below normal limits for most resources.

jschella at 2007-7-10 11:47:47 >