This is a simple ex from the JAVA TUTORIAL But with my access Database I have only four rows inserted and I should have 5. In fact it's always the last that is missing. Any Idea??, Here is the code!
I must have missed something! Can anyone help me? [ February 28, 2002: Message edited by: Younes Essouabni ]
Younes
By constantly trying one ends up succeeding. Thus: the more one fails the more one has a chance to succeed.
If I add another executeUpdate like this: stmt.executeUpdate("UPDATE COFFEES SET TOTAL=1000 WHERE COF_NAME LIKE 'Colombian'"); I will have my 5 elements but not the update of TOTAL? Any suggestions?
Younes
By constantly trying one ends up succeeding. Thus: the more one fails the more one has a chance to succeed.
This is a common Problem with jdbc ODBC bridge when connecting to Access. For all inserts to take effect, do a dummy select on the table you inserted into after you've completed your inserts. For some reason this gives the database a smack in the face and causes the last entry to be committed.