Austin, Can you run some simple custom SQL query like "select * from Person" and share your results? There should be an error message.
Best Regards, Igor On Tue, Aug 16, 2016 at 5:59 PM, austin solomon <austin.solomon...@gmail.com > wrote: > Hi Igor, > > I have specified "Cache" connection argument while connecting to Ignite's > ODBC, also I can see the column names of the created schema. (Check my > previous post for screen shots) > > I can't able to preview or query the cache. > > Below is my full xml configuration. > > <beans xmlns="http://www.springframework.org/schema/beans"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > xmlns:util="http://www.springframework.org/schema/util"; > xsi:schemaLocation=" > http://www.springframework.org/schema/beans > http://www.springframework.org/schema/beans/spring-beans.xsd > http://www.springframework.org/schema/util > http://www.springframework.org/schema/util/spring-util.xsd";> > > > <bean id="propertyConfigurer" > class="org.springframework.beans.factory.config. > PropertyPlaceholderConfigurer"> > <property name="systemPropertiesModeName" > value="SYSTEM_PROPERTIES_MODE_FALLBACK"/> > <property name="searchSystemEnvironment" value="true"/> > </bean> > > <bean id="ignite.cfg" > class="org.apache.ignite.configuration.IgniteConfiguration"> > > > <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> > > <property name="connectorConfiguration"> > <bean > class="org.apache.ignite.configuration.ConnectorConfiguration"> > <property name="port" value="11211"/> > </bean> > </property> > > > > <property name="discoverySpi"> > <bean > class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi"> > <property name="ipFinder"> > > > > <bean > class="org.apache.ignite.spi.discovery.tcp.ipfinder.multicast. > TcpDiscoveryMulticastIpFinder"> > <property name="addresses"> > <list> > > <value>10.10.1.33:47500..47509</value> > </list> > </property> > </bean> > </property> > </bean> > </property> > </bean> > </beans> > > Thanks, > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Cannot-get-the-data-in-Tableau-tp6876p7104.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >
