Re: Indexing is disabled for cache

My value is 'Condiments'. How I set this value in query? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Connect-to-SQL-DB-tp11180p11612.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Indexing is disabled for cache

Hi, Please See complete error message Mar 31, 2017 5:01:56 PM org.springframework.context.support.AbstractApplicationContext prepareRefresh INFO: Refreshing org.springframework.context.support.GenericApplicationContext@7561af7c: startup date [Fri Mar 31 17:01:56 IST 2017]; root of context

Re: Indexing is disabled for cache

Yes. I used correct query. Please see my below code. OdbcConnection con1 = new OdbcConnection("DSN=Apache Ignite DSN"); con1.Open(); OdbcCommand cmd1 = new OdbcCommand("select * from Categories", con1); OdbcDataReader dr1 = cmd1.ExecuteReader();

Re: Indexing is disabled for cache

Hi Igor, Thanks for your response. I specified QueryEntity in my configuration file. But I got below error. Could you please help me how I resolve this? Additional information: ERROR [HY000] javax.cache.CacheException: class org.apache.ignite.IgniteException: Failed to parse query: select * from

Indexing is disabled for cache

Hi, I have successfully loaded cache. If I write query to get data, below exception occurred. ERROR [HY000] javax.cache.CacheException: Indexing is disabled for cache: NORTHWND. Use setIndexedTypes or setTypeMetadata methods on CacheConfiguration to enable. So I add indexedTypes property in

Re: Load data to cache

Hi, Yes. Now I clear my configuration is wrong. In my case, how read data from persistent store? can you please explain me in details? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Load-data-to-cache-tp11394p11542.html Sent from the Apache Ignite Users

Re: Load data to cache

