no its not even working with getString() method.
i am getting same error.
what else could be?
Thanks
srikanth
-----Original Message-----
From: Randy Belknap [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 07, 1999 11:46 AM
To: [EMAIL PROTECTED]
Subject: Re: while(rs.next())
Can you get it as a String (rs.getString()) then convert to integer?
"PATIBANDA, SRIKANTH" wrote:
>
> Hi
>
> thank you very much for your help.
> Yes you are right problem is not in the rs.next().
> but after long research and debugging , what i found is
> the column type in table is of NUMBER(5). But when i get the type in JAVA
it
> becomes SMALLINT.
>
> As i read the smallint range is of -32768 to 32768
>
> But the value that i am trying to retrieve is greater than (X > 32768).
> Thats the reason i am getting the following error.
>
> "ORA-01455: converting column overflows integer datatype."
>
> I even tried to retrieve using getInt(col) method...still i am getting the
> same error.
> Does any one know how to fetch value from SMALLINT to INTEGER type.
>
> I appreciate very much if anyone can respond to me.
> Thank YOu
> srikanth patibanda
>
> -----Original Message-----
> From: Simon Christian [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 05, 1999 10:34 AM
> To: [EMAIL PROTECTED]
> Subject: Re: while(rs.next())
>
> At a guess from the error message, the problem is not in fact with
> rs.next(),
> but are you attempting to retrieve an int from the ResultSet on a
following
> line? e.g. int id = rs.getInt("id");
>
> If the column you are attempting to retrieve data for is not of integer
> type, it
> could cause an error while converting at this stage. Check carefully.
>
> - simon
>
> "PATIBANDA, SRIKANTH" wrote:
>
> > Hi,
> >
> > I am having some problem with rs.next().
> > I am able to execute the query,
> > statement = connection.createStatement();
> > query = "Select * from XYZ";
> > rs = statement.executeQuery(query);
> >
> > ResultSetMetaData rsmd = rs.getMetaData();
> > numCols = rsmd.getColumnCount();
> >
> > for (i=1; i<=numCols; i++) {
> > out.println("<td><H3>" + rsmd.getColumnLabel(i) + "</H3></td>");
> > }
> >
> > My program is working till here very fine. I was able to display the
> > columnlabel, the coulumn count and etc.
> > The problem come now...in the while loop...
> >
> > while (rs.next()) {
> >
> > Its not that there is no data...there is data in the oracle database.
When
> i
> > do directly from SQL> prompt works fine..with the same query its not
> working
> > with JDBC.
> >
> > At this point iam getting this following error...
> >
> > "ORA-01455: converting column overflows integer datatype."
> >
> > I debugged and i am sure the problem is with rs.next()...
> > Does anyone know about this problem..what could be the solution...
> > I really appreciate anyone help.
> > ThankYou
> > Srikanth Patibanda
> > IT Specialist
> > Entergy Corporation
> > Ph: (W)504-576-5444
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
