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

    JBoss with MySQL

    swats
    swats Jul 13, 2007 4:23 PM

      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.

      • 4156 Views
      • Tags:
        • 1. Re: JBoss with MySQL
          kurtstam
          kurtstam Jul 13, 2007 5:09 PM (in response to swats)

           


          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'


            • Actions
          • 2. Re: JBoss with MySQL
            kurtstam
            kurtstam Jul 13, 2007 5:10 PM (in response to swats)

            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'

              • Actions
            • 3. Re: JBoss with MySQL
              swats
              swats Jul 13, 2007 5:25 PM (in response to swats)

              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>

                • Actions