(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();
}