InsightEdge JDBC Driver code throwing exception for object not found

Description

I am trying JDBC example given in the documentation here.
https://docs.gigaspaces.com/latest/dev-java/sql-driver.html

Started insightedge on local and use same example program to run and it gives following exception.

2020-01-10 22:25:10,056 INFO [com.gigaspaces.container] - Starting space...

GigaSpaces XAP 14.5.0
Home: C:\gigaspaces-insightedge-enterprise-14.5.0\tools\
Lookup Groups: xap-14.5.0
Lookup Locators:
Java:
Java Runtime: Java(TM) SE Runtime Environment 1.8.0_191-b12 (Oracle Corporation)
Java VM: Java HotSpot(TM) 64-Bit Server VM 25.191-b12 (Oracle Corporation)
Java Home: C:\Program Files\Java\jdk1.8.0_191\jre
Memory: Currently used 45MB, Current heap size 166MB, Max heap size 3791MB
Operating System: Windows 10 [version=10.0, architecture=amd64, processors=4]
Process Id: 16856
Network:
Local Host: [conf-room-PC/10.0.75.1]
eth3: Hyper-V Virtual Ethernet Adapter #2 [IP addresses: 10.0.75.1 | fe80:0:0:0:f007:d406:f988:be06%eth3]
*************************************************************************************************************
2020-01-10 22:25:10,144 INFO [com.sun.jini.reggie.GigaRegistrar] - Starting Lookup Service...
2020-01-10 22:25:11,357 INFO [com.sun.jini.reggie.GigaRegistrar] - Started Lookup Service [duration=1.212s, groups=[xap-14.5.0], service-id=1a2708ad-03b7-4731-b62b-053fe93b156e, locator=jini://10.0.75.1:54423/]
Exception in thread "main" java.sql.SQLException: Error while preparing statement [SELECT e.firstName, e.age FROM Person e WHERE e.age = ?]
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:203)
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:185)
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:86)
at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:168)
at com.gigaspaces.jdbc.InsightEdgeConnection.prepareStatement(InsightEdgeConnection.java:77)
at JdbcTest.main(JdbcTest.java:33)
Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 32 to line 1, column 37: Object 'Person' not found
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:804)
at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:789)
at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4393)
at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:162)
at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:167)
at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:939)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:920)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2954)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2939)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3181)
at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:939)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:920)
at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:220)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:895)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:605)
at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:550)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:264)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:228)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:784)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:639)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:609)
at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:196)
... 5 more
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object 'Person' not found
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)
... 31 more

 

Workaround

None

Acceptance Test

None

Assignee

Unassigned

Reporter

Nihar Kapadia

Labels

None

Priority

Major

SalesForce Case ID

None

Fix versions

None

Commitment Version/s

None

Due date

None

Product

None

Edition

Enterprise

Platform

All
Configure