[GitHub] [shardingsphere] w5720319 commented on issue #14444: When connecting to sqlserver, the query does not support the SqlServer keyword

[GitBox <gi...@apache.org>]

w5720319 commented on issue #14444:
URL: https://github.com/apache/shardingsphere/issues/14444#issuecomment-1005459061


   > @w5720319 I believe it has been fixed in master branch. You can try the latest version.
   > 
   > > I also want to ask： org.apache.shardingsphere.infra.database.type.dialect.SQLServerDatabaseType.getJdbcUrlPrefixes() public Collection getJdbcUrlPrefixes() { return Collections.singletonList("jdbc:microsoft:sqlserver:"); } Should "jdbc: Microsoft: sqlserver" be changed to "jdbc: sqlserver:", because jdbc: sqlserver: is the connection mode of sqlserver2000
   
   I now switch to 5.0.0，But there are always new ones：
      org.apache.shardingsphere.infra.database.metadata.dialect.SQLServerDataSourceMetaData
      private final Pattern pattern = Pattern.compile("jdbc:(microsoft:)?sqlserver://([\\w\\-\\.]+):?([0-9]*);\\S* 
     (DatabaseName|database)=([\\w\\-\\.]+);?", Pattern.CASE_INSENSITIVE);
   
   **The above regularity does not support** URL:jdbc:sqlserver://127.0.0.1\TESTMSSQL:1001;connectRetryInterval=10;connectRetryCount=1;
   maxResultBuffer=-1;sendTemporalDataTypesAsStringForBulkCopy=true;
   delayLoadingLobs=true;useFmtOnly=false;useBulkCopyForBatchInsert=false;
   cancelQueryTimeout=-1;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;
   statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;
   enablePrepareOnFirstPreparedStatementCall=false;fips=false;
   socketTimeout=0;authentication=NotSpecified;
   authenticationScheme=nativeAuthentication;xopenStates=false;
   sendTimeAsDatetime=true;replication=false;trustStoreType=JKS;
   trustServerCertificate=false;TransparentNetworkIPResolution=true;
   serverNameAsACE=false;sendStringParametersAsUnicode=true;
   selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;
   packetSize=8000;multiSubnetFailover=false;loginTimeout=30;lockTimeout=-1;
   lastUpdateCount=true;encrypt=false;disableStatementPooling=true;
   columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;
   applicationIntent=readwrite;


-- 
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