I am using ODBC and JDBC connection to update my sql database the connection if fine and the thing is when i run the code in first time in the loop only one record (not all records but i need to all record go to that sql database)gose to sql database.
Second time it shows the exception "primary key , duplicate entry" but i dont want to add that record again (the first one) but it trys do add the database,
And is it is the category is changed it should be up date the category but it also not happens
Guys this is very much needed project to me pls help me !
Yes our management need a updating system so, the excel sheet must be there. tha's whay i use 2 connections
i can also see there is a mixup in the second result.next() method but i can not correct it
[edited to add code tags] [ November 16, 2006: Message edited by: Jeanne Boyarsky ]