File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes database connectivity using java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "database connectivity using java" Watch "database connectivity using java" New topic

database connectivity using java

bala kan
Ranch Hand

Joined: Aug 20, 2012
Posts: 44

Hi good morning to everyone,

i have done java program using jdbc odbc driver to update the table "table1" in database "update"..

the codes are as

when we execute this file, it gives an error like that

unable to connect
error is java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect..

i have been using ms-access 2007 database, please let me know why this program doesn't work..

Thanks in advance
Vishal Shaw
Ranch Hand

Joined: Aug 09, 2012
Posts: 179
Check out your query

It requires only three columns , but you are trying to put 4 inputs

Programming is about thinking, NOT coding
bala kan
Ranch Hand

Joined: Aug 20, 2012
Posts: 44
thank you very much vishal
I agree. Here's the link:
subject: database connectivity using java
It's not a secret anymore!