rs.getString question

[tom walters]

data is:
[phone]
and it is stored in oracle as a varchar2(250)
when i pull it out with rs.getString(1) i get -7803 (the result of the math operation) instead of [phone]. i always thought getString() doesn't do any conversions, what is going on?
when i view the data in toad, it is [phone].

[Michael Zalewski]

Originally posted by tom walters:
data is:
[phone]
and it is stored in oracle as a varchar2(250)
when i pull it out with rs.getString(1) i get -7803 (the result of the math operation) instead of [phone]. i always thought getString() doesn't do any conversions, what is going on?
when i view the data in toad, it is [phone].

If you do

  INSERT INTO MyTable( myVarCharColumn)
    VALUES( [phone])

you get exactly this result. Not because it got converted in getString(). Because it got converted on insert.
If you do

  PreparedStatement psInsert = con.prepareStatement(
      "INSERT INTO MyTable( myVarCharColumn)"
    + " VALUES( [phone])"
  );
  psInsert.setString( 1, "[phone]");
  psInsert.executeUpdate();

you will get the string out.
(You are using PreparedStatement to update the database right? If not, you probably should). If you used Statement.execute( String), you probably forgot to put quotes around the [phone].

[tom walters]

it turned out to be a data loading issue, exactly what i am not sure (another team manages the data). the java code was fine and it works now w/ out any changes.