public static void createConnectionPool() { Context context; try { context = new InitialContext(); Class.forName("org.firebirdsql.jdbc.FBDriver"); ds = (DataSource) context.lookup("java:comp/env/jdbc/PanelTrackDB"); Connection c = ds.getConnection(); } catch (NamingException e) { // TODO Auto-generated catch block errorLogger.error("An Error Occured:", e); e.printStackTrace(); } catch (ClassNotFoundException e) { errorLogger.error("An Error Occured:", e); // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { errorLogger.error("An Error Occured:", e); // TODO Auto-generated catch block e.printStackTrace(); } }
public static Connection obtenerConexion() throws NamingException { Connection conexion = null; try { // Creamos un contexto jndi inicial // Este context no tiene nada que ver con // la etiqueta contexto donde esta el pool // Este context hace referencia un servicio de nombres // naming service Context ctx = new InitialContext(); String nombreDelContextJNDI = "java:comp/env/"; DataSource ds = (DataSource) ctx.lookup(nombreDelContextJNDI + "jdbc/MySqlPoolConections"); conexion = ds.getConnection(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return conexion; }
public static void main(String[] args) { Connection con = null; Statement stat = null; String s; try { Class.forName("oracle.jdbc.driver.OracleDriver"); // con=DriverManager.getConnection("jdbc:oracle:oci8:@oracle9i","scott","tiger"); // // con=DriverManager.getConnection("jdbc:oracle:thin:@saraswati:1521:oracle10g","scott","tiger"); con = DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/XE", "scott", "tiger"); /*Properties p=new Properties(); p.put("user","scott"); p.put("password","tiger");*/ // Driver d=(Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); // Connection con=d.connect("jdbc:odbc:oradsn",p); // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // con=DriverManager.getConnection("jdbc:odbc:namadsn","scott","tiger"); System.out.println("The connection is successful."); } catch (Exception e) { e.printStackTrace(); } try { stat = con.createStatement(); s = "create table student(Rollno int,Name varchar2(50),serName varchar2(50))"; stat.executeUpdate(s); } catch (SQLException e) { e.printStackTrace(); } try { stat = con.createStatement(); s = "insert into student values(1,'Namrata','Marathe')"; stat.executeUpdate(s); s = "insert into student values(2,'Arjun','Marathe')"; stat.executeUpdate(s); s = "insert into student values(3,'Rahul','Marathe')"; stat.executeUpdate(s); } catch (SQLException e) { e.printStackTrace(); } try { stat.close(); } catch (SQLException e) { } System.out.println("create is successful:"); try { stat = con.createStatement(); s = "select * from student"; ResultSet rset = stat.executeQuery(s); while (rset.next()) System.out.println(rset.getInt(1) + " " + rset.getString(2) + " " + rset.getString(3)); } catch (SQLException e) { e.printStackTrace(); } try { stat.close(); } catch (SQLException se) { } }