tomcat6.0中配置mysql数据源

:)


在[color=blue]context.xml[/color]的<context>中和[color=blue]server.xml[/color]的<GlobalNamingResources>下添加：

<Resource
 name="jdbc/mysql"
 auth="Container"
 type="javax.sql.DataSource"
 maxActive="100"
 maxIdle="30"
 maxWait="10000"
 username="root" 
 password="123" 
 driverClassName="com.mysql.jdbc.Driver"
 url="jdbc:mysql://localhost:3306/my?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8"/> 

在[color=blue]Hibernate.cfg.xml[/color]中的<session-factory>下添加：

<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.datasource">java:comp/env/jdbc/mysql</property>
<property name="current_session_context_class">thread</property>