Hi, I have SQL Northwind database. I need to create cluster or cache using SQL as persistent store. If I connect any 3rd party client application(.Net C#) through Ignite ODBC driver, need to read data from the cluster or cache. -- View this message in context:

Re: ODBC driver installation error

Hi, I tried to following code to load cache. If I execute the query using ExecuteReader method got below error. How I solve this? class Program { static void Main(string[] args) { InitializeDb(); using (IIgnite ignite = Ignition.Start(@"F:\Visual

Re: Load data to cache

Hi, I have not installed JDBC driver. Is it need to load data from store even I enable ODBC driver in Spring XML file? I don't know whether Cache configuration is correct or not. Can you Please see my Spring XML configuration file? If anything wrong in this, Please let me know.

Re: Load data to cache

Where I add dataSource bean? I mean,need to add in code or Spring XML file? Can you please provide me an example for this? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Load-data-to-cache-tp11394p11504.html Sent from the Apache Ignite Users mailing list

Re: Load data to cache

javax.cache.integration.CacheLoaderException: Failed to load cache: NORTHWND at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.loadCache(CacheAbstractJdbcStore.java:848) at

Re: Load data to cache

Yes I tried. But I got below exception. An unhandled exception of type 'Apache.Ignite.Core.Cache.Store.CacheStoreException' occurred in Apache.Ignite.Core.dll Additional information: Failed to load cache: NORTHWND -- View this message in context:

Re: Load data to cache

SQL version 12.0.2000.8 Ignite version 1.9.0. I am using ODBC driver , not installed JDBC driver. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Load-data-to-cache-tp11394p11496.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Load data to cache

SQL database -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Load-data-to-cache-tp11394p11493.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Load data to cache

Hi, I tried following code to load cache. Could you please correct the code, If It is wrong? IIgnite ignite = Ignition.Start(@"F:\Visual Studio2015\Projects\CreateCluster\CreateCluster\my-file.xml"); var cache = ignite.GetCache("NORTHWND"); object[] arg

Re: Load data to cache

Okay fine. I have NORTHWND sql database. Table name is 'Categories' and their columns are CategoryID, CategoryName, Description. My code is below. But I can't get data. Empty Table only displayed. Can you please say me what I am missing here? using System; using System.Collections.Generic; using

Re: Load data to cache

Hi, This is my ODBC code. Is it possible to create database as mentioned below. OdbcConnection con = new OdbcConnection("DRIVER={Apache Ignite};ADDRESS=localhost:10800;CACHE=Person"); con.Open(); var command = con.CreateCommand(); command.CommandText = "create

Re: Load data to cache

Hi Igor, I shared all my code previously. I don't understand what you ask. ODBC code means? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Load-data-to-cache-tp11394p11460.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Create Ignite database

Hi, How create own database to connect through ignite ODBC driver? Anyone please elaborate this? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Create-Ignite-database-tp11456.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Load data to cache

Hi Igor, First I will explain you what I did. successfully build the solution from the location F:\Apache\apache-ignite-fabric-1.9.0-bin\apache-ignite-fabric-1.9.0-bin\platforms\cpp\project\vs\ignite.sln. Then executed the command Install_amd64 to install ignite driver. After that created DSN

Re: Load data to cache

Hi, I changed my QueryEntity as you suggested. But still my database is empty. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Load-data-to-cache-tp11394p11429.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Load data to cache

Hi Igor, Yes. I set QueryEntry for cache. But I got empty table. My Cache Configuration is: 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="

Re: Load data to cache

Hi, I set cache name as 'Person' in Ignite ODBC driver. How Can I load data in it? I tried following code to load data. But no tables exist, while connecting database through odbc connection. Please explain me how to

Re: Load data to cache

Hi, I am using following code to load data in Ignite cluster. But I got below error. my-file.xml code: http://www.springframework.org/schema/beans; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance; xsi:schemaLocation="http://www.springframework.org/schema/beans

Load data to cache

Hi, I need to read data through ignite ODBC driver. How can I load data to it? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Load-data-to-cache-tp11394.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: error LNK 2001

Hi, Thanks. It worked. I executed following command successfully. But I am not found Apache ignite ODBC driver in ODBC data source administrator (32- bit) window. F:\Ignite\apache-ignite-fabric-1.9.0-bin\apache-ignite-fabric-1.9.0-bin\platforms\cpp\odbc\install>install_x86

Connect sql database through Apache Ignite ODBC driver

Hi, I installed Apache Ignite 64 bit ODBC driver. I have NORTHWIND sql database in my machine. I need to connect sql database through Apache Ignite ODBC driver. How can I implement this? Spring XML file configuration: http://www.springframework.org/schema/beans;

Re: Connection not established

Hi, My Code in app.config file. packages.config file code in class file class Program { static void Main(string[] args) { IIgnite ignite = Ignition.Start(); OdbcConnection con = new

Error: Cannot open include file:'noost/test/unit_test.hpp'

Hi, I tried to build Ignite.sln. But I got Cannot open include file:'noost/test/unit_test.hpp' error. -- View this message in context:

Connection not established

Hi, I tried to establish connection. But following error message displayed. My Code: class Program { static void Main(string[] args) { IIgnite ignite = Ignition.Start(); OdbcConnection con = new OdbcConnection("DRIVER={Apache Ignite};ADDRESS=

Re: Error: Failed to locate: "CL.exe"

Thanks for your information. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Error-Failed-to-locate-CL-exe-tp11222p11240.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: ODBC driver installation error

Hi, Thanks for your reply. I have successfully installed ODBC driver. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/ODBC-driver-installation-error-tp11232p11236.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

ODBC driver installation error

Hi, I tired to following command in command prompt. But I get Access is denied error message. (Before executing command, successfully build all projects in ignite.sln) F:\Ignite\apache-ignite-1.9.0-src\modules\platforms\cpp\odbc\install>install_amd64

Re: Error: Failed to locate: "CL.exe"

Yes I installed. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Error-Failed-to-locate-CL-exe-tp11222p11226.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Error: Failed to locate: "CL.exe"

Hi, I tried to build the Ignite.sln to generate ignite.odbc.dll. But I got following error message. Failed to locate:"CL.exe". The system cannot find the file specified. Where I can download CL.exe? -- View this message in context:

Re: Connect to SQL DB

Thanks for your reply. I tried below code. but I got error. IIgnite ignite = Ignition.Start(); using (var ldr = ignite.GetDataStreamer("myStreamCache")) { for (int i = 0; i < EntryCount; i++) ldr.AddData(i, new Account(i,

Connect to SQL DB

Hi, I need to connect to SQL DB and pull data to cache. (I am using .Net platform) Does anyone share me idea about this? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Connect-to-SQL-DB-tp11180.html Sent from the Apache Ignite Users mailing list archive at

How to form cluster

Hi All, I need to form a cluster for apache ignite database to connect it through ODBC connection. How can I proceed it? Note: I am using C# language -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-form-cluster-tp11177.html Sent from the Apache

Re: Node setup

Hi All, I tried running ignite-web-agent.bat for making connection with web server. But I am getting following error. Error: Could not find or load main class demo Press any key to continue . . . Anyone please give me a solution for this? -- View this message in context:

Re: Read Data using apache ignite

Yes I am using C#. How can I use ignite as a caching layer? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Read-Data-using-apache-ignite-tp11150p11174.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Read Data using apache ignite

I have NORTHWIND database in my local sql server. I need to read NORTHWIND data using apache ignite through ODBC driver. How can I write code for sql server configuration and read data? Here I am using VS2015. Can you please explain me? -- View this message in context:

Re: Read Data using apache ignite

Hi Nikolai, Thanks for your reply. Can I connect using any database in cloud instead of creating cluster? Is it possible? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Read-Data-using-apache-ignite-tp11150p11163.html Sent from the Apache Ignite Users mailing

Read Data using apache ignite

hi All, I have sql database in my machine. Is it possible to read sql database data using apache ignite? If is it possible means how can I achieve this? and what is the purpose of starting node? Thanks, Kavitha M

Node setup

. Please point JAVA_HOME variable to location of JDK 1.7 or JDK 1.8. You can also download latest JDK at http://java.com/download. Is it need to download JDK? Regards, Kavitha M