3 Replies Latest reply on Jul 13, 2007 5:25 PM by S K

    JBoss with MySQL

    S K Newbie

      Can you please explain the complete process of getting MySQL Server working to run the ESB Samples or the link to a documentation which exlains the process.

        • 1. Re: JBoss with MySQL
          Kurt Stam Master

           


          Hi Toby,

          Just add/change the datasource for the juddiDB in the jbossesb.sar, and changes the references to which creation and insert scripts are used in the jbossesb.sar/META-INF/jboss-service.xml. This section:

          Code:

          <mbean code="org.jboss.internal.soa.esb.dependencies.DatabaseInitializer"
          name="jboss.esb:service=JuddiDatabaseInitialization">
          <attribute name="Datasource">java:/juddiDB</attribute>
          <attribute name="ExistsSql">select * from BUSINESS_ENTITY</attribute>
          <attribute name="SqlFiles">
          juddi-sql/hsqldb/create_database.sql,
          juddi-sql/hsqldb/insert_publishers.sql
          </attribute>
          <depends>jboss.jca:service=DataSourceBinding,name=juddiDB</depends>
          </mbean>




          Just change 'hsqldb'to 'mysql'


          • 2. Re: JBoss with MySQL
            Kurt Stam Master

            Hi Toby,

            Just add/change the datasource for the juddiDB in the jbossesb.sar, and changes the references to which creation and insert scripts are used in the jbossesb.sar/META-INF/jboss-service.xml. This section:

            Code:
            
            <mbean code="org.jboss.internal.soa.esb.dependencies.DatabaseInitializer"
             name="jboss.esb:service=JuddiDatabaseInitialization">
             <attribute name="Datasource">java:/juddiDB</attribute>
             <attribute name="ExistsSql">select * from BUSINESS_ENTITY</attribute>
             <attribute name="SqlFiles">
             juddi-sql/hsqldb/create_database.sql,
             juddi-sql/hsqldb/insert_publishers.sql
             </attribute>
             <depends>jboss.jca:service=DataSourceBinding,name=juddiDB</depends>
             </mbean>
            


            Just change 'hsqldb'to 'mysql'

            • 3. Re: JBoss with MySQL
              S K Newbie

              This is the code in my jboss-service.xml
              where do i change ??

              <?xml version="1.0" encoding="UTF-8"?>


              <!-- Starts the listener controler -->

              jbossesb.xml
              jboss.org:service=JBossESBDependencies
              jboss.org:service=JuddiRMI
              jboss.jca:service=DataSourceBinding,name=JBossESBDS

              <loader-repository>
              org.jboss.soa.esb:loader=jbossesb.sar
              </loader-repository>