Super - Thanks a lot Alex.
So the first one works well (sqlline, dbeaver and java)
SELECT * FROM B.B0;
But the second one failed (dbeaver and sqlline),
SELECT * FROM A.A;
So I thought may be if the cache name is different from object type the it
might work
so instead of "Cache/Schema.ObjectClass" like A.A or B.B0 I use Cache_A.A
and Cache_B.B0 but that is failing
The only thing I changed in the code is
private static String PREFIXTABLE =
"Cache_";//IgniteSQL.class.getSimpleName() + "Cache_";
+--------------------------------+--------------------------------+--------------------------------+---------------------------------+
| TABLE_CAT | TABLE_SCHEM |
TABLE_NAME | TABLE_TYPE |
+--------------------------------+--------------------------------+--------------------------------+---------------------------------+
| | Cache_B | B0
| TABLE |
| | Cache_A | A
| TABLE |
+--------------------------------+--------------------------------+--------------------------------+---------------------------------+
0: jdbc:ignite:thin://127.0.0.1/> SELECT * FROM Cache_A.A;
Error: Failed to parse query. Schema "CACHE_A" not found; SQL statement:
SELECT * FROM Cache_A.A [90079-195] (state=42000,code=0)
java.sql.SQLException: Failed to parse query. Schema "CACHE_A" not found;
SQL statement:
SELECT * FROM Cache_A.A [90079-195]
at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:648)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:130)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:299)
at sqlline.Commands.execute(Commands.java:823)
at sqlline.Commands.sql(Commands.java:733)
at sqlline.SqlLine.dispatch(SqlLine.java:795)
at sqlline.SqlLine.begin(SqlLine.java:668)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)
0: jdbc:ignite:thin://127.0.0.1/> SELECT * FROM Cache_B.B0;
Error: Failed to parse query. Schema "CACHE_B" not found; SQL statement:
SELECT * FROM Cache_B.B0 [90079-195] (state=42000,code=0)
java.sql.SQLException: Failed to parse query. Schema "CACHE_B" not found;
SQL statement:
SELECT * FROM Cache_B.B0 [90079-195]
at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:648)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:130)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:299)
at sqlline.Commands.execute(Commands.java:823)
at sqlline.Commands.sql(Commands.java:733)
at sqlline.SqlLine.dispatch(SqlLine.java:795)
at sqlline.SqlLine.begin(SqlLine.java:668)
at sqlline.SqlLine.start(SqlLine.java:373)
at sqlline.SqlLine.main(SqlLine.java:265)
0: jdbc:ignite:thin://127.0.0.1/>
Thanks
w
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
