General error in JDBC-MS Access

[sudharma malkas]

I am having a serious problem with my database application using MSAccess. After sometime SQLException General error and this error doesnt goes ever after restarting the program once it comes.Is there a solution to this or I have to swithc to another database.

[Amit Barot]

According to your description the problem seems to be blank fields in the database that is the primary key might be blank so try to fill in that key in all the records or delete that row and then try
if this fixes your problem then its well and good
try solving my problem!

[rani bedi]

Can you elaborate your problem?

[Amit Barot]

hi again i just found out the GENERAL ERROR usually comes when u insert duplicate entries in the primary field in the database
ok hope this will solve your problem bye and let me know what if u make it thru
bye .

[sudharma malkas]

I found that problem comes once any field is left empty and the doesnt go away even if I restart the program.
the exception message is
java.sql.SQLException : General Error
The problem goes only when I restart the computer.
I am thinking of putting a blank field check but it is still a serious problem which should have some way out.


[This message has been edited by sudharma malkas (edited June 01, 2001).]