HI All,

We are receiving the error
org.apache.ignite.binary.BinaryInvalidTypeException while trying to query
reference data from GridGain DataGrid Cache.

This error is only received while invoking this method from a tool (TIBCO
BusinessWorks 5.x), however, when called using standalone Java Client, the
jar method successfully executes and returns the reference data object.

Is it because we are missing any jar in out classpath ?


Sample Code to Query Cache

public CodingSchemeEntry GetCodingSchemeEntry(String tablename, String
code) {
    logger.info("Input for query is::: tablename::" + tablename + ", code
is ::" + code);
    CodingSchemeEntry codingSchemeEntry = null;
    IgniteCache<String, CodingSchemeEntry> cache =
ignite.cache(CODINGSCHEME_CACHE_NAME);
    SqlFieldsQuery sql = new SqlFieldsQuery("SELECT _Val FROM
CodingSchemeEntry where tableName =? and code =?");
    try {
        QueryCursor<List<?>> cursor = cache.query(sql.setArgs(tablename,
code));
        for (List<?> row : cursor) {
            codingSchemeEntry = (CodingSchemeEntry) row.get(0);
        }
    } catch (Exception e) {
        lastError = e.getMessage();
        System.out.println("Exception while querying cache:::" +
e.getStackTrace());
        System.out.println("Exception while querying cache:::" +
e.getMessage());
    }

    return codingSchemeEntry;
}

*Referred Jars in the tool*

cache-api-1.0.0.jar
commons-codec-1.6.jar
commons-logging-1.1.1.jar
gridgain-core-7.5.1-b1.jar
h2-1.3.175.jar
ignite-core-1.5.1-b1.jar
ignite-indexing-1.5.1-b1.jar
ignite-log4j-1.5.1-b1.jar
ignite-shmem-1.0.0.jar
ignite-spring-1.5.1-b1.jar
JavaAPI.jar
log4j-1.2.17.jar
lucene-core-3.5.0.jar
spring-aop-4.1.0.RELEASE.jar
spring-beans-4.1.0.RELEASE.jar
spring-context-4.1.0.RELEASE.jar
spring-core-4.1.0.RELEASE.jar
spring-expression-4.1.0.RELEASE.jar
spring-jdbc-4.1.0.RELEASE.jar
spring-tx-4.1.0.RELEASE.jar


-- 
Thanks & Regards
Vaibhav Dutt Sharma

Reply via email to