This week's giveaways are in the MongoDB and Jobs Discussion forums.
We're giving away four copies of Mongo DB Applied Patterns and 4 resume reviews from Five Year Itch and have the authors/reps on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Beginner problem: MySQL, tomcat, Servlet, connection. Thanks Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Mongo DB Applied Patterns this week in the MongoDB forum
or a resume review from Five Year Itch in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Beginner problem: MySQL, tomcat, Servlet, connection. Thanks" Watch "Beginner problem: MySQL, tomcat, Servlet, connection. Thanks" New topic
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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Beginner problem: MySQL, tomcat, Servlet, connection. Thanks
 
Similar Threads
How to change the encoding ?
Install MySQL for Windows Vista
Tomcat exception
Errors in Executing first jdbc program
What is Connection pool?