ODBC driver installation error

classic Classic list List threaded Threaded
7 messages Options
kavitha kavitha
Reply | Threaded
Open this post in threaded view
|

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 F:\Ignite\apache-ignite-1.9.0-src\modules\platforms\cpp\project\vs\x64\Debug\ignite.odbc.dll
Installing 64-bit driver: F:\Ignite\apache-ignite-1.9.0-src\modules\platforms\cpp\project\vs\x64\Debug\ignite.odbc.dll
ERROR: Access is denied.
ERROR: Access is denied.
ERROR: Access is denied.
ERROR: Access is denied.
ERROR: Access is denied.
The syntax of the command is incorrect.

Anyone tell me how can I clear these error?
Saif25 Saif25
Reply | Threaded
Open this post in threaded view
|

Re: ODBC driver installation error

CONTENTS DELETED
The author has deleted this message.
kavitha kavitha
Reply | Threaded
Open this post in threaded view
|

Re: ODBC driver installation error

Hi,

 Thanks for your reply. I have successfully installed ODBC driver.

kavitha kavitha
Reply | Threaded
Open this post in threaded view
|

Re: ODBC driver installation error

This post was updated on .
Hi,

While starting node with Spring XML file, I got below error. Anyone Please tell me How I solve this?

SEVERE: Failed to resolve default logging config file: config/java.util.logging.properties
[11:23:55]    __________  ________________
[11:23:55]   /  _/ ___/ |/ /  _/_  __/ __/
[11:23:55]  _/ // (7 7    // /  / / / _/
[11:23:55] /___/\___/_/|_/___/ /_/ /___/
[11:23:55]
[11:23:55] ver. 1.9.0#20170302-sha1:0be92732
[11:23:55] 2017 Copyright(C) Apache Software Foundation
[11:23:55]
[11:23:55] Ignite documentation: http://ignite.apache.org
[11:23:55]
[11:23:55] Quiet mode.
[11:23:55]   ^-- To see **FULL** console log here add -DIGNITE_QUIET=false or "-v" to ignite.{sh|bat}
[11:23:55]
[11:23:55] OS: Windows NT (unknown) 6.2 amd64
[11:23:55] VM information: Java(TM) SE Runtime Environment 1.7.0-b147 Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 21.0-b17
[11:23:55] Initial heap size is 124MB (should be no less than 512MB, use -Xms512m -Xmx512m).
[11:23:55] Configured plugins:
[11:23:55]   ^-- None
[11:23:55]
[11:23:56] Message queue limit is set to 0 which may lead to potential OOMEs when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to message queues growth on sender and receiver sides.
[11:23:56] Security status [authentication=off, tls/ssl=off]
[11:23:56] REST protocols do not start on client node. To start the protocols on client node set '-DIGNITE_REST_START_ON_CLIENT=true' system property.
[11:24:02] Failed to connect to any address from IP finder (will retry to join topology every 2 secs): [/127.0.0.1:47500, /127.0.0.1:47501, /127.0.0.1:47502, /127.0.0.1:47503, /127.0.0.1:47504, /127.0.0.1:47505, /127.0.0.1:47506, /127.0.0.1:47507, /127.0.0.1:47508, /127.0.0.1:47509]

Spring XML configuration:
<?xml version="1.0" encoding="UTF-8"?>

<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="ignite.cfg" class="org.apache.ignite.configuration.IgniteConfiguration">

   
    <property name="odbcConfiguration">
      <bean class="org.apache.ignite.configuration.OdbcConfiguration"/>
    </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="ATOMIC"/>
            <property name="cacheStoreFactory">
                <bean class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
                    <property name="dataSourceBean" value="dsSqlServer"/>
                    <property name="dialect">
                        <bean class="org.apache.ignite.cache.store.jdbc.dialect.SQLServerDialect">
                        </bean>
                    </property>
                    <property name="types">
                        <list>
                            <bean class="org.apache.ignite.cache.store.jdbc.JdbcType">
                                <property name="cacheName" value="Person"/>
                                <property name="keyType" value="java.lang.Integer"/>
                                <property name="valueType" value="model.Person"/>
                                <property name="databaseSchema" value="Person"/>
                                <property name="databaseTable" value="Person"/>
