View Single Post
  #1   Report Post  
Posted to comp.lang.java.databases,microsoft.public.excel.programming
Aaron Fude Aaron Fude is offline
external usenet poster
 
Posts: 9
Default Reading long strings (with jdbc) from Excel

Hi,

I'm not sure whether this is a jdbc/java problem or an excel problem.
I use RmiJdbc to read from an Excel file as a database. In one of the
columns I have "long" strings (over 255 characters). When I try to
read them through JDBC I only get the first 255 (or 256) characters.

I use result.getString("Description"). But have also tried
result.getCharacterStream("Description") and reading the string from
the stream. In either case, I don't get the entire string.

Thanks,


Aaron Fude