xsong123 opened a new issue #13791:
URL: https://github.com/apache/shardingsphere/issues/13791
mysql version 5.7
shardingsphere version 5.0.0
datasource has 2(ds_0,ds_1)
sql:
create table if not exists assetportfoliostructure_fb2109112331 (
id bigint comment '唯一标识' primary key,
portfoliocode varchar(32) null comment '资产池代码',
...
key `idx_aps_pc_ac` (portfoliocode,assetcode) using btree
) engine=innodb character set = utf8mb4 collate = utf8mb4_bin
comment='组合结构_项目表';
error:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect
database name 'org'
at sun.reflect.GeneratedConstructorAccessor158.newInstance(Unknown
Source)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912)
at
com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2133)
at
com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2067)
at
com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5175)
at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2052)
at
com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255)
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement$1.executeSQL(ShardingSpherePreparedStatement.java:268)
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement$1.executeSQL(ShardingSpherePreparedStatement.java:264)
at
org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:85)
at
org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:64)
at
org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.syncExecute(ExecutorEngine.java:101)
at
org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.parallelExecute(ExecutorEngine.java:97)
at
org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.execute(ExecutorEngine.java:82)
at
org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutor.execute(JDBCExecutor.java:65)
at
org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutor.execute(JDBCExecutor.java:49)
at
org.apache.shardingsphere.driver.executor.JDBCLockEngine.doExecute(JDBCLockEngine.java:116)
at
org.apache.shardingsphere.driver.executor.JDBCLockEngine.execute(JDBCLockEngine.java:93)
at
org.apache.shardingsphere.driver.executor.DriverJDBCExecutor.executeUpdate(DriverJDBCExecutor.java:96)
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.executeUpdate(ShardingSpherePreparedStatement.java:247)
at
org.seasar.framework.util.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:66)
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
