bsalzberg
asked on
Missing IN or OUT parameter at index:: 1
Does anybody know why i am getting this error? It happens when i try to update mulitple records in a for loop. Thanks for any help.
Mon Jul 12 09:49:31 PDT 2004 [http8443-Processor25] [Debug] java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.dbaccess.DBErr or.throwSq lException (DBError.j ava:134)
at oracle.jdbc.dbaccess.DBErr or.throwSq lException (DBError.j ava:179)
at oracle.jdbc.driver.OracleS tatement.c heckBindsI nAndOut(Or acleStatem ent.java:1 951)
at oracle.jdbc.driver.OracleS tatement.d oExecuteWi thTimeout( OracleStat ement.java :2792)
at oracle.jdbc.driver.OracleP reparedSta tement.exe cuteUpdate (OraclePre paredState ment.java: 608)
at com.sdn.database.DBConnect ion.update TTYSource( DBConnecti on.java:29 34)
at com.sdn.server.Controller. doPost(Con troller.ja va:264)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 763)
at javax.servlet.http.HttpSer vlet.servi ce(HttpSer vlet.java: 856)
at org.apache.catalina.core.A pplication FilterChai n.internal DoFilter(A pplication FilterChai n.java:284 )
at org.apache.catalina.core.A pplication FilterChai n.doFilter (Applicati onFilterCh ain.java:2 04)
at org.apache.catalina.core.S tandardWra pperValve. invoke(Sta ndardWrapp erValve.ja va:257)
at org.apache.catalina.core.S tandardVal veContext. invokeNext (StandardV alveContex t.java:151 )
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:567)
at org.apache.catalina.core.S tandardCon textValve. invokeInte rnal(Stand ardContext Valve.java :245)
at org.apache.catalina.core.S tandardCon textValve. invoke(Sta ndardConte xtValve.ja va:199)
at org.apache.catalina.core.S tandardVal veContext. invokeNext (StandardV alveContex t.java:151 )
at org.apache.catalina.authen ticator.Au thenticato rBase.invo ke(Authent icatorBase .java:509)
at org.apache.catalina.core.S tandardVal veContext. invokeNext (StandardV alveContex t.java:149 )
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:567)
at org.apache.catalina.core.S tandardHos tValve.inv oke(Standa rdHostValv e.java:184 )
at org.apache.catalina.core.S tandardVal veContext. invokeNext (StandardV alveContex t.java:151 )
at org.apache.catalina.valves .ErrorRepo rtValve.in voke(Error ReportValv e.java:164 )
at org.apache.catalina.core.S tandardVal veContext. invokeNext (StandardV alveContex t.java:149 )
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:567)
at org.apache.catalina.core.S tandardEng ineValve.i nvoke(Stan dardEngine Valve.java :156)
at org.apache.catalina.core.S tandardVal veContext. invokeNext (StandardV alveContex t.java:151 )
at org.apache.catalina.core.S tandardPip eline.invo ke(Standar dPipeline. java:567)
at org.apache.catalina.core.C ontainerBa se.invoke( ContainerB ase.java:9 72)
at org.apache.coyote.tomcat5. CoyoteAdap ter.servic e(CoyoteAd apter.java :206)
at org.apache.coyote.http11.H ttp11Proce ssor.proce ss(Http11P rocessor.j ava:833)
at org.apache.coyote.http11.H ttp11Proto col$Http11 Connection Handler.pr ocessConne ction(Http 11Protocol .java:732)
at org.apache.tomcat.util.net .TcpWorker Thread.run It(PoolTcp Endpoint.j ava:619)
at org.apache.tomcat.util.thr eads.Threa dPool$Cont rolRunnabl e.run(Thre adPool.jav a:688)
at java.lang.Thread.run(Threa d.java:534 )
Mon Jul 12 09:49:31 PDT 2004 [http8443-Processor25] [Debug] java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.dbaccess.DBErr
at oracle.jdbc.dbaccess.DBErr
at oracle.jdbc.driver.OracleS
at oracle.jdbc.driver.OracleS
at oracle.jdbc.driver.OracleP
at com.sdn.database.DBConnect
at com.sdn.server.Controller.
at javax.servlet.http.HttpSer
at javax.servlet.http.HttpSer
at org.apache.catalina.core.A
at org.apache.catalina.core.A
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.authen
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.valves
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.S
at org.apache.catalina.core.C
at org.apache.coyote.tomcat5.
at org.apache.coyote.http11.H
at org.apache.coyote.http11.H
at org.apache.tomcat.util.net
at org.apache.tomcat.util.thr
at java.lang.Thread.run(Threa
post your source code please
ASKER
I just figured it out. Apparently, when doing batchUpdates, you cant use a PreparedStatement, you have to use just a regular statement. Not really sure why. Thanks for the help anyways!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.