m-szalik / dbpatch Goto Github PK

Command line password type box.

I think it would be nice to have delimiter customized. I've had problem with oracle patches - default semicolon delimiter caused execution failure. Using custom delimiter (slash sign in my case) solved the issue. Currently default delimiter is hardcoded, so I had to modify sources to set up delimiter via properties file.

https://github.com/m-szalik/dbpatch-maven-plugin.wiki.git
Need help to install

Make build possible without gradle.properties file

Steps to reproduce:

1. I used below command to run the DBPatch application

java -jar dbpatch-4.1.jar interactive ./dbpatch.properties

2. DpPatch Screen opens successfully
3. Click menu databases>conf_01 it asks password for user root I entered the correct password 3 times and it failed.

Other details:

• using mysql server: mysql-8.0.21-winx64
  -using connector driver: mysql-connector-java-5.1.46 and mysql-connector-java-8.0.21

• dbpatch.properties

conf_01.jdbcUri=jdbc:mysql://localhost:3306/liquibase_test?useSSL=false&allowPublicKeyRetrieval=true&characterEncoding=UTF-8
conf_01.username=root
conf_01.password=root
conf_01.driverClass=com.mysql.jdbc.Driver
conf_01.patchDirs=sql/

dbpatch:rollback-list : should be in reverse order. It's easier I think to imagine really what happens when the undo patch in applied.

MongoDB support

In case of no driver found error detect it and try to find in classpath or m2 repository if available.

Standalone application can read property file and search for drivers to download then add it to classpath.

Allow to specify database connection from scratch.