You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by Igor Sapego <is...@gridgain.com> on 2016/06/27 12:06:24 UTC

Re: Problem with installing ODBC Driver

Hello,

Currently, our ODBC driver do not support creating of the system DSN. This
feature is something we are going to add in future, though only for Windows.

Best Regards,
Igor



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

Re: Problem with installing ODBC Driver

Posted by "victor.khodyakov" <vi...@gmail.com>.

I tried but it doesn't work, with local Ignite node started manually nor when
it is stopped.
Ignite log shows nothing, I believe ODBC didn't even start Ignite.

We use Tableau 9.3.3 64-bit
Here is Tableau error message:/
Failed to establish connection with the host.
Unable to connect to the server "Apache Ignite". Check that the server is
running and that you have access privileges to the requested database./

ODBC example bundled with Ignite 1.6 works well. Here are its settings from
registry:/
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Apache Ignite]
"DriverODBCVer"="03.80"
"UsageCount"=dword:00000001
"Driver"="F:\\Ignite\\apache-ignite-fabric-1.6.0-bin\\platforms\\cpp\\project\\vs\\x64\\Release\\ignite.odbc.dll"
/




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

Re: Problem with installing ODBC Driver

Posted by "victor.khodyakov" <vi...@gmail.com>.

It works, thank you!



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

Re: Problem with installing ODBC Driver

Posted by vkulichenko <va...@gmail.com>.

Hi Austin,

You're using deprecated CacheTypeMetadata which probably causing problems.
Looks like the schema is create, but when you insert the data, Ignite does
not associate your objects with this schema. Please try configuring SQL
fields using annotations or QueryEntity [1]. I would recommend the former as
it's much easier.

[1] https://apacheignite.readme.io/docs/sql-queries

-Val



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

Re: Problem with installing ODBC Driver

Posted by austin solomon <au...@gmail.com>.

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.

Re: Problem with installing ODBC Driver

Posted by vkulichenko <va...@gmail.com>.

Hi Austin,

Can you provide more details? What is your configuration? What you're trying
to do exactly and what you get? Are there any exception/errors in the logs?

-Val



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

Re: Problem with installing ODBC Driver

Posted by austin solomon <au...@gmail.com>.

Hi,

Can you give me your XML configuration of ODBC driver, because I am facing
some issue while querying the cache through Tableau.  I can see only the
fields, not the data.

Thanks in advance!! 



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