Weblogic 连接池在各种场景的使用

1.spring+hibernate

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">

<property name="jndiName">

<!-- <value>java:comp/env/jdbc/myds</value> -->

<value>myds</value>//jndi名称weblogic11g中的配置

</property>

</bean>

<bean id="sessionFactory"

class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="dataSource">

<ref local="dataSource"/> 

<!-- <value>/com/env/jdbc/myds</value> -->

</property>

<property name="hibernateProperties">

<props>

<prop key="hibernate.show_sql">true</prop>

<prop key="hibernate.format_sql">true</prop>

<!--  <prop key="hibernate.hbm2ddl.auto">create</prop>-->

<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>

</props>

</property>

2.hibernate中单独使用

hibernate.dialect = net.sf.hibernate.dialect.MySQLDialect 

hibernate.connection.datasource=java:comp/env/jdbc/SAMPLEDB 

hibernate.show_sql=true 

3.纯java项目中(不使用框架)

public class Connector {  

  public Connection getConnect(){  

      Context ctx = null;    

      Hashtable ht = new Hashtable();    

      ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");  

      ht.put(Context.PROVIDER_URL,"t3://localhost:7001");  

      Connection conn = null;   

      try {      

     new InitialContext();

       ctx = new InitialContext(ht);new InitialContext(ht);      

      javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup ("myds");      

      conn = ds.getConnection();  

      }catch(Exception e){  

          e.printStackTrace();  

      }  

      return conn;  

  }  

}  

4.web项目中

<%@ page language="java" import="java.util.*,java.sql.*,javax.sql.*,javax.naming.*",%>

<%@ page contentType="text/html;charset=utf-8"%>

<%

try{ 

Context ctx = new InitialContext();

DataSource ds = (DataSource)ctx.lookup("myds"); //这里的参数是JNDI的名称，下面的过程很熟悉不过！

Connection con = ds.getConnection(); 

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery("select sysdate from dual");

while(rs.next())

{

out.println("

" + rs.getString(1)); 

} 

rs.close(); 

stmt.close();

con.close();

}catch(Exception e){ 

e.printStackTrace();

}

%>