panchmp / sqlsheet

Automatically exported from code.google.com/p/sqlsheet
Other
27 stars 11 forks source link

com.googlecode.sqlsheet.stream.XlsStreamResultSet.getString() <-> net.pcal.sqlsheet.XlsResultSet.getString() #9

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem? Do you have sample xls(x) file?
1. create connection to .xlsx
2. create some statement and execute it
3. depending on the value of "readStreaming" in the connection string you get a 
com.googlecode.sqlsheet.stream.XlsStreamResultSet (true) or a 
net.pcal.sqlsheet.XlsResultSet (false)
4. perform getString() where the undelying cell has numeric value

What is the expected output? What do you see instead?
Both implementations act different. c.g.s.s.XlsStreamResult.getString() results 
in some string representation of the number.
n.p.s.XlsResultSet.getString() thorws a SQLException (type mismatch)

Found that while fixing Issue 7. Now with commit rights should I check in test 
cases that show the problem but breakt the build?

Original issue reported on code.google.com by klaus.hauschild.1984@gmail.com on 27 Apr 2013 at 5:54

GoogleCodeExporter commented 9 years ago
> Now with commit rights should I check in test cases that show the problem but 
breakt the build?
yes please

Original comment by vasilievip on 27 Apr 2013 at 6:03

GoogleCodeExporter commented 9 years ago

Original comment by vasilievip on 27 Apr 2013 at 6:16

GoogleCodeExporter commented 9 years ago
It's in.

Original comment by klaus.hauschild.1984@gmail.com on 27 Apr 2013 at 6:17

GoogleCodeExporter commented 9 years ago
Fixed, please try from trunk

Original comment by vasilievip on 28 Apr 2013 at 12:59