<property name="keyFields">
                                    <list>
                                        <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                            <constructor-arg>
                                                <util:constant static-field="java.sql.Types.INTEGER"/>
                                            </constructor-arg>
                                            <constructor-arg value="ID"/>
                                            <constructor-arg value="int"/>
                                            <constructor-arg value="id"/>
                                        </bean>
                                    </list>
                                </property>
                                <property name="valueFields">
                                    <list>
                                        <bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                            <constructor-arg>
                                                <util:constant static-field="java.sql.Types.INTEGER"/>
                                            </constructor-arg>
                                            <constructor-arg value="ID"/>
                                            <constructor-arg value="int"/>
                                            <constructor-arg value="Id"/>
                                        </bean>
<bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                            <constructor-arg>
                                                <util:constant static-field="java.sql.Types.VARCHAR"/>
                                            </constructor-arg>
                                            <constructor-arg value="NAME"/>
                                            <constructor-arg value="java.lang.String"/>
                                            <constructor-arg value="Name"/></bean>
                                    </list>
                                </property>
                            </bean>
                        </list>
                    </property>
                </bean>
            </property>
<property name="readThrough" value="true"/>
            <property name="writeThrough" value="true"/>

          <property name="queryEntities">
            <list>
              <bean class="org.apache.ignite.cache.QueryEntity">
                <property name="keyType" value="java.lang.Integer"/>
                <property name="valueType" value="Person"/>
<property name="fields">
                            <map>
                                <entry key="Id" value="java.lang.Integer"/>
                                <entry key="Name" value="java.lang.String"/>
                            </map>
                        </property>

              </bean>
            </list>
          </property>
        </bean>
      </list>
    </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.vm.TcpDiscoveryVmIpFinder">
                        <property name="addresses">
                            <list>
                                <value>127.0.0.1:47500..47509</value>
                            </list>
                        </property>
                    </bean>
                </property>
                <property name="socketTimeout" value="300" />
            </bean>
        </property>
            </bean>
        </beans>
Igor Sapego Igor Sapego
Reply | Threaded
Open this post in threaded view
|

Re: ODBC driver installation error

Well, the issue is that logging config file is absent. To solve it you should add a
logging config file. Alternatively, you can enable "log4j" module.

Best Regards,
Igor

On Mon, Mar 27, 2017 at 8:54 AM, kavitha <[hidden email]> wrote:
Hi,

While starting node with Spring XML file, I got below error. Anyone Please
tell me How I solve this?

SEVERE: Failed to resolve default logging config file:
config/java.util.logging.properties
[11:23:55]    __________  ________________
[11:23:55]   /  _/ ___/ |/ /  _/_  __/ __/
[11:23:55]  _/ // (7 7    // /  / / / _/
[11:23:55] /___/\___/_/|_/___/ /_/ /___/
[11:23:55]
[11:23:55] ver. 1.9.0#20170302-sha1:0be92732
[11:23:55] 2017 Copyright(C) Apache Software Foundation
[11:23:55]
[11:23:55] Ignite documentation: http://ignite.apache.org
[11:23:55]
[11:23:55] Quiet mode.
[11:23:55]   ^-- To see **FULL** console log here add -DIGNITE_QUIET=false
or "-v" to ignite.{sh|bat}
[11:23:55]
[11:23:55] OS: Windows NT (unknown) 6.2 amd64
[11:23:55] VM information: Java(TM) SE Runtime Environment 1.7.0-b147 Oracle
Corporation Java HotSpot(TM) 64-Bit Server VM 21.0-b17
[11:23:55] Initial heap size is 124MB (should be no less than 512MB, use
-Xms512m -Xmx512m).
[11:23:55] Configured plugins:
[11:23:55]   ^-- None
[11:23:55]
[11:23:56] Message queue limit is set to 0 which may lead to potential OOMEs
when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to
message queues growth on sender and receiver sides.
[11:23:56] Security status [authentication=off, tls/ssl=off]
[11:23:56] REST protocols do not start on client node. To start the
protocols on client node set '-DIGNITE_REST_START_ON_CLIENT=true' system
property.


