mysql配置jndi数据源_weblogic92配置jndi数据源(mysql)

登录weblogic管控制台http://127.0.0.1:7001/console，Service->Jdbc->DataSources，点击lock&edit，建立数据源，并测试成功。

测试weblogic92配置的jndi数据源的java代码

package com.css.test;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Properties;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.sql.DataSource;

public class TestDS {

/**

* 测试jndi数据源(weblogic集群)

* @param args

* @throws NamingException

* @throws SQLException

*/

public static void main(String[] args) throws NamingException, SQLException {

Properties prop = new Properties();

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

prop.put(Context.PROVIDER_URL, "t3://127.0.0.1:7011,127.0.0.1:7012");

prop.put(Context.SECURITY_PRINCIPAL, "weblogic");

prop.put(Context.SECURITY_CREDENTIALS, "weblogic");

Context context = new InitialContext(prop);

DataSource dataSource = (DataSource) context.lookup("jdbc/testds");

Connection conn = dataSource.getConnection();

PreparedStatement ps = conn.prepareStatement("select * from user_info");

ResultSet rs = ps.executeQuery();

while (rs.next()) {

System.out.println("id is " + rs.getString(1) + "\n" + "name is " + rs.getString(2));

}

rs.close();

ps.close();

conn.close();

context.close();

}

}

0

顶

1

踩

分享到：

2010-04-12 14:01

浏览 1193

评论