代码之家  ›  专栏  ›  技术社区  ›  sagar limbu

将带有Oracle的Spring Boot应用程序打包为数据库[副本]

  •  0
  • sagar limbu  · 技术社区  · 7 年前

    这个问题已经有了答案:

    我正在尝试打包我的spring boot应用程序,以便可以在tomcat服务器上部署它。在看了youtube视频之后,我扩展了springbootservletinitializer类并做了一些更改。

     @ComponentScan("com.infodev.loksewa")
        @SpringBootApplication
        public class LoksewaApplication extends SpringBootServletInitializer {
    
        public static void main(String[] args) {
            SpringApplication.run(LoksewaApplication.class, args);
        }
    
        @Override
        protected SpringApplicationBuilder configure(SpringApplicationBuilder builder) {
            return builder.sources(LoksewaApplication.class);
        }
    }
    

    POX.XML

    <?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.infodev</groupId>
        <artifactId>loksewa</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <packaging>war</packaging>
    
        <name>loksewa</name>
        <description>Demo project for Spring Boot</description>
    
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.2.RELEASE</version>
            <relativePath/> <!-- lookup parent from repository -->
        </parent>
    
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-jpa</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-tomcat</artifactId>
                <scope>provided</scope>
            </dependency>
        </dependencies>
    
        <build>
            <finalName>psclockunlock</finalName>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    
    </project>
    

    pom.xml将无法自动导入ojdbc jar文件,因此我手动添加了该jar文件,如下所示:

    enter image description here

    当我在ide(intellij idea)上运行应用程序时,它成功运行。但现在我需要将其打包为war文件并将其部署到tomcat服务器上。所以当我从intellij进行打包时,我得到一个错误,它说驱动程序无法加载。

    Caused by: java.lang.IllegalStateException: 
    Cannot load driver class: oracle.jdbc.driver.OracleDriver
    

    打包应用程序时,应该将这个ojdbc jar文件放在哪里?

    1 回复  |  直到 7 年前
        1
  •  6
  •   Panup Pong    7 年前

    由于Oracle许可证限制,Oracle JDBC驱动程序在公共Maven存储库中不可用。要在maven中使用oracle jdbc驱动程序,必须手动下载并安装到maven本地存储库中。要安装Oracle JDBC驱动程序,请发出以下命令:

    mvn install:install file-dfile={path/to/your/ojdbc.jar} -dGroupID=com.oracle -dartifactid=ojdbc6-dversion=11.2.0-dpackage=jar

    添加OJDBC6依赖项

    <dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc6</artifactId>
        <version>11.2.0</version>
    </dependency>