ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From austin solomon <austin.solomon...@gmail.com>
Subject Re: Problem with installing ODBC Driver
Date Thu, 11 Aug 2016 12:12:34 GMT
I  am using Apache ignite 1.7.0-SNAPSHOT version.

My ignite cluster is running in CentOS server and I'm trying to connect to
it through ODBC driver from Windows PC.

My confguration is like below:

<property name="odbcConfiguration">
            <bean
class="org.apache.ignite.configuration.OdbcConfiguration"></bean>
        </property>

        <property name="cacheConfiguration">
            <list>
                <bean
class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="name" value="Person"/>
                    <property name="cacheMode" value="PARTITIONED"/>
                    <property name="atomicityMode" value="TRANSACTIONAL"/>
                    <property name="writeSynchronizationMode"
value="FULL_SYNC"/>
            
                    
                    <property name="typeMetadata">
                        <list>
                            <bean
class="org.apache.ignite.cache.CacheTypeMetadata">
                                <property name="keyType"
value="java.lang.Long"/>
                                <property name="valueType" value="Person"/>
                                <property name="ascendingFields">
                                    <map>
                                        <entry key="orgId"
value="java.lang.Long"/>
                                    </map>
                                </property>
                                <property name="queryFields">
                                    <map>
					<entry key="id" value="java.lang.Integer"/>
                                        <entry key="firstName"
value="java.lang.String"/>
                                        <entry key="lastName"
value="java.lang.String"/>
                                        <entry key="resume"
value="java.lang.String"/>
                                        <entry key="salary"
value="java.lang.Integer"/>
                                    </map>
                                </property>
                            </bean>
                        </list>
                    </property>
                </bean>
                
                <bean
class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="name" value="Organization"/>
                    <property name="cacheMode" value="PARTITIONED"/>
                    <property name="atomicityMode" value="TRANSACTIONAL"/>
                    <property name="writeSynchronizationMode"
value="FULL_SYNC"/>
            
                    
                    <property name="typeMetadata">
                        <list>
                            <bean
class="org.apache.ignite.cache.CacheTypeMetadata">
                                <property name="keyType"
value="java.lang.Long"/>
                                <property name="valueType"
value="Organization"/>
                                <property name="ascendingFields">
                                    <map>
                                        <entry key="name"
value="java.lang.String"/>
                                    </map>
                                </property>
                            </bean>
                        </list>
                    </property>
                </bean>
            </list>
        </property>

My problem here is, I could not able to get the data present in cache that i
have created, In Tableau i can see only the columns.

When i checked the cache using ignitevisorcmd.sh i got the following output:
Time of the snapshot: 08/09/16, 16:52:46
+=====================================================================================================================+
|      Name(@)      |    Mode     | Nodes | Entries (Heap / Off heap) |  
Hits    |  Misses   |   Reads   |  Writes   |
+=====================================================================================================================+
| Organization(@c0) | PARTITIONED | 1     | min: 2 (2 / 0)            | min:
0    | min: 0    | min: 0    | min: 0    |
|                   |             |       | avg: 2.00 (2.00 / 0.00)   | avg:
0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 |
|                   |             |       | max: 2 (2 / 0)            | max:
0    | max: 0    | max: 0    | max: 0    |
+-------------------+-------------+-------+---------------------------+-----------+-----------+-----------+-----------+
| Person(@c1)       | PARTITIONED | 1     | min: 5 (5 / 0)            | min:
0    | min: 0    | min: 0    | min: 0    |
|                   |             |       | avg: 5.00 (5.00 / 0.00)   | avg:
0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 |
|                   |             |       | max: 5 (5 / 0)            | max:
0    | max: 0    | max: 0    | max: 0    |
+---------------------------------------------------------------------------------------------------------------------+


screen shot:

<http://apache-ignite-users.70518.x6.nabble.com/file/n6970/Tableau.png> 
<http://apache-ignite-users.70518.x6.nabble.com/file/n6970/Tablleau2.png> 

Can you please help me what I am missing here.

Thanks



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Problem-with-installing-ODBC-Driver-tp5914p6970.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message