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 2019/12/27 02:01:07 UTC
[GitHub] [incubator-shardingsphere] itxiaole opened a new issue #3813:
Sharding JDBC does not support oracle insert all syntax
itxiaole opened a new issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813
The order insert all statement, which is fine in the database, does not seem to be supported by Shrding JDBC
INSERT ALL
into order_info_1 (
ORDER_ID,
ORDER_PRICE,
ORDER_INVENTORY)
VALUES
(11,1,2)
into order_info_1 (
ORDER_ID,
ORDER_PRICE,
ORDER_INVENTORY)
VALUES
(12,1,2)
SELECT 1 FROM DUAL
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: org.apache.shardingsphere.core.parse.old.parser.exception.SQLParsingUnsupportedException: Not supported token 'ALL'.
### The error may exist in file [D:\java\javaCode\jdbc\target\classes\mapper\TOrderInfoDao.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT ALL into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) into order_info ( orderPrice, inventory ) VALUES ( ?, ? ) SELECT 1 FROM DUAL insert into order_info ( orderPrice, inventory )values (?, ?) , (?, ?) , (?, ?) , (?, ?) , (?, ?) , (?, ?) , (?, ?) , (?, ?) , (?, ?) , (?, ?)
### Cause: org.apache.shardingsphere.core.parse.old.parser.exception.SQLParsingUnsupportedException: Not supported token 'ALL'.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] SteNicholas edited a comment on issue
#3813: Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
SteNicholas edited a comment on issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813#issuecomment-569172180
@itxiaole In current version, OracleParser doesn't support `INSERT ALL` syntax. You could try to use `INSERT INTO tablename VALUES(), (), ()` grammar to support.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] itxiaole commented on issue #3813:
Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
itxiaole commented on issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813#issuecomment-569169701
<!-- https://mvnrepository.com/artifact/io.shardingjdbc/sharding-jdbc-core -->
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.0.0-RC1</version>
</dependency>
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #3813:
Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813#issuecomment-608376399
Closed until somebody interesting about 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] SteNicholas edited a comment on issue
#3813: Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
SteNicholas edited a comment on issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813#issuecomment-569172180
@itxiaole In current version, OracleParser doesn't support ALL syntax, and `INSERT ALL` statement to single table doesn't currently be supported because this could cause sharding route problem.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [shardingsphere] figuewang commented on issue #3813: Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
figuewang commented on issue #3813:
URL: https://github.com/apache/shardingsphere/issues/3813#issuecomment-620927447
i have test it, but have one bug,when insert two data into oracle,it throw exception;
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-shardingsphere] SteNicholas edited a comment on issue
#3813: Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
SteNicholas edited a comment on issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813#issuecomment-569172180
@itxiaole In current version, OracleParser doesn't support `INSERT ALL` syntax. Only try to use `INSERT INTO` to insert single data.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu closed issue #3813: Sharding
JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] SteNicholas edited a comment on issue
#3813: Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
SteNicholas edited a comment on issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813#issuecomment-569172180
@itxiaole In current version, OracleParser doesn't support ALL syntax.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [shardingsphere] figuewang commented on issue #3813: Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
figuewang commented on issue #3813:
URL: https://github.com/apache/shardingsphere/issues/3813#issuecomment-620927008
i have test it, but have one bug,when insert two data,it throw exception;
![image](https://user-images.githubusercontent.com/5305551/80551183-35c02880-89f5-11ea-93c2-3349701c94da.png)
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #3813:
Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813#issuecomment-569191560
No plan to support more oracle dialect, I want leave it to volunteer.
Anybody who want to do this feature, we can talk about details, or just reference about MySQL's `insert values (), (), ()...`
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [shardingsphere] figuewang removed a comment on issue #3813: Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
figuewang removed a comment on issue #3813:
URL: https://github.com/apache/shardingsphere/issues/3813#issuecomment-620927008
i have test it, but have one bug,when insert two data,it throw exception;
![image](https://user-images.githubusercontent.com/5305551/80551183-35c02880-89f5-11ea-93c2-3349701c94da.png)
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-shardingsphere] SteNicholas commented on issue #3813:
Sharding JDBC does not support oracle insert all syntax
Posted by GitBox <gi...@apache.org>.
SteNicholas commented on issue #3813: Sharding JDBC does not support oracle insert all syntax
URL: https://github.com/apache/incubator-shardingsphere/issues/3813#issuecomment-569172180
@itxiaole In current version, OracleParser doesn't support ALL syntax. @terrymanu Please assign to me to support this.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services