Java Tip(2)

 

(1)Weblogic JNDI configuration

 

notice:the JNDI Name in Weblogic is very importation. It’s not a set for JNDI,but the JNDI name which in JNDI set.

(2)Remember restart the Weblogic server when u change the Weblogic’s configuration,else ,it should be error when use this configuration in JBuilder.

(3)The steps for connect database through Weblogic:

   1)Set datasource  in Weblogic

   2)Get datasource in program

   3)Connect the datasource

   4)Do SQL operation in Program.

   5)Release all

   Like this:

try {

      // 获得WebLogic ServerJNDI初始上下文信息

      ctx = getInitialContext();

      // 建立数据源对象

      ds = (javax.sql.DataSource)

          //通过JNDI上下文查找JDataStore数据源,如果你是用的Jdatastore

          //ctx.lookup("dsJDataStore");

      //通过JNDI上下文查找Oracle9i数据源

      ctx.lookup("LSIdbSource");

….

//建立连接

      myConn = ds.getConnection();

      // 建立语句对象

      myStatement = myConn.createStatement();

      //建立结果集对象

      //建立JDataStore结果集对象

      //myResultSet = myStatement.executeQuery("SELECT * FROM employee");

      //建立Oracle9i结果集对象

      //myResultSet = myStatement.executeQuery("SELECT * FROM SCOTT.EMP");

      myResultSet = myStatement.executeQuery("SELECT * FROM LSI.TEST");

….

if (myStatement != null) {

          myStatement.close();

        }

        if (myConn != null) {

          myConn.close();

        }