import com.inet.pool.FailoverEvent;
import com.inet.pool.FailoverListener;
import com.inet.pool.PoolManager; public Connection connect() {
try
{
Class.forName("com.inet.pool.PoolDriver");
DriverManager.setLogStream(System.out);
conn=DriverManager.getConnection("jdbc:inetpool:inetdae7://210.76.97.179?database=sckt","sa","inpour_123");
}
catch (Exception e) {
System.out.println("naming:" + e.getMessage());
}
return conn;
}resin.conf
<resource-ref>
<res-ref-name>jdbc/fy</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<init-param driver-name="net.sourceforge.jtds.jdbc.Driver"/>
<init-param url="jdbc:jtds:sqlserver://210.76.97.179:1433;DatabaseName=sckt"/>
<init-param user="sa"/>
<init-param password="inpour_123"/>
<init-param max-connections="0"/>
<init-param max-idle-time="30"/>
</resource-ref>
} catch (Exception e) {
System.out.println("naming:" + e.getMessage());
}
import com.inet.pool.FailoverListener;
import com.inet.pool.PoolManager; public Connection connect() {
try
{
Class.forName("com.inet.pool.PoolDriver");
DriverManager.setLogStream(System.out);
conn=DriverManager.getConnection("jdbc:inetpool:inetdae7://210.76.97.179?database=sckt","sa","inpour_123");
}
catch (Exception e) {
System.out.println("naming:" + e.getMessage());
}
return conn;
}resin.conf
<resource-ref>
<res-ref-name>jdbc/fy</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<init-param driver-name="net.sourceforge.jtds.jdbc.Driver"/>
<init-param url="jdbc:jtds:sqlserver://210.76.97.179:1433;DatabaseName=sckt"/>
<init-param user="sa"/>
<init-param password="inpour_123"/>
<init-param max-connections="0"/>
<init-param max-idle-time="30"/>
</resource-ref>
} catch (Exception e) {
System.out.println("naming:" + e.getMessage());
}
解决方案 »
- Java 弹出消息提示后(没有按钮),让程序内所有县城处于等待状态
- 随机取数据
- Hibernate开发方式
- java的一个新学者,请问一下VISUAL JAVA
- weblogic启动报错
- 在线等候!回答后马上给分!
- socket传送,接收文件问题
- 利用JavaMail发送邮件问题??
- home object,ejb object与enterprise bean class的关系?
- 求各位大佬推荐一款7000左右的,适合java开发的笔记本,不打游戏
- 关于struts+hibernate的问题?
- 安装jakarta-tomcat-5.0.29.exe失败,安装的进度条到C:\j2sdk1.4.2\jre\bin\server\jvm.dll 便停止不动了
应该是这个方法 public Connection connect() {
try {
Context env =new InitialContext();
DataSource pool=(DataSource)env.lookup("java:comp/env/jdbc/fy");
if (pool == null)
throw new Exception("jdbc/asales is an unknown DataSource");
conn = pool.getConnection();
} catch (Exception e) {
System.out.println("naming:" + e.getMessage());
}
return conn;
对了,调用resin连接池,还需要将数据库连接强制关闭吗?
就是有connect方法,那么closeconnect方法还需要我写出来后,在处理完数据库业务后,进行强制作释放数据库连接。
还是resin自己会释放不用的数据库连接!
其他没问题了!
import java.util.*;
import java.text.*;
import java.sql.*;
import java.io.*;
import java.lang.*;
import com.microsoft.*;
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;public class Db
{
private java.sql.Connection conn=null; //数据库连接对象
private java.sql.Statement stmt=null; //语句对象
private java.sql.ResultSet rs=null; //结果集对象
//登记JDBC驱动对象
//构造函数 public Db(){//构造函数
//System.getProperties().list(System.out);
}
public Connection connect() {
try {
Context env =new InitialContext();
DataSource pool=(DataSource)env.lookup("java:comp/env/jdbc/fy");
if (pool == null)
throw new Exception("jdbc/asales is an unknown DataSource");
conn = pool.getConnection();
} catch (Exception e) {
System.out.println("naming:" + e.getMessage());
}
return conn; }
public void sqlEdit(String sql){
try{
//创建语句对象
stmt=conn.createStatement();
//执行Sql语句
stmt.execute(sql);
}
catch(SQLException e){
System.err.println("操作错误: "+e.getMessage());
}
} public ResultSet sqlExecute(String sql){
try{
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException e){
System.err.println("查询错误: "+e.getMessage());
}
return rs;
} public void close(){
try {
if (rs != null) {
rs.close();
rs = null;
}
if (stmt != null) {
stmt.close();
stmt = null;
}
if (conn != null) {
conn.close();
conn = null;
}
}
catch(SQLException e){
System.err.println("关闭数据库错误: "+e.getMessage());
}
}
}
最后问问resin连接池稳定吗?