Spring XML configuration:
<?xml version="1.0" encoding="UTF-8"?>

<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="ignite.cfg"
class="org.apache.ignite.configuration.IgniteConfiguration">


    <property name="odbcConfiguration">
      <bean class="org.apache.ignite.configuration.OdbcConfiguration"/>
    </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="ATOMIC"/>
            <property name="cacheStoreFactory">
                <bean
class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
                    <property name="dataSourceBean" value="dsSqlServer"/>
                    <property name="dialect">
                        <bean
class="org.apache.ignite.cache.store.jdbc.dialect.SQLServerDialect">
                        </bean>
                    </property>
                    <property name="types">
                        <list>
                            <bean
class="org.apache.ignite.cache.store.jdbc.JdbcType">
                                <property name="cacheName" value="Person"/>
                                <property name="keyType"
value="java.lang.Integer"/>
                                <property name="valueType"
value="model.Person"/>
                                <property name="databaseSchema"
value="Person"/>
                                <property name="databaseTable"
value="Person"/>
<property name="keyFields">
                                    <list>
                                        <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                            <constructor-arg>
                                                <util:constant
static-field="java.sql.Types.INTEGER"/>
                                            </constructor-arg>
                                            <constructor-arg value="ID"/>
                                            <constructor-arg value="int"/>
                                            <constructor-arg value="id"/>
                                        </bean>
                                    </list>
                                </property>
                                <property name="valueFields">
                                    <list>
                                        <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                            <constructor-arg>
                                                <util:constant
static-field="java.sql.Types.INTEGER"/>
                                            </constructor-arg>
                                            <constructor-arg value="ID"/>
                                            <constructor-arg value="int"/>
                                            <constructor-arg value="Id"/>
                                        </bean>
<bean class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                            <constructor-arg>
                                                <util:constant
static-field="java.sql.Types.VARCHAR"/>
                                            </constructor-arg>
                                            <constructor-arg value="NAME"/>
                                            <constructor-arg
value="java.lang.String"/>
                                            <constructor-arg
value="Name"/></bean>
                                    </list>
                                </property>
                            </bean>
                        </list>
                    </property>
                </bean>
            </property>
<property name="readThrough" value="true"/>
            <property name="writeThrough" value="true"/>

          <property name="queryEntities">
            <list>
              <bean class="org.apache.ignite.cache.QueryEntity">
                <property name="keyType" value="java.lang.Integer"/>
                <property name="valueType" value="Person"/>
<property name="fields">
                            <map>
                                <entry key="Id" value="java.lang.Integer"/>
                                <entry key="Name" value="java.lang.String"/>
                            </map>
                        </property>

              </bean>
            </list>
          </property>
        </bean>
      </list>
    </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.vm.TcpDiscoveryVmIpFinder">
                        <property name="addresses">
                            <list>
                                <value>127.0.0.1:47500..47509</value>
                            </list>
                        </property>
                    </bean>
                </property>
                <property name="socketTimeout" value="300" />
            </bean>
        </property>
            </bean>
        </beans>




--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/ODBC-driver-installation-error-tp11232p11454.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

kavitha kavitha
Reply | Threaded
Open this post in threaded view
|

Re: ODBC driver installation error

