Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Beginner problem: MySQL, tomcat, Servlet, connection. Thanks

 
Ken Shamrock
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
im a beginner in setting up these things, im using WinXP, tomcat 4. I've just installed MySQL and making database in command line only. Now if I want to make a Servlet to have a connection with MySQL and creating table,updating,etc. What will I need to install in my WinXP? I see there's downloaded file called "MyODBC.zip" on mysql.com, do I need to install? Please would anyone tell me the procedure to get it work. Thanks all.
(PS: I don't want to install Oracle because I think that I can get the db worked with Servlet if I use MySQL instead, correct me if im wrong)
 
Dave Vick
Ranch Hand
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ken
You can use the myODBC to set up an ODBC connection to your database, if you go that route in order to use it with JDBC you'd also need to use the JDBCODBC bridge. Your best bet is to just get a JDBC driver to use.
hope that helps
[ January 28, 2002: Message edited by: Dave Vick ]
 
Ken Shamrock
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I just set the mm.mysql jdbc driver and HAVEN'T install any myODBC on my WindowXP, when I tried run my Servlet, it can insert some data in my database (not tried other command like SELECT yet), so do I success? As you said that i need to install myodbc driver or jdbcodbc driver. Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic