springboot 配置oracle

来源：互联网发布：北京义翘神州知乎编辑：程序博客网时间：2024/04/29 06:16

1 把这2个文件发到 maven 本地仓库
mvn install:install-file -Dfile=ojdbc6.jar -DgroupId=com.oracle \
-DartifactId=ojdbc6 -Dversion=11.2.0.3.0 -Dpackaging=jar

mvn install:install-file -Dfile=xdb6.jar -DgroupId=com.oracle \
-DartifactId=xdb6 -Dversion=1.0 -Dpackaging=jar

2 repositories {
*** mavenLocal()
maven { url 'http://repo.spring.io/libs-release' }
mavenCentral()
}

3 同步一下gradle包依赖
external library 可以看到

4 修改配置文件： application.properties

##spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.driver-class-name:oracle.jdbc.driver.OracleDriver
spring.datasource.url:jdbc:oracle:thin:@192.168.0.146:1521:orcl
spring.datasource.username:lizd
spring.datasource.password:lizd
spring.jpa.hibernate.ddl-auto=create

CREATE USER lizd IDENTIFIED BY lizd;
GRANT CONNECT,RESOURCE, DBA TO username;

wget http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
rpm -ivh epel-release-7-5.noarch.rpm
yum install rlwrap

--------

mongodb
https://docs.mongodb.org/manual/tutorial/install-mongodb-on-ubuntu/
ActiveMQ
http://janvanoverveld.blogspot.jp/2015/04/installation-apache-active-mq-on-ubuntu.html
wget https://archive.apache.org/dist/activemq/5.13.0/apache-activemq-5.13.0-bin.tar.gz
mv /home/activemq/apache-activemq-5.13.0/ /opt
ln -s /opt/apache-activemq-5.13.0/bin/linux-x86-64/activemq /etc/init.d/activemq
find /opt/apache-activemq-5.13.0 -type f -name wrapper.log -o -name ActiveMQ.pid | xargs ls -latrh
/opt/apache-activemq-5.13.0/data/wrapper.log
chown -R activemq:activemq /opt/apache-activemq-5.13.0/data/wrapper.log
keytool -genkeypair -keystore ~/.keystore -alias tomcat -storepass changeit -keyalg RSA
一路回车，输入是 changeit

0 0