启动Tomcat服务器,打开浏览器,输入http://localhost:8080/admin/
选择Resources-Data sources进入配置数据源界面,选择Data Source Actions ->选择Create New Data Source,进入配置详细信息界面,内容如下:
JNDI Name: jdbc/oracle
Data Source URL: jdbc:oracle:thin:@localhost:1521:orcl
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
User Name: scott
Password: tiger
Max. Active Connections: 4
Max. Idle Connections: 2
Max. Wait for Connection: 5000
Validation Query:
左边导航栏中选择:Tomcat Server --> Service (Catalina) --> Host (localhost) --> Context (/工程名) --> Resources --> Data SourcesLink,在右面页面中下拉列表框中选择 “Create New Data SourcesLink”,
注意:在lookup使用中
jndi-name="java:comp/env/jdbc/oracle"
要加java:comp/env/+JNDI名(一定要这个格式)