In reply to this post by kavitha
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 Studio 2015\Projects\LoadData\LoadData\my-file.xml"))
            {
                var cache = ignite.GetOrCreateCache<int, Categories>(new CacheConfiguration
                {
                    Name = "NORTHWND",
                    ReadThrough = true,
                    WriteThrough = true,
                    CacheStoreFactory = new CategoriesCacheStore()  
                });
                cache.LoadCache(null);
                OdbcConnection con = new OdbcConnection("DRIVER={Apache Ignite};ADDRESS=localhost:10800;CACHE=NORTHWND");
                con.Open();
                OdbcCommand cmd = new OdbcCommand("select * from Categories", con);
                OdbcDataReader dr = cmd.ExecuteReader();
                DataTable table = new DataTable();
                table.Load(dr);
            };
           
        }
        private static void InitializeDb()
        {
            using (var ctx = new CategoriesContext())
            {
                // ReSharper disable once AssignNullToNotNullAttribute
                var dataSource = Path.GetFullPath(ctx.Database.Connection.DataSource);
               
                if (ctx.Database.CreateIfNotExists())
                {
                    var cat = new Categories
                    {
                       CategoryID = 1,
                       CategoryName = "Beverages",
                       Description = "Soft drinks, coffees, teas, beers, and ales"
                    };

                    ctx.categories.Add(cat);

                    Console.WriteLine("Database created at {0} with {1} entities.", dataSource, ctx.SaveChanges());
                }
                else
                {
                    Console.WriteLine("Database already exists at {0}.", dataSource);
                }
            }
        }
    }

Spring XML configuration file:
<?xml version="1.0" encoding="UTF-8"?>

<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="ignite.cfg" class="org.apache.ignite.configuration.IgniteConfiguration">

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

            </bean>
        </beans>

Error Message:

INFO: Refreshing org.springframework.context.support.GenericApplicationContext@23d0f70a: startup date [Wed Mar 29 11:37:57 IST 2017]; root of context hierarchy
Mar 29, 2017 11:37:58 AM java.util.logging.LogManager$RootLogger log
SEVERE: Failed to resolve default logging config file: config/java.util.logging.properties
[11:37:58]    __________  ________________
[11:37:58]   /  _/ ___/ |/ /  _/_  __/ __/
[11:37:58]  _/ // (7 7    // /  / / / _/
[11:37:58] /___/\___/_/|_/___/ /_/ /___/
[11:37:58]
[11:37:58] ver. 1.9.0#20170302-sha1:0be92732
[11:37:58] 2017 Copyright(C) Apache Software Foundation
[11:37:58]
[11:37:58] Ignite documentation: http://ignite.apache.org
[11:37:58]
[11:37:58] Quiet mode.
[11:37:58]   ^-- To see **FULL** console log here add -DIGNITE_QUIET=false or "-v" to ignite.{sh|bat}
[11:37:58]
[11:37:58] OS: Windows NT (unknown) 6.2 amd64
[11:37:58] VM information: Java(TM) SE Runtime Environment 1.7.0-b147 Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 21.0-b17
[11:37:58] Initial heap size is 124MB (should be no less than 512MB, use -Xms512m -Xmx512m).
[11:37:58] Configured plugins:
[11:37:58]   ^-- None
[11:37:58]
[11:37:59] Message queue limit is set to 0 which may lead to potential OOMEs when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to message queues growth on sender and receiver sides.
[11:37:59] Security status [authentication=off, tls/ssl=off]
[11:38:01] Performance suggestions for grid  (fix if possible)
[11:38:01] To disable, set -DIGNITE_PERFORMANCE_SUGGESTIONS_DISABLED=true
[11:38:01]   ^-- Switch to the most recent 1.8 JVM version
[11:38:01]   ^-- Specify JVM heap max size (add '-Xmx<size>[g|G|m|M|k|K]' to JVM options)
[11:38:01]   ^-- Set max direct memory size if getting 'OOME: Direct buffer memory' (add '-XX:MaxDirectMemorySize=<size>[g|G|m|M|k|K]' to JVM options)
[11:38:01]   ^-- Disable processing of calls to System.gc() (add '-XX:+DisableExplicitGC' to JVM options)
[11:38:01] Refer to this page for more performance suggestions: https://apacheignite.readme.io/docs/jvm-and-system-tuning
[11:38:01]
[11:38:01] To start Console Management & Monitoring run ignitevisorcmd.{sh|bat}
[11:38:01]
[11:38:01] Ignite node started OK (id=9e5f2a51)
[11:38:01] Topology snapshot [ver=1, servers=1, clients=0, CPUs=4, heap=1.7GB]
CategoriesCacheFactory.LoadCache() called.
CategoriesCacheFactory.LoadCache() called.
Mar 29, 2017 11:38:49 AM org.apache.ignite.logger.java.JavaLogger error
SEVERE: Failed to execute SQL query [reqId=2, req=OdbcQueryExecuteRequest [cacheName=NORTHWND, sqlQry=select * from Categories, args=[]]]
javax.cache.CacheException: Indexing is disabled for cache: NORTHWND. Use setIndexedTypes or setTypeMetadata methods on CacheConfiguration to enable.
        at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.validate(IgniteCacheProxy.java:851)
        at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:714)
        at org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.executeQuery(OdbcRequestHandler.java:213)
        at org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.handle(OdbcRequestHandler.java:108)
        at org.apache.ignite.internal.processors.odbc.OdbcNioListener.onMessage(OdbcNioListener.java:124)
        at org.apache.ignite.internal.processors.odbc.OdbcNioListener.onMessage(OdbcNioListener.java:33)
        at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:274)
        at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:107)
        at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:95)
        at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
        at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:722)
