java/eclipse

이클립스에서 메이븐, 오라클 강제로 적용하는 방법

ITGenerations 2018. 12. 31. 15:10

https://mvnrepository.com/

메이븐라이브러리 레퍼런스




oracle OJDBC 14는 오라클 10버전 아래

oracle OJDBC 6는 오라클 11버전


프로젝트 -> import -> maven -> install or deploy an artiffact to  a Maven repositoy


Artifact_file: 파일위치

Group id: com.oracle

Artifact id: ojdbc6

Version 12.1.0.2

Packaging jar



























<!-- set DB Mysql -->

   <!-- <bean id="dataSourceProxy" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

         <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>

         <property name="url" value="jdbc:mysql://아이피 주소:포트/bmw"></property>

         <property name="username" value="계정명"></property>

         <property name="password" value="패스워드"></property>

    </bean> -->


   <!-- set DB Mssql -->

   <!-- <bean id="dataSourceProxy" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

      <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>

      <property name="url" value="jdbc:sqlserver://IP주소:포트번호;DatabaseName=데이터베이스 이름"/>

      <property name="username" value="계정명"></property>

      <property name="password" value="패스워드"></property>

   </bean> -->


    <!-- set DB Oracle -->

    <!-- <bean id="dataSourceProxy" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>

        <property name="url" value="jdbc:oracle:thin:@IP주소:포트번호:데이터베이스이름" />

      <property name="username" value="계정명"></property>

      <property name="password" value="패스워드"></property>

    </bean>

    <bean id="dataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">

      <constructor-arg ref="dataSourceProxy" />

      <property name="logFormatter">

         <bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">

            <property name="loggingType" value="MULTI_LINE" />

         </bean>

      </property>

   </bean> -->