This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread 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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
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://aspose.com/file-tools
 
subject: Beginner problem: MySQL, tomcat, Servlet, connection. Thanks
 
Similar Threads
Install MySQL for Windows Vista
How to change the encoding ?
What is Connection pool?
Errors in Executing first jdbc program
Tomcat exception