Hi to all,

when i am inserting the record with this query then following erros is getting displayed, can any one solve my problem.

INSERT INTO PTL_MEM (PROJ_ID, PTL_DTLS_ID, USR_ID, USR_NAME,
USR_TYPE, PTL_NUMBER, USR_PROJ_ID, USR_USR_ID, USR_DEPT,PTL_ACCESS_FLAG, GET_MAIL_FLG, CREATED_BY, CREATED_ON, MODIFIED_BY,MODIFIED_ON, USR_PHONE, USR_EMAIL_ADDR, SR_MAIL_CODE, USR_DIV)
VALUES(?,?,?,?,?,?,?,?,?,?,?,?,GETDATE(),?,GETDATE (),?,?,?,?)


java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.vali dateParameterIndex(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.setO bjectInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.setS tring(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.setString(DelegatingPreparedStatement.java:217)
at com.as.components.protocol.ProtocolFormPopulator.c reateProtocol(ProtocolFormPopulator.java:435)
at com.as.web.actions.protocol.ProtocolFormAction.sav eMembersAction(ProtocolFormAction.java:369)
at com.as.web.actions.protocol.ProtocolFormAction.per form(ProtocolFormAction.java:189)
at com.as.web.framework.ControlServlet.doProcess(Cont rolServlet.java:227)
at com.as.web.framework.ControlServlet.doGet(ControlS ervlet.java:140)
at com.as.web.framework.ControlServlet.doPost(Control Servlet.java:110)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:157)
at com.as.web.framework.SaveFilter.processResponse(Sa veFilter.java:74)
at com.as.web.framework.SaveFilter.doFilter(SaveFilte r.java:64)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invo keInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invo keNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(Co yoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)