Invalid Handle Exception!
Background: I have a SQL database created and maintained via MS Access 2003. I use JDBC to connect and interact with this database. So far my program has been able to do everything from querying a table to inserting new rows to deleting others, but has had no luck with updating rows either through the execute()/executeUpdate() methods or the ResulSet updateInt()/UpdateString() methods.
So currently I'm recieving an Invalid Handle error during runtime for this program. I ran a stack trace and the line that gave the error was where I was creating a ResultSet from an executeQuery(). I'm unsure what Invalid Handle means, and am further baffled at this error since I have another method with the EXACT SAME line for the query and it receives no errors. To put it into better veiw I have my main class/main method, and from there I call a few different methods from this other class I have. I call this one method, works fine; I call this other method a little while afterwards and it has the exact same few lines at the beginning as the previously mentioned method. Suddenly I get this Invalid Handle error. Like I said, the error said it's happening when I'm doing ResultSet rs = stmnt.executeQuery("SELECT columns FROM table WHERE column LIKE 'string'");
Please help! Thank you!
