基本配置信息:
驱动 | oracle.jdbc.driver.OracleDriver |
连接Url | jdbc:oracle:thin:@192.168.112.129:1521:orcl |
用户 | System |
密码 | Aa123456 |
添加驱动包:
这里添加的是ojdbc6包,因为之前在Davinci系统使用ojdbc14时报错了,我使用的Jdk1.8的版本。
ojdbc6.jar比ojdbc14.jar的版本高得多,因为里面的6是指支持jdk1.6 ,而14是指支持jdk1.4。
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.4</version>
</dependency>
创建IDatabasePlatform时出现报错
<!--org.jumpmind.db.platform.JdbcDatabasePlatformFactory-->
Constructor<? extends IDatabasePlatform> construtor = clazz.getConstructor(DataSource.class, SqlTemplateSettings.class);
IDatabasePlatform platform = construtor.newInstance(dataSource, settings);
2020-10-13 16:57:47.929 INFO 13740 --- [manager-startup] o.j.metl.core.runtime.AgentRuntime : Deploying the 本地数据库 resource to the <default user on DESKTOP-INGH9R2> agent
resourceId:abc9cfbe-44cf-4e83-9eb1-325422db9dd8
sql:select AIRDATA,AIRTIME from MAI_DATA
projectVersionId:f55241fd-9564-4f6a-bd0d-95a50a729000
2020-10-13 16:57:49.150 INFO 13740 --- [manager-startup] o.j.metl.core.runtime.AgentRuntime : Deploying the Oracle数据源 resource to the <default user on DESKTOP-INGH9R2> agent
2020-10-13 16:57:49.308 INFO 13740 --- [nio-9999-exec-1] o.j.d.p.JdbcDatabasePlatformFactory : Detected database 'Oracle', version '11', protocol 'oracle'
2020-10-13 16:57:49,342 ERROR [GlobalExceptionHandler.java:47] : requestUrl=http://localhost:9999/open/api/ml/comp/handler?name=rdbmsreader¶m=%7B%22sql%22:%22select+AIRDATA,AIRTIME+from+MAI_DATA%22,%22resourceId%22:%22abc9cfbe-44cf-4e83-9eb1-325422db9dd8%22,%22projectVersionId%22:%22f55241fd-9564-4f6a