To Set Up a JDBC-Based Data Store

1. Set JDBC-related properties in the broker’s instance configuration file.

   The relevant properties are discussed, with examples, in JDBC-Based Persistence Properties and listed in full in Table 17–7. In particular, you must specify a JDBC-based data store by setting the broker’s imq.persist.store property to jdbc.

2. Place a copy of, or a symbolic link to, your JDBC driver’s .jar file in the Message Queue external resource files directory, depending on how Message Queue was installed (see Appendix A, Distribution-Specific Locations of Message Queue Data):

   IPS packages: IMQ_HOME/lib/ext

   
   

   Solaris SVR4 packages: /usr/share/lib/imq/ext

   
   

   Linux RPM packages: /opt/sun/mq/share/lib/ext

   
   

   For example, if you are using HADB on an IPS package-based installation, the following command copies the driver’s .jar file to the appropriate location:

   cp  /opt/SUNWhadb/4/lib/hadbjdbc4.jar  IMQ_HOME/lib/ext
   

   The following command creates a symbolic link instead:

   ln  -s  /opt/SUNWhadb/4/lib/hadbjdbc4.jar  IMQ_HOME/lib/ext
   

3. Create the database schema needed for Message Queue persistence.

   Use the imqdbmgr create all command (for an embedded database) or the imqdbmgr create tbl command (for an external database); see Database Manager Utility.

   1. Change to the directory where the Database Manager utility resides, depending on how Message Queue was installed:

      IPS packages: cd IMQ_HOME/bin

      
      

      Solaris SVR4 packages: cd /usr/bin

      
      

      Linux RPM packages: cd /opt/sun/mq/bin

      
      

   2. Enter the imqdbmgr command:

         
      imqdbmgr create all