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