2 Replies Latest reply on Feb 21, 2003 7:37 AM by mongo79

    MySQL Connection Pool in Jboss 3.0.4_tomcat4.1.12

    lakshmi

      Hi,
      Could anybody tell me how to configure a MySQL database connection pool in JBoss 3.0.4_tomcat-.1.12

      What xml files to modify etc...


      Thanks in advance !

        • 1. Re: MySQL Connection Pool in Jboss 3.0.4_tomcat4.1.12
          vinays

          I have done this for oracle, but shd be same for mysql too.

          1. place yr db driver in <jboss_home>\server\default\lib
          2. copy mssql-service.xml file from <jboss_home>\docs\examples\jca to <jboss_home>\server\default\deploy directory.
          3. make the userid/passwd config in this xml, this also had config for the connection pool.
          4. lookup this datasource from yr code.

          Hope this helps.

          cheers...

          • 2. Re: MySQL Connection Pool in Jboss 3.0.4_tomcat4.1.12
            mongo79

            Hi folks!

            What can I do if I do not want to lookup the datasource in my code?

            I'm using several entity beans. They all grab their data from an oracle-database over my JBoss 3.0.4.
            Now, I got one entity which should grab its data from a MySQL-DataSource.
            The Oracle DataSource is defined as default in server/default/conf/standardjbosscmp-jdbc.xml.
            How can I define a second datasource especially for this one bean?
            How can I tell the bean to use this source then...?

            I tried a few times using a special jbosscmp-jdbc.xml file for this bean, but it doesn't work!

            Please help me! Thanx!