A simple tool for dump data and get ddl from oracle db.
To start, go to official oracle site and download ojdbc8.jar https://www.oracle.com/technetwork/database/features/jdbc/jdbc-ucp-122-3110062.html
git clone git@github.com:amemifra/Spring-Jython.git
./mvnw install:install-file -Dfile=./ojdbc8.jar -DgroupId=com.oracle -DartifactId=ojdbc8 -Dversion=12.2.0.1 -Dpackaging=jar
./mvnw clean package
java -jar target/oracle-exporter-1.0.0-SNAPSHOT.jar --debug
To dump with default settings
GET http://localhost:8080/api/dump/download/{filename}
Note: Instead of {filename} - you must set awaited file name on exit. For example:
GET http://localhost:8080/api/dump/download/my_awesome_dump_from_oracle.sql
To dump with specific settings
POST http://localhost:8080/api/dump/download/{filename}
{
"host": "localhost",
"port": "1521",
"sid": "XE",
"username": "scott",
"password": "tiger"
}
To dump with service name instead of sid
{
"host": "localhost",
"port": "1521",
"serviceName": "XE"
}
Or specify full url
{
"url": "jdbc:oracle:thin:@localhost:1521:XE"
}
Or specify full url with custom role and username
{
"url": "jdbc:oracle:thin:@localhost:1521:XE",
"username": "system",
"password": "oracle"
}
Note: If some setting wont set, it will be replaced with default one. It's mean - if you don't send password, default password will be used.
| Key | Default Value |
|---|---|
| SERVER_PORT | 8080 |
| DB_URL | jdbc:oracle:thin:@localhost:1521:XE |
| DB_USERNAME | system |
| DB_PASSWORD | oracle |
| LOG_LEVEL | INFO |
| SECURITY_ENABLED | false |
| APP_USER | admin |
| APP_PASSWORD | admin123 |
Note: To turn on basic security pass true to SECURITY_ENABLED env
docker build -t oracle-exporter .
docker run -e "DB_URL=jdbc:oracle:thin:@192.168.1.1:1521:XE" -e "DB_USERNAME=scott" -e "DB_PASSWORD=tiger" -p 8080:8080 --name oracle-exporter -t oracle-exporter