| Author |
Beginner problem: MySQL, tomcat, Servlet, connection. Thanks
|
Ken Shamrock
Ranch Hand
Joined: Jan 23, 2002
Posts: 139
|
|
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)
|
Thanks everyone who helped me
|
 |
Dave Vick
Ranch Hand
Joined: May 10, 2001
Posts: 3244
|
|
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 ]
|
Dave
|
 |
Ken Shamrock
Ranch Hand
Joined: Jan 23, 2002
Posts: 139
|
|
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
|
 |
 |
|
|
subject: Beginner problem: MySQL, tomcat, Servlet, connection. Thanks
|
|
|