This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
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 REST with Spring (video course) this week in the Spring 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 agree. Here's the link:
subject: database connectivity using java
It's not a secret anymore!