some questions for shardingsphere

[刘阳 <28...@qq.com>]

Hello, I have two questions.


Question 1: I am using the ShardingSphere plug-in for database and table sharding. The plug-in version is 4.0.0-RC1 of sharding-jdbc-spring-namespace, and the database version is Oracle 12c. When I use the "Truncate" or "Alter table" statement (even if the operated table is not sharded), an exception of "Cannot support database type 'Oracle'" is thrown, but there is no problem when using DML. And this problem only appears when I build the project into a jar package, I debug in eclipse without problems. See the attachment for the relevant screenshot.


Question 2: I tried to upgrade the plug-in version, but the upgraded version simply prevented the project from starting. Versions 4.0.0-RC2 and 4.0.0-RC3 throw an exception of ORA-00942 (table or view does not exist), version 4.1.0 throws an exception of ORA-00933 (SQL command not properly ended). Only version 4.0.0-RC1 can start and run normally.

Re: some questions for shardingsphere

["zhangliang@apache.org" <zh...@apache.org>]

Thank you for the attention.
I think the issue has been fixed by
https://github.com/apache/shardingsphere/pull/5477

------------------

Liang Zhang (John)
Apache ShardingSphere & Dubbo


刘阳 <28...@qq.com> 于2020年5月12日周二 下午7:53写道：

> Hello, I have two questions.
>
> Question 1: I am using the ShardingSphere plug-in for database and table
> sharding. The plug-in version is 4.0.0-RC1 of
> sharding-jdbc-spring-namespace, and the database version is Oracle 12c.
> When I use the "Truncate" or "Alter table" statement (even if the operated
> table is not sharded), an exception of "Cannot support database type
> 'Oracle'" is thrown, but there is no problem when using DML. And this
> problem only appears when I build the project into a jar package, I debug
> in eclipse without problems. See the attachment for the relevant screenshot.
>
> Question 2: I tried to upgrade the plug-in version, but the upgraded
> version simply prevented the project from starting. Versions 4.0.0-RC2 and
> 4.0.0-RC3 throw an exception of ORA-00942 (table or view does not exist),
> version 4.1.0 throws an exception of ORA-00933 (SQL command not properly
> ended). Only version 4.0.0-RC1 can start and run normally.
>