Two Laptop Bag
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

Win a copy of Building Microservices this week in the Design forum!
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: database connectivity using java
It's not a secret anymore!