Hi Im currently writing a program to index a collection of documents. I read the documents and then put the words/phrases in an arrayList of dataEntry (a special ADT that records the word and occurance). Then i add the word and occurance to a MS ACess database. For some reason sometimes i get a
sun.jdbc.odbc.JdbcOdbcBatchUpdateException: General error
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.emulateExecuteBatch(JdbcOdbcPreparedStatement.java :2163)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeBatchUpdate(JdbcOdbcPreparedStatement.java: 1781)
at sun.jdbc.odbc.JdbcOdbcStatement.executeBatch(JdbcOdbcStatement.java:912)
at indexcreator.DatabaseManager.DataBatch(DatabaseManager.java:76)
at indexcreator.main.main(main.java:62)

but not all the time, i was wondering if maybe some of my words are key words(though it mainly skrews up on phrases) if so how do i fix this and if that is not the problem does anyone have any ideas what it might be.

ps. if i do 1 document at a time I don't get any errors on the first document but 3word phrases and 4 word phrases both create errors on the second document.