jdbc配置

配置tomcat\conf\server.xml

<?xml version='1.0' encoding='utf-8'?>

<Server port="8005" shutdown="SHUTDOWN">

<Listener className="org.apache.catalina.core.AprLifecycleListener" SSLEngine="on" />
<Listener className="org.apache.catalina.core.JasperListener" />

<Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener" />
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />

<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/oracle" auth="Container" type="javax.sql.DataSource" maxActive="5" maxIdle="4" maxWait="10000" username="arcgis" password="arcgis2013" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.18.11.1:1523:ORCL"/>
</GlobalNamingResources>

<Service name="Catalina">
<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />

<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" />

<Engine name="Catalina" defaultHost="localhost">

<Realm className="org.apache.catalina.realm.LockOutRealm">
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"
resourceName="UserDatabase"/>
</Realm>

<Host name="localhost" appBase="webapps"
unpackWARs="true" autoDeploy="true">

<Context path="/abc" reloadable="true" docBase="E:\Projects\xtyproject\szk\WebRoot" debug="0">
</Context>
<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs"
prefix="localhost_access_log." suffix=".txt"
pattern="%h %l %u %t &quot;%r&quot; %s %b" resolveHosts="false"/>

</Host>
</Engine>
</Service>

</Server>

 网上有说将

<Context path="/abc" reloadable="true" docBase="E:\Projects\xtyproject\szk\WebRoot" debug="0">

<Resource name="jdbc/oracle" auth="Container" type="javax.sql.DataSource" maxActive="5" maxIdle="4" maxWait="10000" username="test" password="test" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.18.11.1:1523:ORCL"/>
</GlobalNamingResources>

</Context>

 

追加到server.xml里的，之前一直以为把这一整段复制到</Server>标签前就可以了。。。结果导致部署到远程服务器后，程序始终不能正确访问数据库。

后来经好朋友大神提点才知道应该向上面红色标记的那样添加。

http://my.oschina.net/adwangxiao/blog/97789有各个标签作用的说明

添加的两端代码解释：

（1）<Context path="/abc" reloadable="true" docBase="E:\Projects\xtyproject\szk\WebRoot" debug="0">
</Context>

这段代码的作用是虚拟路径的映射。docBase如果设置为源码工程的路径，则tomcat\webapps\szk都是可以删掉的。因为直接引用了源码工程。也可设置docBase为编译后的工程(即tomcat\webapps\szk)，如果程序部署到远程服务器的话，就设置为这个。

（2）<Resource name="jdbc/oracle" auth="Container" type="javax.sql.DataSource" maxActive="5" maxIdle="4" maxWait="10000" username="arcgis" password="arcgis2013" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.18.11.1:1523:ORCL"/>
</GlobalNamingResources>

设置jdbc连接。

但是我的程序里如果有jdbc连接了，就不需要设置了！

 

String driver = "oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:oracle:thin:@172.18.11.1:1523:orcl";// idpdb为数据库名称

Connection conn = null;
ResultSet rs = null;
ResultSet rs2=null;
Statement stmt = null;

try {

Class.forName(driver);

conn = DriverManager.getConnection(strUrl, "test", "test");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);

while (rs.next() ) {}

 

}catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}