Hi,
I am using Servlets, JDBC, Oracle Database. I can retrieve the data for some
conditions but for some other conditions i am getting this weird error.
SQLState: 22003
Message: [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01455: converting
column overflows integer datatype.
Does anyone got this error before. Below i am giving my code.
rs = statement.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
int numCols = rsmd.getColumnCount();
while (rs.next()) {
out.println("<tr>");
for (i=1; i<=numCols; i++) {
out.println("<td>" + rs.getString(i)+"</td>");
}
}
I appreciate anyone who can solve my problem.
Thanks
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