java.sql.SQLException: Missing IN or OUT parameter at index:: 14

[Sherif Shehab]

Hi all,

i'm getting data from Vector of vectors to insert it in the DB , the problem that i'm facing is this exception : "java.sql.SQLException: Missing IN or OUT parameter at index:: 14 " i checked all the colums that i'm filling all ok .

here is my code

  
int valuesOfPreparedStatement = 14;
		int counterForColums =1;
	outer:	for (int i = 0; i < unmatchedArg.get(0).size(); i++) // unmatchedArg.get(0).size() = 13 

		{
			
			

	inner :	for (int ww = 0; ww < unmatchedArg.size() | i<unmatchedArg.get(0).size(); ww++)// unmatchedArg.get(0).size() = 29 
			{
				if ( ww><unmatchedArg.size())
				{
				
					ss.sqlQuery = "INSERT INTO IVRBCK (?,?,?,?,?,?,?,?,?,?,?,?,?) values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
				
					
					try
					{
						pstmt = bckCon.prepareStatement(ss.sqlQuery);
					}
					catch (SQLException e)
					{
						System.out.println("error in pstmt = bckCon.prepareStatement(ss.sqlQuery);");
						e.printStackTrace();
					} 
						
					System.out.println(" ww "+ ww+ "  "+ "i"+i+ "  "+ unmatchedArg.get(ww).get(i));
					
					// table colums names 
				
					try
					{
						pstmt.setString(1,"SEQUENCE");
						
						pstmt.setString(2,"EXTNO");
						
						pstmt.setString(3,"TRKNO");
						
						pstmt.setString(4,"CIFNO");
						
						pstmt.setString(5,"CALLID");
						
						pstmt.setString(6,"DATELOG");
						
						pstmt.setString(7,"TIMELOG");
						
						pstmt.setString(8,"USERID");
						
						pstmt.setString(9,"MENUID");
						
						pstmt.setString(10,"TIMEEXE");
						
						pstmt.setString(11,"ACCOUNT");
						
						pstmt.setString(12,"CALLERID");
						
						pstmt.setString(13,"COUNTER");
						
					}
					catch (SQLException e)
					{
						System.out.println("error in colum name" );
						e.printStackTrace();
					}
				
					//==================================
				
					
					int dd = valuesOfPreparedStatement;
					String value = unmatchedArg.get(i).get(ww);
					if (counterForColums ><= 13) // to insert as soon as it finishes filling the above 13 columns 
					{

						try // making many "try" to see where exactly the exception was generated 
						{
							pstmt.setString(dd, value);
						}
						catch (SQLException e)
						{
							System.out.println("error in  	pstmt.setString(dd, value);");
							e.printStackTrace();
						}
						dd = valuesOfPreparedStatement++;
						
						counterForColums++;
					}
					else
					{
						dd= valuesOfPreparedStatement=14;
						counterForColums=1;
						try // exception generated here 
						{
							pstmt.executeUpdate();
						}
						catch (SQLException e1)
						{
							System.out.println("error in insert");
							e1.printStackTrace();
						}
					}
					
					
			}
				else
					break;
		}


  

any thing i missed ?

[Campbell Ritchie]

What does the ><= operator do?

How many columns does your table require? You are writing 14 at the beginning and only setting 13. Do you really have a table with 14 columns?

[Sherif Shehab]

Campbell Ritchie wrote:What does the ><= operator do?

How many columns does your table require? You are writing 14 at the beginning and only setting 13. Do you really have a table with 14 columns?

no the operator is errata it is <= , ya you are right they are 13 columns only , the 14 is the number of the ? in the query

 	ss.sqlQuery = "INSERT INTO IVRBCK (?,?,?,?,?,?,?,?,?,?,?,?,?) values(?,?,?,?,?,?,?,?,?,?,?,?,?)";   

to be set here

 pstmt.setString(dd, value);   

[Campbell Ritchie]

You're welcome

[Sherif Shehab]

did you notice anything in my code may cause this exception ?

[Campbell Ritchie]

No, sorry. Are you sure you are getting the correct values in dd? The ++ operator will increment dd 1 too few every time.

[Paul Campbell]

This may help.

http://publib.boulder.ibm.com/infocenter/wasinfo/v4r0/index.jsp?topic=/com.ibm.support.was.doc/html/Java_2_Connectivity_(J2C)/1163246.html

[edit]Add "URL" tags. CR[/edit]