0 Replies Latest reply on Sep 2, 2013 4:48 PM by Jack Higgins

    Infinispan and database connection configuration

    Jack Higgins Newbie

      Hi,

       

      I have a remote standalone Infinispan cache backed by an Oracle database. The problem I have is that when I start infinispan server it sometimes will not connect to the database. No error or warning is shown in the server.log file. I'm using Infinispan version 5.3.0.FINAL.

       

      Has anyone else experienced this problem ? Is there some config I can add to force infinispan to test the connection before it fully starts up ?

       

      I've included my datastore config below (taken from standalone.xml):

       

          <subsystem xmlns="urn:jboss:domain:datasources:1.1">
                  <datasources>
                      <datasource jndi-name="java:jboss/OracleStore" pool-name="oraclepool" enabled="true" jta="true" use-java-context="true" use-ccm="true" spy="true">
                              <connection-url>jdbc:oracle:thin:@host:port/server</connection-url>
                              <driver>oracle_driver</driver>
                              <security>
                                      <user-name>user</user-name>
                                      <password>password</password>
                              </security>
                              <statement>
                                      <prepared-statement-cache-size>100</prepared-statement-cache-size>
                             
                              </statement>
                              <timeout>
                                      <blocking-timeout-millis>5000</blocking-timeout-millis>
                                      <idle-timeout-minutes>60000</idle-timeout-minutes>
                              </timeout>
                      </datasource>
                      <drivers>
                              <driver name="oracle_driver" module="oracle.jdbc">
                                      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
                              </driver>
                      </drivers>
                  </datasources>
              </subsystem>
      
      

       

       

      Thanks,

      Jack