Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use Coherence Command Line Tool (query.sh)

Giuliani SanchesSep 29 2016 — edited Oct 4 2016

Hi.

I'm trying to use the tool query.sh to connect to a Coherence Cluster configured in a Weblogic 12.1.3.

But query.sh always create a new cluster as follows:

2016-09-29 18:13:46.200/9.133 Oracle Coherence GE 12.1.3.0.0 <Info> (thread=Cluster, member=n/a): Created a new cluster "defaultCoherenceCluster" with Member(Id=1, Timestamp=2016-09-29 18:13:42.954, Address=xxx.xx.140.12:8092, MachineId=43578, Location=site:,machine:app1t,process:33143,member:querysh, Role=TangosolCoherenceQueryPlus, Edition=Grid Edition, Mode=Development, CpuCount=2, SocketCount=2)

And i can't query my data to analyze.

I have my cache configuration and a tangosol override in the query.sh classpath. What i'm missing ?

coherence-cache-config.xml

<cache-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

              xsi:schemaLocation="http://xmlns.oracle.com/coherence/coherence-cache-config http://xmlns.oracle.com/coherence/coherence-cache-config/1.2/coherence-cache-config.xsd"

              xmlns="http://xmlns.oracle.com/coherence/coherence-cache-config">

  <defaults>

    <scope-name>TransactionalCache</scope-name>

  </defaults>

  <caching-scheme-mapping>

    <cache-mapping>

      <cache-name>cities</cache-name>

      <scheme-name>transactional</scheme-name>

  </cache-mapping>

  </caching-scheme-mapping>

  <caching-schemes>

    <transactional-scheme>

      <scheme-name>transactional</scheme-name>

      <service-name>TransactionalCache</service-name>

      <autostart>true</autostart>

    </transactional-scheme>

  </caching-schemes>

</cache-config>

tangosol-coherence-override.xml

<?xml version='1.0'?>

<!DOCTYPE coherence SYSTEM "coherence.dtd">

<coherence>

   <cluster-config>

      <member-identity>

         <cluster-name system-property="tangosol.coherence.cluster">defaultCoherenceCluster</cluster-name>

         <member-name>querysh</member-name>

      </member-identity>

   </cluster-config>

</coherence>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2016
Added on Sep 29 2016
6 comments
1,066 views