Does anybody see wrong with my update or insert queries? I am using prepared statement?

There are 21 parameters in the update query but you are only setting values for 20 of them UPDATE CRLM2 SET BR=1, LIMITTYPE =2, LIMITMEMBER=3," + "PRODUCT=4,PRODTYPE=5,MTYDATE=6,CCY=7,CREQLIMAMT=8,MRKTLIMAMT=9,EXPDATE=10," + "PRODGROUPID=11,AMT1=12,AMT2=13,DATE1=14,DATE2=15,TEXT1=16,TEXT2=17,LIMITSEQ=18," + "STARTDATE=19,UPDATECOUNTER=20 WHERE LIMITMEMBER = 21.

There are 21 parameters in the update query but you are only setting values for 20 of them. UPDATE CRLM2 SET BR=1, LIMITTYPE =2, LIMITMEMBER=3," + "PRODUCT=4,PRODTYPE=5,MTYDATE=6,CCY=7,CREQLIMAMT=8,MRKTLIMAMT=9,EXPDATE=10," + "PRODGROUPID=11,AMT1=12,AMT2=13,DATE1=14,DATE2=15,TEXT1=16,TEXT2=17,LIMITSEQ=18," + "STARTDATE=19,UPDATECOUNTER=20 WHERE LIMITMEMBER = 21.

With numbers to show how many parameters you actually have. – Vincent Ramdhanie May 20 at 0:02 hahahahaha thx man – aditya86c May 20 at 0:05 but I still see this error MicrosoftSQLServer 2000 Driver for JDBCObject has been closed. – aditya86c May 20 at 0:11.

Vincent is right. Your update query has 21 params and your insert query has 20 params. However in your code you are only setting 20 params for your update query.

LIMITMEMBER is param number 3 and 21.

Does anybody see wrong with my insert statement especially at BR – aditya86c May 20 at 1:16 I am getting this java.sql. SQLException: MicrosoftSQLServer 2000 Driver for JDBCSQLServerIncorrect syntax near 'BR'. – aditya86c May 20 at 1:17.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.