This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Servlets and the fly likes Servlets, JDBC and Mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Servlets, JDBC and Mysql" Watch "Servlets, JDBC and Mysql" New topic
Author

Servlets, JDBC and Mysql

Divyajot Ahluwalia
Ranch Hand

Joined: Nov 03, 2000
Posts: 46
Hi guys,
I have started developing a database intensive web application using MSACCESS. I am however told that Mysql and JDBC are a better option. I however do not know how to make the changes?
1) do i need MySql on my comp? if so where can i get it?
2) who creates the database on the server?
3) what is the jdbc driver i need to use?
I am totally confused abt the issue?
Please help
Divyajot
Cynthia Yao
Ranch Hand

Joined: Nov 06, 2000
Posts: 92
1. you can download mysql at http://www.mysql.com/
2. Read there doc, then basically you need to using sql statement to create tables.
3. I am not sure which web server u will use, but there are *.jar file that will help the JDBC.
Divyajot Ahluwalia
Ranch Hand

Joined: Nov 03, 2000
Posts: 46
thanks a ton,
i am using win 98 for development and the server is linux with mysql support
what and where should i download from the mysql site?
thanks
Divyajot
------------------
Cynthia Yao
Ranch Hand

Joined: Nov 06, 2000
Posts: 92
Here is the link for mysql: http://www.mysql.com/downloads/mysql-3.23.html
only the beta version have free for win. so you can download both standard binary and source code.
do search on jdbc in java.sun.com, and check for drivers. Here is one of what i found. try it. http://www.worldserver.com/mm.mysql/
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Servlets, JDBC and Mysql