Configuring MySQL DataSources
From Java Example Source Code
Contents |
[edit] Overview - Configuring MySQL DataSources
This Java example program shows how to configure MySQL DataSource.
[edit] Java Source Code
- Package: example.mysql
- File: SetupJNDIDataSource.java
package example.mysql; import java.rmi.RemoteException; import java.rmi.registry.LocateRegistry; import java.util.Properties; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.ConnectionPoolDataSource; public class SetupJNDIDataSource { public static void main(String args[]) { if (args.length < 2) { System.out.println("usage: SetupJNDIDataSource username password"); return; } try { startRegistry(); ConnectionPoolDataSource dataSource = createDataSource(args[0], args[1]); InitialContext context = createContext(); context.rebind("HrDS", dataSource); } catch (Exception e) { System.out.println("SetupJNDIDataSource err: " + e.getMessage()); e.printStackTrace(); } } private static void startRegistry() throws RemoteException { LocateRegistry.createRegistry(1099); System.out.println("RMI registry ready."); } private static ConnectionPoolDataSource createDataSource(String username, String password) { MysqlConnectionPoolDataSource dataSource = new MysqlConnectionPoolDataSource(); dataSource.setUser(username); dataSource.setPassword(password); dataSource.setServerName("localhost"); dataSource.setPort(3306); dataSource.setDatabaseName("chapter04_jdbc21"); return dataSource; } private static InitialContext createContext() throws NamingException { Properties env = new Properties(); env.put(Context.INITIAL_CONTEXT_FACTORY, "com.sun.jndi.rmi.registry.RegistryContextFactory"); env.put(Context.PROVIDER_URL, "rmi://localhost:1099"); InitialContext context = new InitialContext(env); return context; } }
[edit] What Result You Can Get
Run the program, you will get:
usage: SetupJNDIDataSource username password
[edit] Required External Libraries and/or Files for this Java Example
Need nothing.
[edit] How to Run this Java Example Program
We recommend running this Java example program with Eclipse.
For assistance in working with Eclipse, please see How to Run Java Program with Eclipse.
It's fairly easy.
[edit] Question & Answer
Any question?
Click edit and post your question or answer here.
