1. Create a connection pools in WL, you can test 2, then create a DataSource, and the pool name points to the connection pools just configured, specifying this DataSource's JNDI name as "MySQLPool" 3, establish the client test program package COM. catmiw.testmysql; import javax.naming *;. import javax.sql.DataSource; import java.sql *;. import java.util.Properties; public class MysqlPool {private static Context getInitialContext () throws Exception {String url = "t3 : // localhost: 7001 "; String user = null; String password = null; Properties properties = null; try {properties = new Properties (); properties.put (Context.INITIAL_CONTEXT_FACTORY," weblogic.jndi.WLInitialContextFactory "); properties .put (Context.PROVIDER_URL, url); if (! user = null) {properties.put (Context.SECURITY_PRINCIPAL, user); properties.put (Context.SECURITY_CREDENTIALS, password == null "": password?);} return New InitialContext (Properties);} catch (exception e) {system.out.println ("Unable to connect to WebLogic Server AT " URL); System.out.Println (" Please makess "; throw e;}} public static void main (string args []) throws exception {context ctx = getInitialContext () ; // Get initialization context Object Obj = ctx.lookup ("mysqlpool"); / / Find connection pool Datasource DS = (Datasource) OBJ; // Convert to DataSource Try {Connect = DS.GetConnection (); // In the connection pool, a connection system.out.println ("Success Connect MySQL Connection Pool!"); Statement stmt = connect.createstatement (); ResultSet RS = Stmt.executeQuery ("SELECT * FROT");
