tomcat连接数据库配置

编辑：service.xml加入以下内容：

<!-- Global JNDI resources -->
  <GlobalNamingResources>


 <Resource
          name="jdbc/gnavi/update"
          auth="Container"
          type="javax.sql.DataSource"
          username="root"
          password="123456"
          driverClassName="org.postgresql.Driver"
          removeAbandoned="true"
          removeAbandonedTimeout="150"
          logAbandoned="true"
          maxActive="0"
          maxIdle="5"
          maxWait="4000"
          url="jdbc:postgresql://IP:5432/数据库名"/>


 <Resource
          name="jdbc/gnavi/mysql"
          auth="Container"
          type="javax.sql.DataSource"
          username="root"
          password="123456"
          driverClassName="com.mysql.jdbc.Driver"
          removeAbandoned="true"
          removeAbandonedTimeout="50"
          logAbandoned="true"
          maxActive="4"
          maxIdle="2"
          maxWait="-1"
          url="jdbc:mysql://IP:3306/数据库名"/>

 </GlobalNamingResources>