getting SQLException Please help
hi when im running the function
public boolean getRptIds(String condStr, Vector resultVec)
throws SQLException
{
String queryStr = "SELECT rpt_ids FROM " + viewName + "\n";
if ( condStr.length() != 0 )// for total
queryStr += "WHERE " + condStr;
System.out.println("getSubsetRptIds queryStr=");
System.out.println(queryStr);
stmt = atwConn.createStatement();
ResultSet rset = stmt.executeQuery(queryStr);
String rptIds;
while (rset.next ()) {
rptIds = rset.getString(1);
resultVec.addElement(rptIds);
//System.out.println (rptIds);
}
rset.close();
stmt.close();
return (resultVec.size()>0);
}
im getting the following error
java.sql.SQLException: Bigger type length than Maximum
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(Compiled Code)
at oracle.jdbc.dbaccess.DBError.check_error(Compiled Code)
at oracle.jdbc.ttc7.TTCInBuffer.buffer2Value(Compiled Code)
at oracle.jdbc.ttc7.TTCInBuffer.get4Bytes(Compiled Code)
at oracle.jdbc.ttc7.TTIMsg.unmarshalUB4(Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(Compiled Code)
at oracle.jdbc.driver.OracleResultSet.next(Compiled Code)
at Viewer.getRptIds(Compiled Code)
at FetchRptIds.execute(Compiled Code)
at Report.createOnePage(Compiled Code)
at Report.createReport(Compiled Code)
at AtwRS.processReq(Compiled Code)
at AtwRS.doPost(Compiled Code)
at javax.servlet.http.HttpServlet.service(Compiled Code)
at javax.servlet.http.HttpServlet.service(Compiled Code)
at sun.servlet.http.HttpServerHandler.sendResponse(Compiled Code)
at sun.servlet.http.HttpServerHandler.handleConnection(Compiled Code)
at sun.servlet.http.HttpServerHandler.run(Compiled Code)
at java.lang.Thread.run(Compiled Code)
the java version is 1.1.7 and
Oracle7 Server Release 7.3.4.0.1
PL/SQL Release 2.3.4.0.0
