1 Reply Latest reply on Apr 3, 2002 11:16 PM by davidjencks

    How to get all my JDBC pool at runtime...

    jokit

      Hi...
      Is there any one that could explain me how to get all JDBC pool i have up and running at runtime in my JBOSS.
      My webbserver is set up to run against many Data base... What I want to do is to present all JDBC pools for the user.
      I will then use the selected data base to connect to.

      My jboss.jcml...
      -> Cut...

      G9A
      .
      .
      .


      G9N
      .
      .
      .


      My code ( The "java:/G9A" shall be set at runtime )

      InitialContext ctx = null;
      ctx = new InitialContext();
      DataSource ds = (javax.sql.DataSource) ctx.lookup("java:/G9A");

      Regards

      /Johan