This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inserted value too large for column

 
Carty Ellis
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am accessing an Oracle DB via JDBC - Database column defined as num(6,4).
Data coming into the program is a string "010000" which I handle with:
int iscale = NumberUtils.stringToInt(StringUtils.substring((inList.get(i+2)).toString(),5,11));
munitscale = (float) iscale / 10000;
When I System.out.println(munitscale) I get 1.0 for a value. However when I try to insert that value into the database column I get an "ORA-1401 Inserted value too large for column."
I am NOT using a prepared statement - the one place I need prepared I am handling with an escape clause (ts) - TimeStamp.
Any suggestions?
 
Carty Ellis
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Nevermind" as Emily Latella would say -
Whoops. I found it.
 
Rudy Dakota
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Carty,
You might want to share it with those among us that were puzzled by your initial post. Share and learn!
Good riding,
Rudy.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic