my dog learned polymorphism
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
Author

jdbc with mysql

maheshm morem
Greenhorn

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
Marshal

Joined: May 26, 2003
Posts: 32481
    
214

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
Rancher

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.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: jdbc with mysql
 
It's not a secret anymore!