Hi I'm trying to insert values into an access database but whenever I execute my query I get the Error message No ResultSet was produced. I can't work out why this is can someone please point me in the right direction. ere is my code:
...and if you didn't expect any ResultSet, why are you choosing to use a method which returns one? Especially as there are other methods which don't return a ResultSet available in the java.sql.Statement class? Have a read of the JavaDocs for that class and I'm sure you'll spot the more appropriate way of doing this.
Joined: Mar 16, 2005
thanks I used executeUpdate instead and that worked fine but I now have a new problem that I get the error "Too few parameters. Expected 1" even though I have made sure I have the right amount of parameters when I run my constructor. It works fine if I hardcode in the sql Query.