Tomcat設定JNDI DataSource

1.在 tomcat\conf\server.xml加入以下內容

<GlobalNamingResources>

    <Resource name="UserDatabase" auth="Container" 

                    type="org.apache.catalina.UserDatabase"

                    description="User database that can be updated and saved"

                    factory="org.apache.catalina.users.MemoryUserDatabaseFactory"

                    pathname="conf/tomcat-users.xml" />

    <Resource name="jdbc/SRMDS" auth="Container"  
                    type="javax.sql.DataSource"

                    maxActive="100" maxIdle="30" maxWait="10000"

                    username="mfcs_admin" password="mfcs_admin"

                    driverClassName="oracle.jdbc.driver.OracleDriver"

                    url="jdbc:oracle:thin:@localhost:1521:SRM"/>

</GlobalNamingResources>

2.在 tomcat\conf\context.xml加入以下內容

<Context>

    <WatchedResource>WEB-INF/web.xml</WatchedResource>

    <ResourceLink name="jdbc/SRMDS" global="jdbc/SRMDS" type="javax.sql.DataSourcer"/>

</Context>

3.JNDIName -> java:comp/env/jdbc/TestDB