KnothHe commented on issue #21233:
URL:
https://github.com/apache/shardingsphere/issues/21233#issuecomment-1262179439
Error syntax is
```java
shardingJdbcTemplate.queryForMap("SELECT jt.json_field ->> '$.key' FROM
json_test jt WHERE id = ?", 2);
```
My error stack, not exactly the same as @sxlArtless's screenshot:
```txt
com.google.common.util.concurrent.UncheckedExecutionException:
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an
error in your SQL syntax
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2051)
~[guava-30.0-jre.jar:na]
at com.google.common.cache.LocalCache.get(LocalCache.java:3951)
~[guava-30.0-jre.jar:na]
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3974)
~[guava-30.0-jre.jar:na]
at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4935)
~[guava-30.0-jre.jar:na]
at
com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4941)
~[guava-30.0-jre.jar:na]
at
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:47)
~[shardingsphere-infra-parser-5.1.1.jar:5.1.1]
at
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:58)
~[shardingsphere-infra-parser-5.1.1.jar:5.1.1]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:180)
~[shardingsphere-jdbc-core-5.1.1.jar:5.1.1]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.<init>(ShardingSpherePreparedStatement.java:149)
~[shardingsphere-jdbc-core-5.1.1.jar:5.1.1]
at
org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection.prepareStatement(ShardingSphereConnection.java:80)
~[shardingsphere-jdbc-core-5.1.1.jar:5.1.1]
at
org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1645)
~[spring-jdbc-5.3.23.jar:5.3.23]
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
~[spring-jdbc-5.3.23.jar:5.3.23]
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)
~[spring-jdbc-5.3.23.jar:5.3.23]
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:744)
~[spring-jdbc-5.3.23.jar:5.3.23]
at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757)
~[spring-jdbc-5.3.23.jar:5.3.23]
at
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:879)
~[spring-jdbc-5.3.23.jar:5.3.23]
at
org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:916)
~[spring-jdbc-5.3.23.jar:5.3.23]
at
me.guanglai.sharding.test.JsonQueryTest.doSomethingAfterStartup(JsonQueryTest.java:28)
~[classes/:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:na]
at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
~[na:na]
at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:564) ~[na:na]
at
org.springframework.context.event.ApplicationListenerMethodAdapter.doInvoke(ApplicationListenerMethodAdapter.java:344)
~[spring-context-5.3.23.jar:5.3.23]
at
org.springframework.context.event.ApplicationListenerMethodAdapter.processEvent(ApplicationListenerMethodAdapter.java:229)
~[spring-context-5.3.23.jar:5.3.23]
at
org.springframework.context.event.ApplicationListenerMethodAdapter.onApplicationEvent(ApplicationListenerMethodAdapter.java:166)
~[spring-context-5.3.23.jar:5.3.23]
at
org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:176)
~[spring-context-5.3.23.jar:5.3.23]
at
org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:169)
~[spring-context-5.3.23.jar:5.3.23]
at
org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:143)
~[spring-context-5.3.23.jar:5.3.23]
at
org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:421)
~[spring-context-5.3.23.jar:5.3.23]
at
org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:378)
~[spring-context-5.3.23.jar:5.3.23]
at
org.springframework.boot.context.event.EventPublishingRunListener.ready(EventPublishingRunListener.java:114)
~[spring-boot-2.7.4.jar:2.7.4]
at
org.springframework.boot.SpringApplicationRunListeners.lambda$ready$6(SpringApplicationRunListeners.java:82)
~[spring-boot-2.7.4.jar:2.7.4]
at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) ~[na:na]
at
org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:120)
~[spring-boot-2.7.4.jar:2.7.4]
at
org.springframework.boot.SpringApplicationRunListeners.doWithListeners(SpringApplicationRunListeners.java:114)
~[spring-boot-2.7.4.jar:2.7.4]
at
org.springframework.boot.SpringApplicationRunListeners.ready(SpringApplicationRunListeners.java:82)
~[spring-boot-2.7.4.jar:2.7.4]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:323)
~[spring-boot-2.7.4.jar:2.7.4]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
~[spring-boot-2.7.4.jar:2.7.4]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1295)
~[spring-boot-2.7.4.jar:2.7.4]
at
me.guanglai.sharding.test.ShardingTestApplication.main(ShardingTestApplication.java:10)
~[classes/:na]
Caused by:
org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an
error in your SQL syntax
at
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:65)
~[shardingsphere-sql-parser-engine-5.1.1.jar:5.1.1]
at
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.parse(SQLParserExecutor.java:46)
~[shardingsphere-sql-parser-engine-5.1.1.jar:5.1.1]
at
org.apache.shardingsphere.sql.parser.api.SQLParserEngine.parse(SQLParserEngine.java:47)
~[shardingsphere-sql-parser-engine-5.1.1.jar:5.1.1]
at
org.apache.shardingsphere.infra.parser.sql.SQLStatementParserExecutor.parse(SQLStatementParserExecutor.java:48)
~[shardingsphere-infra-parser-5.1.1.jar:5.1.1]
at
org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:41)
~[shardingsphere-infra-parser-5.1.1.jar:5.1.1]
at
org.apache.shardingsphere.infra.parser.cache.SQLStatementCacheLoader.load(SQLStatementCacheLoader.java:30)
~[shardingsphere-infra-parser-5.1.1.jar:5.1.1]
at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3529)
~[guava-30.0-jre.jar:na]
at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2278)
~[guava-30.0-jre.jar:na]
at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2155)
~[guava-30.0-jre.jar:na]
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2045)
~[guava-30.0-jre.jar:na]
... 39 common frames omitted
```
Both have this error:
```txt
org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:65)
~[shardingsphere-sql-parser-engine-5.1.1.jar:5.1.1]
at
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
