如何在SpringBoot项目中使用Oracle11g数据库-FinClip官网

如何在SpringBoot项目中使用Oracle11g数据库

网友投稿 1747 2023-01-12

如何在SpringBoot项目中使用Oracle11g数据库

在SpringBoot项目中使用Oracle11g数据库

具体步骤如下：

1：-ojdbc6.jar ,随便放个英文目录位置就好

2：命令行下输入下行，注意最后-Dfile 为自己的-目录

mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.1.0 -Dpackaging=jar -Dfile=H:\eclpise-workspace\ojdbc6.jar

3：在项目的pom文件中引入下面依赖

com.oracle

ojdbc6

11.2.0.1.0

4：在项目的配置文件中写数据库的连接信息，其中，假设Oracle连接ip为127.0.0.1，端口号为1521，数据库为database，用户名为username，密码为password

spring.datasource.driver-class-name=oracle.jdbc.OracleDriver

spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:database

spring.datasource.username=username

spring.datasource.password=password

完成！

SpringBoot 2.0连接Oracle 11g遇到的问题

基本配置信息：

驱动

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。

com.oracle.database.jdbc

ojdbc6

11.2.0.4

创建IDatabasePlatform时出现报错

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 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 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&param=%7B%22sql%22:%22select+AIRDATA,AIRTIME+from+MAI_DATA%22,%22resourceId%22:%22abc9cfbe-44cf-4e83-9eb1-325422db9dd8%22,%22projectVersionId%22:%22f55241fd-9564-4f6a-bd0d-95a50a729000%22%7D

2020-10-13 16:57:49,343 ERROR [GlobalExceptionHandler.java:27] : System_error:requestId=1516430392

org.jumpmind.db.platform.DdlException: Could not create a platform of type Oracle

at org.jumpmind.db.platform.JdbcDatabasePlatformFactory.createNewPlatformInstance(JdbcDatabasePlatformFactory.java:166)

at org.jumpmind.metl.ui.views.design.RdbmsHandler.sqlExecute(RdbmsHandler.java:68)

at org.jumpmind.metl.ui.views.design.RdbmsHandler.execute(RdbmsHandler.java:42)

at org.jumpmind.metl.core.handler.HandlerService.execute(HandlerService.java:14)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:338)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)

at com.sun.proxy.$Proxy138.execute(Unknown Source)

at com.yak.api.mlengine.CompController.handler(CompController.java:53)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:870)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:776)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:870)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:855)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)