i tried that too
its not working...
thanks
srikanth
-----Original Message-----
From: Gautam Batra [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 07, 1999 11:39 PM
To: [EMAIL PROTECTED]
Subject: Re: while(rs.next())
try rs.getLong()
----- Original Message -----
From: PATIBANDA, SRIKANTH <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 07, 1999 10:32 PM
Subject: Re: while(rs.next())
> 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
>
___________________________________________________________________________
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
