3 Replies Latest reply on May 2, 2006 2:38 AM by Karl Aschbacher

    BEA Connection Pools

    Karl Aschbacher Newbie

      Hi, we are just evaluating to move from BEA 8.1.x to JBoss 4.0.x.
      On the Weblogic Server we used connection pools to access the database. Up to now I found no way to define connection pools in JBoss 4.0.3.
      Are DataSources the only way to access the database on JBoss?
      If connection pools exist (the way they exist on a BEA server), where are they configured?

        • 1. Re: BEA Connection Pools
          Javid Jamae Newbie

          You can do this in *-ds.xml files in the deploy directory. The default one is hsqldb-ds.xml. It has settings in there for the connection pool size, prepared statement cache, etc.

          • 2. Re: BEA Connection Pools
            Karl Aschbacher Newbie

            Thanks for your answer. But I have one more question.
            How could I access these connection pools?
            Via a DataSource?
            Or also via the DriverManager?
            thanks in advance

            • 3. Re: BEA Connection Pools
              Karl Aschbacher Newbie

              Maybe I`m not making myself clear enough:

              Up to now we created connections using the following statement:
              Connection connection = DriverManager.getConnection("jdbc:weblogic:pool:<pool_name>");
              (This functionality is encapsulated in our own framework, so it can not be changed very easily).

              For JBoss 4.0.3 I only found the following way to create a connection:

              Context ctx = new InitialContext();
              DataSource ds = (DataSource)ctx.lookup("java:<pool_name>");
              Connection con = ds.getConnection();

              So my question is:
              Is there a way to acces a connection pool in JBoss using method number 1?
              thank in advance