0 Replies Latest reply on Jun 2, 2003 7:13 AM by peter1

    creating the Pool connection with Oracle 9i +Jboss3.2.1+jdk1

    peter1 Newbie

      Hi All,
      Previously I configured Jboss3.2.1 +jdk1.3 + Oracle 8.1.6+win2k ,then i did following configurations to create the connection pool
      1)I configured the datasource in oracle-ds.xml
      2)I added resource-ref in web.xml
      3)I added resource-ref in jboss-web.xml
      4)I added datasource in standardjaws.xml
      5)class to get a connection from the pool

      String url = "jnp://localhost:1099";
      Properties pros = null;
      pros = new Properties();
      pros.put(Context.INITIAL_CONTEXT_FACTORY,"org.jnp.interfaces.NamingContextFactory");
      pros.put(Context.PROVIDER_URL,url);
      pros.put(Context.URL_PKG_PREFIXES,"org.jboss.naming:org.jnp.interfaces");
      Context ctx = new InitialContext(pros);
      javax.sql.DataSource ref1 = (javax.sql.DataSource)ctx.lookup("java:comp/env/jdbc/sjp1");
      conn = ref1.getConnection();


      Now I need to create the Pool connection with Oracle 9i
      (ie: jboss3.2.1+Jdk1.3+oracle 9i+win2k)

      Can Anyone advise me of the basic steps of creating a connection pool using oracle 9i...

      Many Thanks
      Peter Simpson