You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "strongduanmu (via GitHub)" <gi...@apache.org> on 2023/05/30 08:12:31 UTC
[GitHub] [shardingsphere] strongduanmu opened a new issue, #25945: ORA-01006: Binding variable does not exist when startup shardingsphere jdbc with oracle 19c
strongduanmu opened a new issue, #25945:
URL: https://github.com/apache/shardingsphere/issues/25945
## Bug Report
### Which version of ShardingSphere did you use?
[ab2e0b0](https://github.com/apache/shardingsphere/commit/ab2e0b082990b7588b6d440a76c59cf1a578157b)
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
startup shardingsphere jdbc with oracle 19c successfully
### Actual behavior
```
19:40:35.777 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
19:40:36.316 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
19:40:36.657 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Starting...
19:40:37.490 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Start completed.
java.sql.SQLException: ORA-12801: 并行查询服务器 P002 中发出错误信号
ORA-01006: 绑定变量不存在
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:629)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:563)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1150)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:770)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:497)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:151)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:936)
at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1171)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1100)
at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1425)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1308)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3745)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3854)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1097)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.dialect.OracleSchemaMetaDataLoader.loadTablePrimaryKeys(OracleSchemaMetaDataLoader.java:181)
at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.dialect.OracleSchemaMetaDataLoader.loadColumnMetaDataMap(OracleSchemaMetaDataLoader.java:97)
at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.dialect.OracleSchemaMetaDataLoader.load(OracleSchemaMetaDataLoader.java:81)
at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.SchemaMetaDataLoaderEngine.load(SchemaMetaDataLoaderEngine.java:81)
at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.SchemaMetaDataLoaderEngine.lambda$load$0(SchemaMetaDataLoaderEngine.java:62)
at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
at java.util.concurrent.FutureTask.run(FutureTask.java)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 12801, Position : 0, Sql = SELECT A.OWNER AS TABLE_SCHEMA, A.TABLE_NAME AS TABLE_NAME, B.COLUMN_NAME AS COLUMN_NAME FROM ALL_CONSTRAINTS A INNER JOIN ALL_CONS_COLUMNS B ON A.CONSTRAINT_NAME = B.CONSTRAINT_NAME WHERE CONSTRAINT_TYPE = 'P' AND A.OWNER = :1 AND A.TABLE_NAME IN ('MC_中文表名',,'TT_TMP_ABC'),
```
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] FlyingZC closed issue #25945: ORA-01006: Binding variable does not exist when startup shardingsphere jdbc with oracle 19c
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC closed issue #25945: ORA-01006: Binding variable does not exist when startup shardingsphere jdbc with oracle 19c
URL: https://github.com/apache/shardingsphere/issues/25945
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org