tomcat连接池配置

 

 tomcat中建立数据库连接池在context.xml

------------------Oracle---------------       

<Resource name="jdbc/oracleds"

                                                 auth="Container"

                                                 type="javax.sql.DataSource"

                                                 MaxActive="100"

                                                 maxIdle="30"

                                                 MaxWait="10000"

                                                 username="scott"

                                                 password="tiger"

                                                 driverClassName="oracle.jdbc.driver.OracleDriver"

                                                 url="jdbc:oracle:thin:@127.0.0.1:1521:ora10" />

                            ------------------Mysql---------------          

                         <Resource name="jdbc/mysqlds"

                                                 auth="Container"

                                                 type="javax.sql.DataSource"

                                                 MaxActive="100"

                                                 maxIdle="30"

                                                 MaxWait="10000"

                                                 username="root"

                                                 password="root"

                                                 driverClassName="com.mysql.jdbc.Driver"

                                                 url="jdbc:mysql://127.0.0.1/myblog" />