[GitHub] guowdxp commented on issue #1829: sharding-sphere is 4.0.0.M1-SNAPSHOT cann't configure multiple config-sharding files.

[GitBox]

guowdxp commented on issue #1829: sharding-sphere is 4.0.0.M1-SNAPSHOT cann't 
configure  multiple config-sharding files.
URL: 
https://github.com/apache/incubator-shardingsphere/issues/1829#issuecomment-458020199
 
 
   The version using sharding-sphere is 4.0.0.M1-SNAPSHOT.
   I use sharding-Proxy.
   
   I configure a config-sharding file and the query is ok，but I configure 
multiple config-sharding yaml files, execute sql query with java code will 
report an error：
   
   
   Exception in thread "main" java.sql.SQLException: Unknown exception: null
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)
   at 
com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1765)
   at 
com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3364)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2283)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)
   at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:794)
   at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:44)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at 
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
   at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
   at java.sql.DriverManager.getConnection(DriverManager.java:579)
   at java.sql.DriverManager.getConnection(DriverManager.java:221)
   at com.zhongan.dmds.sharding_sphere.QueryTest.main(QueryTest.java:32)
   
   Java code :
   
        public static void main(String[] args) throws Exception {               
                Class.forName("com.mysql.jdbc.Driver"); 
                String dmdsName = null;
                String sql = "select * from bcp_router limit 0,1" ;             
                Connection conn = DriverManager.getConnection(url, username, 
password);
                PreparedStatement ps = conn.prepareStatement(sql);
                ResultSet rs = ps.executeQuery();
                if(rs.next()) {
                        System.out.println(rs.getObject(1));
                }
                System.out.println("ok");
                rs.close();
                ps.close();
                conn.close();   
        }

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services