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/05/01 08:21:00 UTC
[GitHub] [shardingsphere] TaoZhiMLND edited a comment on issue #5383: official example in oracle get meta info go wrong
TaoZhiMLND edited a comment on issue #5383:
URL: https://github.com/apache/shardingsphere/issues/5383#issuecomment-622295865
@lvye351 Hi, YamlDataSourceFactory#newInstance execute successfully when I use oracle database 12c, ojdbc8.jar and the newest code of ShardingSphere on the master branch. Method isTableExist have been moved to class TableMetaDataLoader after #5309 , instead of class ColumnMetaDataLoader which in your second Exception log.
My configuration is as follows,
`sharding-databases.yaml`
```
dataSources:
ds_0: !!com.zaxxer.hikari.HikariDataSource
driverClassName: oracle.jdbc.driver.OracleDriver
jdbcUrl: jdbc:oracle:thin:@localhost:1521:orcl
username: C##DEMO_DS_0
password: DEMO_DS_0
ds_1: !!com.zaxxer.hikari.HikariDataSource
driverClassName: oracle.jdbc.driver.OracleDriver
jdbcUrl: jdbc:oracle:thin:@localhost:1521:orcl
username: C##DEMO_DS_1
password: DEMO_DS_1
```
`pom.xml`
```
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.3</version>
</dependency>
```
and the result
BTW, if you want to run the rest of the code, the SQL statement needs to be modified to fit the Oracle syntax.
----------------------------------------------------------------
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