resultSet.getInt() return value on a string containing two ints

Question

I need to parse the value of a database column that generally contains integers, based on the result Set generated from a JDBC call. However, one particular row of the column has two integers in it (ie, "48, 103"). What will be the return value of resultSet.getInt() on that column?

What is the definition of the column in the database - some kind of varchar? — Andrzej Doyle
– Andrzej Doyle, Commented Jul 14, 2011 at 16:02
Eng.Fouad - I'm currently solving a few other problems that are stopping me from being to test it immediately - trying to get ahead of the curve by asking here first. — DaveWeber
– DaveWeber, Commented Jul 14, 2011 at 16:05
How can 2 rows returned by one select statement differ in its number of columns? — home
– home, Commented Jul 14, 2011 at 16:05
The select statement returns one row in particular. However, most rows in the column only contain one number in a string - the row that I need to work with has two numbers separated by a comma. The DBMS that I am using is MySQL — DaveWeber
– DaveWeber, Commented Jul 14, 2011 at 16:22

CoolBeans · Accepted Answer · 2011-07-14 16:06:38Z

6

It will throw an exception.

I think you are taking the wrong approach here. The getXXX() is supposed to match the data type of the table. Is the data type on the table listed as VARCHAR? If that case you should use getString() to get the data and then parse it with the String.spilt(",") if the , exists (you can use String.indexOf() to verify is the comma is there or not).

answered Jul 14, 2011 at 16:06

CoolBeans

20.9k10 gold badges88 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

DaveWeber Over a year ago

This sounds right. Thanks for the feedback - I'm updating some existing code so maybe the getInt worked before when they knew they were only dealing with one value in the column.

CoolBeans Over a year ago

@DaveWeber - you are welcome. Do you have access to see the schema for the table? Validate what the data type is listed there as.

DaveWeber Over a year ago

I should have access (it's a syscolumns table), will try to do so later. Thanks for your help.

Andrzej Doyle · Accepted Answer · 2011-07-14 16:05:14Z

5

You'll almost certainly get a SQLException (or possibly a NumberFormatException). The actual interface just says that the result set will return "the value of the designated column... as an int". The exact details will be implementation-specific, but I doubt you'll get anything sensible from a value of "48, 103".

(Personally I think it's an error if the driver lets you call getInt on that column in any case, even for "sensible" values. A string is not an int, even if it's a string representation of an int, and the conversion should be done manually by the developer.)

answered Jul 14, 2011 at 16:05

Andrzej Doyle

104k33 gold badges191 silver badges231 bronze badges

2 Comments

Jake Roussel Over a year ago

I'd think NumberFormat is more likely, as SQLExceptions only occur on database access error. It's grabbing the value fine, it's just an issue with parsing the number. But I do think you're correct about the getInt part not working on text columns.

DaveWeber Over a year ago

This makes a lot of sense. Thanks for the feedback.

Nathan Hughes · Accepted Answer · 2011-07-14 16:04:24Z

1

I'd expect it to throw an exception. If it does give you a value, it won't be what you want. I'd get the values as strings and parse them, splitting on commas and trimming spaces.

answered Jul 14, 2011 at 16:04

Nathan Hughes

96.7k21 gold badges193 silver badges288 bronze badges

Comments

dplante · Accepted Answer · 2013-03-05 04:29:56Z

0

I believe it's a NumberFormatException.

edited Mar 5, 2013 at 4:29

dplante

2,4513 gold badges21 silver badges27 bronze badges

answered Jul 14, 2011 at 16:05

Jake Roussel

6411 gold badge6 silver badges17 bronze badges

Collectives™ on Stack Overflow

resultSet.getInt() return value on a string containing two ints

4 Answers 4

3 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related