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 2020/11/30 12:19:50 UTC

[GitHub] [shardingsphere] hanjinxing opened a new issue #8424: dont support oracle RAC in db.url?

hanjinxing opened a new issue #8424:
URL: https://github.com/apache/shardingsphere/issues/8424


   ## Question
   
    when i use the jdbc.url=jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = host_ip1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host_ip2)(PORT = 1521)) (LOAD_BALANCE = yes)(failover=on)(connect_data= (service_name = orattt))), the class of OracleDataSourceMetaData is error, 
   
   public final class OracleDataSourceMetaData implements DataSourceMetaData {
       
       private static final int DEFAULT_PORT = 1521;
       
       private final String hostName;
       
       private final int port;
       
       private final String catalog;
       
       private final String schema;
       
       private final Pattern pattern = Pattern.compile("jdbc:oracle:(thin|oci|kprb):@(//)?([\\w\\-\\.]+):?([0-9]*)[:/]([\\w\\-]+)", Pattern.CASE_INSENSITIVE);
       
       public OracleDataSourceMetaData(final String url, final String username) {
           Matcher matcher = pattern.matcher(url);
           if (!matcher.find()) {
               throw new UnrecognizedDatabaseURLException(url, pattern.pattern());
           }
           hostName = matcher.group(3);
           port = Strings.isNullOrEmpty(matcher.group(4)) ? DEFAULT_PORT : Integer.valueOf(matcher.group(4));
           catalog = matcher.group(5);
           schema = username;
       }
   }
   
   throw UnrecognizedDatabaseURLException, 
   
   please help me , the shardingsphere dont support oracle RAC???
   


----------------------------------------------------------------
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] [shardingsphere] tuohai666 commented on issue #8424: dont support oracle RAC in db.url?

Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #8424:
URL: https://github.com/apache/shardingsphere/issues/8424#issuecomment-735764443


   Duplicated with https://github.com/apache/shardingsphere/issues/7195 .


----------------------------------------------------------------
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] [shardingsphere] tuohai666 closed issue #8424: dont support oracle RAC in db.url?

Posted by GitBox <gi...@apache.org>.
tuohai666 closed issue #8424:
URL: https://github.com/apache/shardingsphere/issues/8424


   


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