when i am trying to insert into a table(using preparedstatement) which is having 150 columns ,at that time i am getting this exception. what is the meaning of this exception?
i am not unable to find out for which column it is creating problem;
java.sql.SQLException: Missing IN or OUT parameter at index:: 135
at oracle.jdbc.dbaccess.DBErr
or.throwSq
lException
(DBError.j
ava:185)
at oracle.jdbc.dbaccess.DBErr
or.throwSq
lException
(DBError.j
ava:227)
at oracle.jdbc.driver.OracleS
tatement.c
heckBindsI
nAndOut(Or
acleStatem
ent.java:1
831)
at oracle.jdbc.driver.OracleS
tatement.d
oExecuteWi
thTimeout(
OracleStat
ement.java
:2431)
at oracle.jdbc.driver.OracleP
reparedSta
tement.exe
cuteUpdate
(OraclePre
paredState
ment.java:
435)
at com.p6.engine.spy.P6Prepar
edStatemen
t.executeU
pdate(P6Pr
eparedStat
ement.java
:124)
at com.evermind.sql.FilterPre
paredState
ment.execu
teUpdate(F
ilterPrepa
redStateme
nt.java:24
0)
at com.evermind.sql.FilterPre
paredState
ment.execu
teUpdate(F
ilterPrepa
redStateme
nt.java:24
0)
at com.evermind.sql.FilterPre
paredState
ment.execu
teUpdate(F
ilterPrepa
redStateme
nt.java:24
0)
at com.evermind.sql.FilterPre
paredState
ment.execu
teUpdate(F
ilterPrepa
redStateme
nt.java:24
0)
at com.foursoft.etrans.common
.correctio
ns.hawb.da
o.HouseDoc
umentCorre
ctionDAO.i
nsertHouse
DocumentMa
ster(House
DocumentCo
rrectionDA
O.java:113
3)
at com.foursoft.etrans.common
.correctio
ns.invoice
.dao.Invoi
ceCorrecti
onDAO.setI
nvoiceHead
er(Invoice
Correction
DAO.java:4
95)
at com.foursoft.etrans.common
.correctio
ns.ejb.sls
.Correctio
nSessionBe
an.generat
eCorrectio
nInvoice(C
orrectionS
essionBean
.java:545)
at com.foursoft.etrans.common
.correctio
ns.ejb.sls
.Correctio
nSessionBe
an.createC
orrectionI
nvoice(Cor
rectionSes
sionBean.j
ava:169)
at CorrectionSession_Stateles
sSessionBe
anWrapper3
8.createCo
rrectionIn
voice(Corr
ectionSess
ion_Statel
essSession
BeanWrappe
r38.java:4
72)
at com.foursoft.etrans.servle
ts.common.
ETFinancia
lCorrectio
nControlle
r.doPost(E
TFinancial
Correction
Controller
.java:2115
)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
760)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
853)
at com.evermind.server.http.R
esourceFil
terChain.d
oFilter(Re
sourceFilt
erChain.ja
va:65)
at com.foursoft.etrans.common
.filter.Cr
edentialFi
lter.doFil
ter(Creden
tialFilter
.java:121)
at com.evermind.server.http.S
ervletRequ
estDispatc
her.invoke
(ServletRe
questDispa
tcher.java
:604)
at com.evermind.server.http.S
ervletRequ
estDispatc
her.forwar
dInternal(
ServletReq
uestDispat
cher.java:
317)
at com.evermind.server.http.H
ttpRequest
Handler.pr
ocessReque
st(HttpReq
uestHandle
r.java:790
)
at com.evermind.server.http.H
ttpRequest
Handler.ru
n(HttpRequ
estHandler
.java:270)
at com.evermind.server.http.H
ttpRequest
Handler.ru
n(HttpRequ
estHandler
.java:112)
at com.evermind.util.Releasab
leResource
PooledExec
utor$MyWor
ker.run(Re
leasableRe
sourcePool
edExecutor
.java:186)
Start Free Trial