public static Connection connectPool() throws Exception
{
Connection con = null; try
{
//con = connectDB();
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
// Look up data source
DataSource ds = (DataSource) envCtx.lookup("jdbc/ISS-PSAAppDb");
con = ds.getConnection();
}
catch(SQLException sqe)
{
System.out.println("connectPool() SQL error:" + sqe.getMessage());
sqe.printStackTrace();
throw sqe;
}
/**catch(NamingException ne)
{
System.out.println("connectPool() Naming error:" + ne.getMessage() );
ne.printStackTrace();
throw new SQLException("connectPool() Naming error:" + ne.getMessage());
}**/
return con;
}
xml中的配置:<Context path="/ServiceStar" docBase="ServiceStar" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_examples_log." suffix=".txt" timestamp="true" />
<Environment name="maxExemptions" type="java.lang.Integer" value="15" />
<Parameter name="context.param.name" value="context.param.value" override="false" />
<Resource name="jdbc/ISS-PSAAppDb" auth="SERVLET" type="javax.sql.DataSource" />
<ResourceParams name="jdbc/ISS-PSAAppDb">
<parameter>
<name>user</name>
<value>tester</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:microsoft:sqlserver://server;DatabaseName=ServiceStar</value>
</parameter>
</ResourceParams>
<Resource name="mail/Session" auth="Container" type="javax.mail.Session" />
<ResourceParams name="mail/Session">
<parameter>
<name>mail.smtp.host</name>
<value>mail.isoftstone.com</value>
</parameter>
<parameter>
<name>mail.from</name>
<value>[email protected]</value>
</parameter>
</ResourceParams>
</Context>
{
Connection con = null; try
{
//con = connectDB();
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
// Look up data source
DataSource ds = (DataSource) envCtx.lookup("jdbc/ISS-PSAAppDb");
con = ds.getConnection();
}
catch(SQLException sqe)
{
System.out.println("connectPool() SQL error:" + sqe.getMessage());
sqe.printStackTrace();
throw sqe;
}
/**catch(NamingException ne)
{
System.out.println("connectPool() Naming error:" + ne.getMessage() );
ne.printStackTrace();
throw new SQLException("connectPool() Naming error:" + ne.getMessage());
}**/
return con;
}
xml中的配置:<Context path="/ServiceStar" docBase="ServiceStar" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_examples_log." suffix=".txt" timestamp="true" />
<Environment name="maxExemptions" type="java.lang.Integer" value="15" />
<Parameter name="context.param.name" value="context.param.value" override="false" />
<Resource name="jdbc/ISS-PSAAppDb" auth="SERVLET" type="javax.sql.DataSource" />
<ResourceParams name="jdbc/ISS-PSAAppDb">
<parameter>
<name>user</name>
<value>tester</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:microsoft:sqlserver://server;DatabaseName=ServiceStar</value>
</parameter>
</ResourceParams>
<Resource name="mail/Session" auth="Container" type="javax.mail.Session" />
<ResourceParams name="mail/Session">
<parameter>
<name>mail.smtp.host</name>
<value>mail.isoftstone.com</value>
</parameter>
<parameter>
<name>mail.from</name>
<value>[email protected]</value>
</parameter>
</ResourceParams>
</Context>
解决方案 »
- service层删除节点包含子节点问题
- HttpURLConnection的getResponseCode无限延时
- 鼠标放到控件上会悬浮出提示,但这个提示是一个html文件,求助,如何实现呢,或者有什么好的想法
- 路径问题(咋就没人来回答呢)
- mysql-front 进不去,怎么办
- Myeclipse连接数据库问题
- preparedStatement是否得到sql语句???
- 请教一个jsp的字节数显示问题
- <mis:addressItem detail='homephone'/> 请问detail在这个语句中代表什么意思?
- 页面相关问题
- 请问在给用户发短信时,怎么让用户第一次打开网页时有铃声呢?
- 【关于 Tomcat 上下文相对路径 !!】
ds=(DataSource)ctx.lookup("jdbc/mssql");
应该为:
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/mssql");
这样才对啊。你可以试一下啊。