java.sql.SQLException: General error solution

[rajasri]

Sometimes when dealing with the msaccess database you can get this type of error "java.sql.SQLException: General error"
First check whether the driver is loaded that is jdbc:odbc:jdbcodbcDriver,If it is loaded then the Exception java.sql.SQLException: General error is because of data source so follow these steps to solve the error
you have create the datasource in odbcdata source administrator
and select system dsn and select Mirosoft access driver
and select the database

Happy coding.

[Anshniit]

Have you tried to check the Primary key in the database table. I was facing the same issue in one of my applications and the reason was the Primary Key Restriction. The application was trying to update two record having the same values in Primary Key column and the same was causing the GeneralError Issue. Hope this will resolve the issue for whom facing this issue.[/quote]

[mjm]

(01-25-2012 12:34 PM)Anshniit Wrote: In order to view links, you must have to reply to this thread.Have you tried to check the Primary key in the database table. I was facing the same issue in one of my applications and the reason was the Primary Key Restriction. The application was trying to update two record having the same values in Primary Key column and the same was causing the GeneralError Issue. Hope this will resolve the issue for whom facing this issue.

[/quote]

Yep

[shahbaz07dbit]

check your system date......that should match with the present date