• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

General error in JDBC-MS Access

 
sudharma malkas
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 358
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you elaborate your problem?
 
Amit Barot
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic