Xin các Pro Chỉ Giáo

[DNTmaster]

Các bác có ai cài Sever chạy cùng MySQL không,nếu bác nào cài rồi mà xài chung với MySQL được có thể hướng dẫn sơ qua cho mình được không

[Lovepw]

Tham khảo thêm ở đây nha bạn:[Only registered and activated users can see links. ] chúc bạn thành công!

[DNTmaster]

web bác đưa mình vào hok được bác ơi

[dung059]

web bác đưa mình vào hok được bác ơi

trích lại:

Configuring a MySQL Data source in tomcat 4.1.31


This article tells how to configure a MySQL data source in Tomcat 4.1 server. This article assumes that you have installed the proper versions of MySQL and tomcat. Here we assume that you have installed Tomcat to C:\Tomcat. The name of web application that we are going to configure is Test. The JNDI name used for configuring the data source id jdbc/Test.

System Requirements
Apache tomcat 4.1.31
MySQL
Ensure that you have the following files in your lib folder.
commons-collections.jar
commons-dbcp-xx.jar
commons-logging-api.jar
commons-pool-xx.jar

naming-common.jar

naming-factory.jar

naming-resources.jar


Download and Install drivers
Download the MySQL 3.12 JDBC driver from [Only registered and activated users can see links. ]
Unpack the file you have downloaded.
Copy mysql-connector-java-xxxxx.jar file into the common/lib directory of your Tomcat installation directory. Not to your web application's lib directory.


Shut down Tomcat
Run bin/shutdown.sh or bin/shutdown.bat to shut down Tomcat.

Edit server.xml
Edit the conf/server.xml file in your Tomcat installation.
Find the lines starting with <Host ...>
Directly after this tag add these lines


<Context className="org.apache.catalina.core.StandardContex t" cachingAllowed="false" charsetMapperClass="org.apache.catalina.util.Chars etMapper" cookies="true" crossContext="false" debug="0" docBase="C:\Tomcat\webapps\Test" mapperClass="org.apache.catalina.core.StandardCont extMapper" path="/Test" privileged="false" reloadable="true" swallowOutput="false" useNaming="true" workDir="work\Standalone\localhost\Test" wrapperClass="org.apache.catalina.core.StandardWra pper">

<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_test_log." suffix=".txt" timestamp="true"/>

<Resource auth="Container" description="Tomcat-MySQL Test" name="jdbc/Test" scope="Shareable" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/Test">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFact ory</value>
</parameter>

<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>

<parameter>
<name>maxIdle</name>
<value>30000</value>
</parameter>

<parameter>
<name>maxWait</name>
<value>100</value>
</parameter>

<parameter>
<name>username</name>
<value>root</value>
</parameter>

<parameter>
<name>password</name>
<value>*********</value>
</parameter>

<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>

<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/testdb?autoReconnect=true</value>
</parameter>

</ResourceParams>
</Context>



Where maxActive is the maximum number of database connections in pool. Setting this value to zero means no limit. maxIdle is the maximum number of idle connections in pool. maxWait is the maximum time to wait for a database connection to become available in ms, An Exception is thrown if this timeout is exceeded. A value -1 means waiting indefinitely. username and password is the username and password to connect to MySQL database. url is the JDBC connection URL. Replace the values with the correct parameters to connect to database.

Configure web application (web.xml configuration).
Edit Test/WEB-INF/web.xml. Add the following lines just before </web-app>


<resource-ref>
<description>Tomcat- MySQL Test</description>
<res-ref-name>jdbc/Test</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>


Test Code
Create a jsp file to test our database connection.

javax.naming.Context ctx = new javax.naming.InitialContext();
javax.sql.DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/Test");
java.sql.Connection con = ds.getConnection();

out.println("Successfully connected to MySQL Database.");


Restart Tomcat
Run bin/startup.sh or bin/startup.bat to start Tomcat with the new settings.


Now you can execute your code.

Note: When starting Tomcat, if your console just vanishing away, make sure that you don't have a context with the name 'Test' already defined. If you are getting a ServletException 'javax.servlet.ServletException: Cannot create JDBC driver of class '' for connect URL 'null', cause: No suitable driver', please recheck your server.xml. Still if you are unable to connect to the database, please contact us indicating the error messages you are getting.