You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/11/30 05:15:11 UTC
[GitHub] [shardingsphere] TeslaCN opened a new issue, #22522: ERROR: Can not find JDBC type `2002` in PostgreSQL column type
TeslaCN opened a new issue, #22522:
URL: https://github.com/apache/shardingsphere/issues/22522
## Bug Report
### Which version of ShardingSphere did you use?
master - 8ffe2bb86b6da9f9c9053fb5cce28cb5b5b660db
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy PostgreSQL
### Expected behavior
```
postgres=# insert into t values (100, 'hi') returning t;
t
----------
(100,hi)
(1 row)
```
### Actual behavior
```
postgres=> insert into t values (1000, 'hi') returning t;
ERROR: Can not find JDBC type `2002` in PostgreSQL column type
```
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
No rule configured.
```sql
create table t (id int, val varchar);
insert into t values (1000, 'hi') returning t;
```
--
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] TeslaCN commented on issue #22522: ERROR: Can not find JDBC type `2002` in PostgreSQL column type
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #22522:
URL: https://github.com/apache/shardingsphere/issues/22522#issuecomment-1363817349
I found the type OID is related to table. So we could not simply map the JDBC type 2002 to a specific pg_type oid.
--
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
[GitHub] [shardingsphere] TeslaCN commented on issue #22522: ERROR: Can not find JDBC type `2002` in PostgreSQL column type
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #22522:
URL: https://github.com/apache/shardingsphere/issues/22522#issuecomment-1364803354
And the table composite type in different databases may have different type OID.
--
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
[GitHub] [shardingsphere] TeslaCN commented on issue #22522: ERROR: Can not find JDBC type `2002` in PostgreSQL column type
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #22522:
URL: https://github.com/apache/shardingsphere/issues/22522#issuecomment-1363821884
But there is no way to retrieve the pg type OID via standard JDBC method. So this could not be fixed for now.
--
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
[GitHub] [shardingsphere] TeslaCN commented on issue #22522: ERROR: Can not find JDBC type `2002` in PostgreSQL column type
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #22522:
URL: https://github.com/apache/shardingsphere/issues/22522#issuecomment-1367237484
https://github.com/apache/shardingsphere/pull/23165 is a temporary solution for this issue.
--
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
[GitHub] [shardingsphere] TeslaCN closed issue #22522: ERROR: Can not find JDBC type `2002` in PostgreSQL column type
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #22522: ERROR: Can not find JDBC type `2002` in PostgreSQL column type
URL: https://github.com/apache/shardingsphere/issues/22522
--
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