resin的sybase和mysql连接池配置

mysql的
<resource-ref>
  <res-ref-name>jdbc/test</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <init-param driver-name="com.caucho.jdbc.mysql.Driver"/>
  <init-param url="jdbc:mysql_caucho://localhost:3306/test"/>
  <init-param user="sa"/>
  <init-param password=""/>
  <init-param max-connections="20"/>
  <init-param max-idle-time="30"/>
</resource-ref>

sybase的
<resource-ref>
   <res-ref-name>cnews</res-ref-name>
   <res-type>javax.sql.DataSource</res-type>
   <init-param driver-name="com.sybase.jdbc2.jdbc.SybDriver"/>
   <init-param url="jdbc:sybase:Tds:192.168.0.20:4200/mtgdbs?charset=cp936&jconnect_version=2"/>
   <init-param user="sa"/>
   <init-param password=""/>
   <init-param max-connections="20"/>
   <init-param max-idle-time="30"/>
</resource-ref>

Connection conn=DBPool.getPool("cnews").getConnection(); //2
Statement stmt = conn.createStatement();

 

 

直连
String url="jdbc:mysql://localhost:3306/note?useUnicode=true&characterEncoding=UTF-8";
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(url,"sa","");
stmt=con.createStatement();