Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to connect databas using odbc in servlet

 
bhavishya goyal
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i m creating simple page and codding of my class is bellow . tell me how i can connect database at running time .i m using ms access as when



i start server and enter user name and password .there is processing but it does not make any respond . tell me what is the problem help me [email removed]
[ September 26, 2008: Message edited by: Bear Bibeault ]
 
Campbell Ritchie
Sheriff
Pie
Posts: 48981
60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to JavaRanch

Please go back and edit your post (pencil-and-paper icon) so as to disable smilies and get rid of the excess spaces round the : and o which appear as .
Please don't ask people to e-mail you.

What are you supposed to pass to the JDBC connection? Is it really "Jdbc: odbc:user" not the user's name? How are you passing a user name and password to the database?
You appear to be calling rs.next() frequently; you call if (rs.next()) which will go to the first row of the ResultSet, then while (rs.next()) which will start from the 2nd row. I think the if is unnecessary, and might cause you to miss the 1st row.


See whether my suggestions are any help; if not, please ask again.
[ September 26, 2008: Message edited by: Campbell Ritchie ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic