Error Numeric Overflow-oracle

[archana gangaiah]

I'm using oracle 10g.

I am trying to get the sum of count of a column based on some collection column which is passed at run time using preparedStatement.
here is my code. The query works fine in sqldeveloper.

	
	public int publishCcollectionCountOfRelationship(List<String> collections) 
	{int temp=0;
		List<Integer> count= new ArrayList<Integer>();
		List<Date> date= new ArrayList<Date>();
		List<String> collection1= new ArrayList<String>();
		try{
		Driver  d1 = (Driver)Class.forName(DBDRIVER).newInstance();
		DriverManager.registerDriver(d1);
     	Connection conn = DriverManager.getConnection(URI, USER, PASSWORD);
     	ResultSet resultSets =null;
     	PreparedStatement pstmt;
     	
     	     	String query =" select sum(rel_count) from erd_workflow.PUBLISH_FILE_TRACKER p, erd_workflow.ltc_load_tracker l where p.collection= ? "
+" and  l.received_date = '01-jun-11' ";
     	
     	System.out.println("query :"+query);
     		for(String collection: collections){
			
				pstmt= conn.prepareStatement(query);
				pstmt.setString(1 , collection);
				System.out.println("collction"+collection);
				resultSets = pstmt.executeQuery();
				if(resultSets.next())
				{
					System.out.println("collection1 :"+resultSets.getInt(1) );
				count.add(resultSets.getInt(1));
				collection1.add(resultSets.getString(2));
				System.out.println("collection1 :" );
				

								}
			}
		}
		catch(Exception e){
			System.out.println("Error "+ e.getMessage());
		}
		
		
		for(int total:count){
			temp=total+temp;
		}
		
		System.out.println("RlationShip1 Count basede on document  "+ temp);
		return temp;
	}

please help me....Thnks in adv

[archana gangaiah]

Actually, I was trying to insert too big value for that column's datatype scale....:-)

[Jan Cumps]

Can you give us the complete error message?

And this line of code: collection1.add(resultSets.getString(2));
You select field 2 from the query, but the statement returns one field.

[archana gangaiah]

I forgot to comment that line while posting ... It is working..... Thanks for pointing out