java应用程序JNDI方式使用weblogic连接池的方法

java应用程序JNDI方式使用weblogic连接池的方法

第一步准备工作：首先需要明确一点，要获取weblogic的连接就必须依赖weblogic相关jar，不是网上所说的weblogic.jar，如果你把weblogic.jar配置在你的classpath里面是不够的，因为会报出java类文件找不到的错误诸如［Caused by:

weblogic.security.subject.AbstractSubject

https://www.360docs.net/doc/322620460.html,ng.NoClassDefFoundError: weblogic/security/subject/AbstractSubject］之类的异常。那么我们怎么办呢，其实很简单只要进入到你webloigc_home路径下进入到server/lib目录，并且运行［jdk1.6 命令“java -jar wljarbuilder.jar”；jdk1.5命令“java -jar wljarbuilder.jar -profile wlfullclient5 ”］，拷贝“wlfullclient.jar或者wlfullclient5.jar”到你的classpath环境下；

第二步编码工作：新建一个java工程，新建一个java类，命名为Connector.java；首先我们初始化获取数据库连接的环境，即初始化context;

Hashtable ht=new Hashtable();

ht.put(Context.INITIAL_CONTEXT_FACTORY,INITIAL_CONTEXT_FACTORY);

ht.put(Context.PROVIDER_URL, PROVIDER_URL);

try {

long t1=System.currentTimeMillis();

_context=new InitialContext(ht);

long t2=System.currentTimeMillis();

System.out.println(“initial the context cost:”+(t2-t1)+”millseconds!”);

} catch (NamingException e) {

System.out.println(“initial context failured with Exception:”+e.getMessage());

e.printStackTrace();

}

接下来从context上查找JNDI获取到Datasource对象：javax.sql.DataSource ds=(javax.sql.DataSource)ctx.lookup(JNDI);

再就是从Datasource中得到java.sql.Connection对象了。ds.getConnection();

3 具体的示例代码请参考如下内容，笔者将源码完全贴出：

import java.sql.*;

import java.util.*;

import javax.naming.*;

/**

*

* to get the connections of weblogic connection pool by JNDI
* the required jars include “wlfullclient.jar”,
* I know you will ask me how to get this jar? the following is the answer:
* first you must has installed the weblogic,WL_HOME means the weblogic setup directory.
* (a).Creating a wlfullclient.jar for JDK 1.6 client applications
* ===================================================================
* 1.Change directories to the server/lib directory.
* cd WL_HOME/server/lib
* https://www.360docs.net/doc/322620460.html,e the following command to create wlfullclient.jar in the “server/lib”directory:
* java -jar wljarbuilder.jar
* this may take a few minutes ,just wait!
* 3.You can now copy and bundle the wlfullclient.jar with client applications.
* 4.Add the wlfullclient.jar to the client application’s classpath.
* =================================================================== * (b).Creating a wlfullclient5.jar for JDK 1.5 client applications
* =================================================================== * 1. the same as (a).1
* 2. Use the following command to create wlfullclient.jar in the server/lib directory:
* java -jar wljarbuilder.jar -profile wlfullclient5
* 3. the same as (a).3
* 4. the same as (a).4
* =================================================================== *
*
* 

* @author ubuntu

*

*/

public class Connector {

/**

* the const variable of initial context Factory,this can’t modified!

*/

final static String INITIAL_CONTEXT_FACTORY=”weblogic.jndi.WLInitialContextFactory”;

/**

* the const variable of the t3 provider URl,this need to modified by your own !

*/

final static String PROVIDER_URL= “t3://10.254.0.9:7001″;

/**

* the const variable of the JNDI name ,this need to modified by your own !

*/

final static String JNDI=”jdbc/powererp”;

/**

* the method that get Connecton from weblogic JNDI

* @return the Connection Object

*/

public Connection getConnection(){

Context ctx=null;

Connection con=null;

try{

long t1=System.currentTimeMillis();

ctx=_context;

long t2=System.currentTimeMillis();

//System.out.println(“initial the context cost:”+(t2-t1)+”millseconds!”);

javax.sql.DataSource ds=(javax.sql.DataSource)ctx.lookup(JNDI);

long t3=System.currentTimeMillis();

System.out.println(“get the datasource cost:”+(t3-t2)+”millseconds!”);

con=ds.getConnection();

long t4=System.currentTimeMillis();

System.out.println(“get the connection cost:”+(t4-t3)+”millseconds!”);

e.printStackTrace();

}

return con;

}

static Context _context=null;

static{

Hashtable ht=new Hashtable();

ht.put(Context.INITIAL_CONTEXT_FACTORY,INITIAL_CONTEXT_FACTORY);

ht.put(Context.PROVIDER_URL, PROVIDER_URL);

try {

long t1=System.currentTimeMillis();

_context=new InitialContext(ht);

long t2=System.currentTimeMillis();

System.out.println(“initial the context cost:”+(t2-t1)+”millseconds!”);

} catch (NamingException e) {

System.out.println(“initial context failured with Exception:”+e.getMessage());

e.printStackTrace();

}

}

/**

* the method that test whether the connection is correct got

* @param con

*/

private void testconn(Connection con){

ResultSet rs=null;

Statement stmt=null;

String sql=”select sysdate from dual”;

if(con==null)throw new RuntimeException(“the connection is null.please check!”); try {

stmt=con.prepareStatement(sql);

rs=stmt.executeQuery(sql);

if(rs!=null&&rs.next()){

String sysdate=rs.getString(1);

System.out.println(“the oracle db sysdate is :”+sysdate);

}

} catch (SQLException e) {

e.printStackTrace();

throw new RuntimeException(“the excepiton occured:”+e.getMessage());

}finally{

try{

if(rs!=null)rs.close();

if(stmt!=null)stmt.close();

}

}

}

/**

* test the connection by jndi

*/

private void invokeTestDbConnectionByJndi(){

Connection con=null;

try{

long tstart=System.currentTimeMillis();

con= getConnection();

long tend=System.currentTimeMillis();

System.out.println(“execute the method getConnection() cost:”+(tend-tstart)+”millseconds!”); testconn(con);

}catch(Exception e){

e.printStackTrace();

throw new RuntimeException(“when execute invokeTestDbConnectionByJndi(),”+

“the excepiton occured:”+e.getMessage());

}finally{

try{

if(con!=null)con.close();

}

catch(Exception e){}

}

}

/**

* the main method

* @param args args allow null

*/

public static void main(String[] args) {

Connector cct=new Connector();

cct.invokeTestDbConnectionByJndi();

cct.invokeTestDbConnectionByJndi();

}

//—————-the following his -the test result :———————//

/**

*

* initial the context cost:5666 millseconds!

* get the datasource cost:225 millseconds!

* get the connection cost:968 millseconds!

* execute the method getConnection() cost:1193 millseconds!

* the oracle db sysdate is :2010-08-24 13:31:50.0

* get the datasource cost:4 millseconds!

* get the connection cost:33 millseconds!

* execute the method getConnection() cost:37 millseconds! * the oracle db sysdate is :2010-08-24 13:31:51.0

*

*/

}