You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "StanislavIsaev (via GitHub)" <gi...@apache.org> on 2025/04/08 12:04:26 UTC
[I] ShardingSphere Proxy: can't retreive Oracle Clob [shardingsphere]
StanislavIsaev opened a new issue, #35144:
URL: https://github.com/apache/shardingsphere/issues/35144
Hi, when I try to query a table with the Oracle Clob column type, I get an error: Can not find JDBC type `2005` in PostgreSQL column type.
Version: 5.5.2
Frontend: PostgreSQL
Storage Units: Oracle dbms
It happens in `org.apache.shardingsphere.db.protocol.postgresql.packet.command.query.extended.PostgreSQLColumnType.valueOfJDBCType`
Is there a way to somehow customize this behavior and adopt Oracle Clob values to, for example, Postgres Text?
--
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
Re: [I] ShardingSphere Proxy: can't retreive Oracle Clob [shardingsphere]
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #35144:
URL: https://github.com/apache/shardingsphere/issues/35144#issuecomment-2816773338
OK, it seems that your problem has been solved temporarily, congratulations.
Due to the particularity of this scenario, I guess it is difficult to get a general solution
--
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
Re: [I] ShardingSphere Proxy: can't retreive Oracle Clob [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #35144:
URL: https://github.com/apache/shardingsphere/issues/35144#issuecomment-2836968651
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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
Re: [I] ShardingSphere Proxy: can't retreive Oracle Clob [shardingsphere]
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #35144: ShardingSphere Proxy: can't retreive Oracle Clob
URL: https://github.com/apache/shardingsphere/issues/35144
--
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
Re: [I] ShardingSphere Proxy: can't retreive Oracle Clob [shardingsphere]
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #35144:
URL: https://github.com/apache/shardingsphere/issues/35144#issuecomment-2813292706
Hi, @StanislavIsaev
If you use the PostgreSQL frontend protocol in Proxy but register an Oracle database in the backend, you may encounter the following problems
1. When using the PG protocol to connect to Proxy, some SQL queries for metadata (triggered by the pg driver or GUI tool) will fail;
2. Differences in data types (which you have already encountered), including text type and binary type data;
Please note that there are many risks in using heterogeneous way, which may not be supported and need to be handled by yourself.
--
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
Re: [I] ShardingSphere Proxy: can't retreive Oracle Clob [shardingsphere]
Posted by "StanislavIsaev (via GitHub)" <gi...@apache.org>.
StanislavIsaev commented on issue #35144:
URL: https://github.com/apache/shardingsphere/issues/35144#issuecomment-2815303303
Thanks for your answer, @RaigorJiang
I'm aware of the risks, but I was wondering if someone had faced similar problems and what the best way to solve them is.
I've made a workaround:
1. Add Oracle Clob jdbc type (2005) to the PostgreSQLColumnType.JDBC_TYPE_AND_COLUMN_TYPE_MAP
2. The custom rule to convert Oracle Clob to String using the MergeResult decorator.
For now, it's enough for me.
But maybe someone have better solution to intgrate SS Proxy with Prstgres front and Oracle back?
--
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