java.sql.SQLException: Missing IN or OUT parameter at index:: 14 (JDBC and Relational Databases foru

相关文章推荐

性感的小摩托 · oracle如何判断工作日 - CSDN文库· 4 月前 ·

爱健身的充电器 · Solved: RUCKUS Forums ...· 4 月前 ·

冷冷的红金鱼 · 通过Anaconda管理python2和py ...· 10 月前 ·

魁梧的绿茶 · 数据库SQL中having和where的用法 ...· 10 月前 ·

傲视众生的葡萄 · spring data ...· 11 月前 ·

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(?,?,?,?,?,?,?,?,?,?,?,?,?)";
						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 
						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++;
						dd= valuesOfPreparedStatement=14;
						counterForColums=1;
						try // exception generated here 
							pstmt.executeUpdate();
						catch (SQLException e1)
							System.out.println("error in insert");
							e1.printStackTrace();
					break;

any thing i missed ?

Thanks,
Sherif

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 to be set here

Thanks,
Sherif