Igor Sapego Igor Sapego
Reply | Threaded
Open this post in threaded view
|

Re: ODBC driver installation error

Hi,
You should add QueryEntity for your cache to your spring configuration file.
See [1] for details.


Best Regards,
Igor

On Wed, Mar 29, 2017 at 9:35 AM, kavitha <[hidden email]> wrote:
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 Studio
2015\Projects\LoadData\LoadData\my-file.xml"))
            {
                var cache = ignite.GetOrCreateCache<int, Categories>(new
CacheConfiguration
                {
                    Name = "NORTHWND",
                    ReadThrough = true,
                    WriteThrough = true,
                    CacheStoreFactory = new CategoriesCacheStore()
                });
                cache.LoadCache(null);
                OdbcConnection con = new OdbcConnection("DRIVER={Apache
Ignite};ADDRESS=localhost:10800;CACHE=NORTHWND");
                con.Open();
                OdbcCommand cmd = new OdbcCommand("select * from
Categories", con);
                OdbcDataReader dr = cmd.ExecuteReader();
                DataTable table = new DataTable();
                table.Load(dr);
            };

        }
        private static void InitializeDb()
        {
            using (var ctx = new CategoriesContext())
            {
                // ReSharper disable once AssignNullToNotNullAttribute
                var dataSource =
Path.GetFullPath(ctx.Database.Connection.DataSource);

                if (ctx.Database.CreateIfNotExists())
                {
                    var cat = new Categories
                    {
                       CategoryID = 1,
                       CategoryName = "Beverages",
                       Description = "Soft drinks, coffees, teas, beers, and
ales"
                    };

                    ctx.categories.Add(cat);

                    Console.WriteLine("Database created at {0} with {1}
entities.", dataSource, ctx.SaveChanges());
                }
                else
                {
                    Console.WriteLine("Database already exists at {0}.",
dataSource);
                }
            }
        }
    }

Spring XML configuration file:
<?xml version="1.0" encoding="UTF-8"?>

<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="ignite.cfg"
class="org.apache.ignite.configuration.IgniteConfiguration">


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

            </bean>
        </beans>

Error Message:

