Question

嗨，我是tomcat和mysql的新手。

我已经在Ubuntu 9.10中安装了Tomcat和mysql，它们都运行得很好！！

But now I have task of connecting mysql and tomcat. I dont have any idea on this. However I looked some manuals but did not find any luck.

盖伊，请给我一个关于如何将mysql与tomcat连接的分步过程。

顺便说一句，我已经下载了mysql连接器，并将.jar文件复制到$CATALINA_HOME/lib

What else should I do ? Thanks!

@at0mzk This is the steps I followed to install tomcat http://www.linuxnix.com/2010/12/how-to-install-apache-tomcat-on-linuxredhatubuntu.html and I installed mysql server and client using the commands sudo apt-get install mysql-server mysql-client later I downloaded JDBC Driver for MySQL (Connector/J) from http://www.mysql.com/products/connector/ and extrated it and pasted the .jar file in /opt/apache-tomcat-6.0.29/lib ( I dont have $CATALINA_HOME/common/lib) . My questions are 1) Is the connection between tomcat and sql established ? 2) do i need to install mysql-server when I have tomcat server ?

Answer 1

Which manual did you follow when installing? Should follow installation intructions in the Tomcat manual for your version. For example 5.5: http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html#MySQL_DBCP_Example

请注意，手册上写的是$CATALINA_HOME/common/lib，而不是$CATALINA_HOME/lib

Answer 2

“当我有tomcat服务器时，我需要安装mysql服务器吗”

首先，你需要mysql吗？我有很多使用替代数据库的网络应用程序，甚至是嵌入式数据库。运行Tomcat不需要Mysql。

“tomcat和sql之间的连接是否已建立”

其次，单独的web应用程序本身可以直接建立到mysql的连接。

正如at0mzk所指出的，我对设置Tomcat JNDI数据源的过程了解不多，因为我从未这样做过，但我怀疑这再次取决于单个应用程序来寻找该服务并使用它连接到数据库。不过，我可以说，您不一定需要它，这取决于您的应用程序需要什么。

友情链接