• Post Reply Bookmark Topic Watch Topic
  • New Topic

jdbc with mysql

 
maheshm morem
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 36032
432
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you show the code? The most common cause is not calling rs.next(), but it could be something else.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!