This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
i am not sure whether this is the right forum to ask this. but still, i am dropping my query here -
i have a database procedure that takes 3 input parameters and give one output parameter. this output parameter is being registered (of course before i execute the procedure call ) as -
registerOutParameter(String parameterName, int sqlType)
the sqlType that i am using is Types.INTEGER.
the parameterName is the output of the stored procedure, which in my case is some sort of ID, and i think its too large in magnitude, to be (registered using) / (accomodated into) the Types.INTEGER, and i am getting a Numeric overflow error in the log file.
please help me out
the out parameter is read using getInteger ( dont remember exactly )
i have done a bit of googling for this, and the conclusion was to use getString instead of getInteger.
is there anything more in the Types class that can accomodate larger values (like my id ) ?
thanks in advance !
SCJP 1.4 - 95% [ My Story ] - SCWCD 1.4 - 91% [ My Story ] Performance is a compulsion, not a option, if my existence is to be justified.