maven 配置oracle jar 可能出现的问题

最新推荐文章于 2024-08-01 14:52:10 发布

初上路的小码农

最新推荐文章于 2024-08-01 14:52:10 发布

阅读量1.7k

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/qq_35852248/article/details/80580292

版权

oracle 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

maven中oracle

<dependency>
      <groupId>com.oracle</groupId>
      <artifactId>ojdbc6</artifactId>
      <version>11.2.0.4.0-atlassian-hosted</version>
      <scope>test</scope>
    </dependency>

用c3p0做数据源时

会报 com.mchange.v2.c3p0.DriverManagerDataSource. Could not load driverClass oracle.jdbc.OracleDriver

加载不了oracle驱动；

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
        <property name="user" value="bocc"/>
        <property name="password" value="boccpass"/>
        <property name="minPoolSize" value="2"/>
        <property name="maxPoolSize" value="40"/>
        <property name="initialPoolSize" value="2"/>
        <!--<property name="maxIdleTime" value="30"/>
</bean>

用spring数据源

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
        <property name="username" value="bocc"/>
        <property name="password" value="boccpass"/>
    </bean>

会报 java.lang.IllegalArgumentException: Initial capacity must be at least one but was 0

在网上找了很多原因后来才发现原来是 maven中oracle 配置多了

去掉就好了

maven中scope标签详解

做下记录