Change your first statement to this pstat=con.prepareStatement(“select typeid from users where username=? and password=?”, ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); This way you can move forward and backward, so less things to worry about
That message appears under the following circumstances: you have the Access Database Engine (a.k.a. “ACE”) installed, you create an ODBC DSN for your database connection, and your Java code is running in a JVM (Java Virtual Machine) whose “bit-ness” is different than that of the installed version of ACE. For example, you could have the … Read more
As mentioned in the comments to the question, the JDBC-ODBC Bridge is – as the name indicates – only a mechanism for the JDBC layer to “talk to” the ODBC layer. Even if you had a JDBC-ODBC Bridge on your Mac you would also need to have an implementation of ODBC itself, and an appropriate … Read more
Causes General error Unable to open registry key Temporary (volatile) Ace DSN for process … This is the top-level error message produced by the Access Database Engine (a.k.a. “ACE”) ODBC driver when the current process is unable to open the Access database file for one of the following reasons: Some other process has opened the … Read more
We can still use JDBC-ODBC Bridge in java 8 too, just follow this simple recipe: Download a JDK 7 or JRE 7. Goto JRE\lib folder and find the rt.jar Unzip it (if you have WinRAR or 7zip installed) or you can rename it to rt.zip and unzip it. Copy sun\jdbc and sun\security\action folders out, keep … Read more
For Java 7 you can simply omit the Class.forName() statement as it is not really required. For Java 8 you cannot use the JDBC-ODBC Bridge because it has been removed. You will need to use something like UCanAccess instead. For more information, see Manipulating an Access database from Java without ODBC