INFO: Refreshing
org.springframework.context.support.GenericApplicationContext@23d0f70a:
startup date [Wed Mar 29 11:37:57 IST 2017]; root of context hierarchy
Mar 29, 2017 11:37:58 AM java.util.logging.LogManager$RootLogger log
SEVERE: Failed to resolve default logging config file:
config/java.util.logging.properties
[11:37:58]    __________  ________________
[11:37:58]   /  _/ ___/ |/ /  _/_  __/ __/
[11:37:58]  _/ // (7 7    // /  / / / _/
[11:37:58] /___/\___/_/|_/___/ /_/ /___/
[11:37:58]
[11:37:58] ver. 1.9.0#20170302-sha1:0be92732
[11:37:58] 2017 Copyright(C) Apache Software Foundation
[11:37:58]
[11:37:58] Ignite documentation: http://ignite.apache.org
[11:37:58]
[11:37:58] Quiet mode.
[11:37:58]   ^-- To see **FULL** console log here add -DIGNITE_QUIET=false
or "-v" to ignite.{sh|bat}
[11:37:58]
[11:37:58] OS: Windows NT (unknown) 6.2 amd64
[11:37:58] VM information: Java(TM) SE Runtime Environment 1.7.0-b147 Oracle
Corporation Java HotSpot(TM) 64-Bit Server VM 21.0-b17
[11:37:58] Initial heap size is 124MB (should be no less than 512MB, use
-Xms512m -Xmx512m).
[11:37:58] Configured plugins:
[11:37:58]   ^-- None
[11:37:58]
[11:37:59] Message queue limit is set to 0 which may lead to potential OOMEs
when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to
message queues growth on sender and receiver sides.
[11:37:59] Security status [authentication=off, tls/ssl=off]
[11:38:01] Performance suggestions for grid  (fix if possible)
[11:38:01] To disable, set -DIGNITE_PERFORMANCE_SUGGESTIONS_DISABLED=true
[11:38:01]   ^-- Switch to the most recent 1.8 JVM version
[11:38:01]   ^-- Specify JVM heap max size (add '-Xmx<size>[g|G|m|M|k|K]' to
JVM options)
[11:38:01]   ^-- Set max direct memory size if getting 'OOME: Direct buffer
memory' (add '-XX:MaxDirectMemorySize=<size>[g|G|m|M|k|K]' to JVM options)
[11:38:01]   ^-- Disable processing of calls to System.gc() (add
'-XX:+DisableExplicitGC' to JVM options)
[11:38:01] Refer to this page for more performance suggestions:
https://apacheignite.readme.io/docs/jvm-and-system-tuning
[11:38:01]
[11:38:01] To start Console Management & Monitoring run
ignitevisorcmd.{sh|bat}
[11:38:01]
[11:38:01] Ignite node started OK (id=9e5f2a51)
[11:38:01] Topology snapshot [ver=1, servers=1, clients=0, CPUs=4,
heap=1.7GB]
CategoriesCacheFactory.LoadCache() called.
CategoriesCacheFactory.LoadCache() called.
Mar 29, 2017 11:38:49 AM org.apache.ignite.logger.java.JavaLogger error
SEVERE: Failed to execute SQL query [reqId=2, req=OdbcQueryExecuteRequest
[cacheName=NORTHWND, sqlQry=select * from Categories, args=[]]]
javax.cache.CacheException: Indexing is disabled for cache: NORTHWND. Use
setIndexedTypes or setTypeMetadata methods on CacheConfiguration to enable.
        at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.validate(IgniteCacheProxy.java:851)
        at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:714)
        at
org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.executeQuery(OdbcRequestHandler.java:213)
        at
org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.handle(OdbcRequestHandler.java:108)
        at
org.apache.ignite.internal.processors.odbc.OdbcNioListener.onMessage(OdbcNioListener.java:124)
        at
org.apache.ignite.internal.processors.odbc.OdbcNioListener.onMessage(OdbcNioListener.java:33)
        at
org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:274)
        at
org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:107)
        at
org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:95)
        at
org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
        at
org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:722)



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/ODBC-driver-installation-error-tp11232p11532.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.