I'm using the standard jdbc-odbc driver for a local Java program to manipulate an MSAccess database. I've set up the connections correctly and I can query information from the DB with no problems. I can also create tables through jdbc with no problems. But whenever I try to INSERT data into a table, the data never actually gets there. JDBC never returns an error, however, and the code runs just fine.
I'm baffled. The Access table is called 'test', and there is only one column called 'name' of type 'Text'. I've found that it doesn't matter whether there's a primary key or not, or what type of column I use, or whether it's auto-numbered or not. Here's the piece of code that's killing me:
I've also tried it with a standard Statement with no luck. Any help please?
I'm baffled. The Access table is called 'test', and there is only one column called 'name' of type 'Text'. I've found that it doesn't matter whether there's a primary key or not, or what type of column I use, or whether it's auto-numbered or not. Here's the piece of code that's killing me:
I've also tried it with a standard Statement with no luck. Any help please?