jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes jdbc with mysql 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 "jdbc with mysql" Watch "jdbc with mysql" New topic

jdbc with mysql

maheshm morem

Joined: Sep 23, 2010
Posts: 26
my jsp progrm does not work it gives me error as java.sql.SQLExcption[microsoft] [ODBC Driver Manager] invalid curser state. please help me
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32614

Can you show the code? The most common cause is not calling rs.next(), but it could be something else.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

Why are you getting an ODBC error? You should be using the MySQL Connector-J Driver (avaiolable on the MySQL website) and not the JDBC-ODBC bridge.
jQuery in Action, 3rd edition
subject: jdbc with mysql
It's not a secret anymore!