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/22 06:36:51 UTC
[GitHub] [shardingsphere] wp0372176 opened a new issue #8286: how to support database scheme or user ?
wp0372176 opened a new issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286
oracle database .
select * from schema11.tb_user_0
select * from schema11.tb_user_1
----------------------------------------------------------------
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] wp0372176 edited a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 edited a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713029
hi @dongzl
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
oracle的依赖：
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.8.0.0</version>
</dependency>
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>19.8.0.0</version>
</dependency>
spring boot 依赖：
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.3.6.RELEASE</version>
</parent>
----------------------------------------------------------------
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] wp0372176 edited a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 edited a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713029
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
oracle的依赖：
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.8.0.0</version>
</dependency>
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>19.8.0.0</version>
</dependency>
spring boot 依赖：
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.3.6.RELEASE</version>
</parent>
----------------------------------------------------------------
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] wp0372176 commented on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 commented on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713303
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.8.0.0</version>
</dependency>
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>19.8.0.0</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
[GitHub] [shardingsphere] wp0372176 edited a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 edited a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731714602
----------------------------------------------------------------
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] wp0372176 edited a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 edited a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713029
----------------------------------------------------------------
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] terrymanu commented on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731914276
It has already supported in ShardingSphere, please try it.
Code ref: `OracleDataSourceMetaData`
----------------------------------------------------------------
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] terrymanu closed issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286
----------------------------------------------------------------
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] kimmking commented on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731738865
Each physical schema should be configured as a datasource.
And then config datasource to logic schema.
----------------------------------------------------------------
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] wp0372176 edited a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 edited a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713029
hi @dongzl
shardingsphere 4.1.1:
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
oracle的依赖：
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.8.0.0</version>
</dependency>
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>19.8.0.0</version>
</dependency>
spring boot 依赖：
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.3.6.RELEASE</version>
</parent>
----------------------------------------------------------------
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] terrymanu removed a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
terrymanu removed a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731914276
It has already supported in ShardingSphere, please try it.
Code ref: `OracleDataSourceMetaData`
----------------------------------------------------------------
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] wp0372176 commented on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 commented on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713029
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</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
[GitHub] [shardingsphere] wp0372176 edited a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 edited a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713029
hi @dongzl
shardingsphere 4.1.1:
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
oracle的依赖：
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.8.0.0</version>
</dependency>
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>19.8.0.0</version>
</dependency>
spring boot 依赖：
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.3.6.RELEASE</version>
</parent>
----------------------------------------------------------------
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] wp0372176 edited a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 edited a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713029
hi @dongzl
shardingsphere 4.1.1:
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
oracle的依赖：
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.8.0.0</version>
</dependency>
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>19.8.0.0</version>
</dependency>
spring boot 依赖：
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.3.6.RELEASE</version>
</parent>
----------------------------------------------------------------
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] wp0372176 edited a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 edited a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713029
hi @dongzl
shardingsphere 依赖 4.1.1:
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
</dependency>
oracle依赖：
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.8.0.0</version>
</dependency>
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>19.8.0.0</version>
</dependency>
spring boot 依赖：
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.3.6.RELEASE</version>
</parent>
----------------------------------------------------------------
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] terrymanu commented on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731914693
Cannot support, please read document: https://shardingsphere.apache.org/document/current/en/features/sharding/use-norms/sql/#unsupported-sql
Do not support SQL that contains schema, for the concept of ShardingSphere is to use multiple data source as one data source, so all the SQL visits are based on one logic schema.
----------------------------------------------------------------
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] wp0372176 commented on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 commented on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731714602
hi @dongzl
shardingsphere last version:
org.apache.shardingsphere sharding-jdbc-spring-boot-starter 4.1.1
oracle pom:
com.oracle.database.jdbc ojdbc8 19.8.0.0
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>19.8.0.0</version>
</dependency>
spring boot pom：
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.3.6.RELEASE</version>
</parent>
----------------------------------------------------------------
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] dongzl commented on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731709581
Hi @wp0372176 , which is the version for ShardingSphere?
----------------------------------------------------------------
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] wp0372176 closed issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 closed issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286
----------------------------------------------------------------
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] wp0372176 removed a comment on issue #8286: how to support database scheme or user ?
Posted by GitBox <gi...@apache.org>.
wp0372176 removed a comment on issue #8286:
URL: https://github.com/apache/shardingsphere/issues/8286#issuecomment-731713303
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.8.0.0</version>
</dependency>
<dependency>
<groupId>com.oracle.database.nls</groupId>
<artifactId>orai18n</artifactId>
<version>19.8.0.0</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