Potentially refactor JDBC tool to just already existing Jython interpreter on server

[jasonwjones]

/opt/Oracle/Middleware/oracle_common/util/jython/ contains jython. jar, and it even works to just run such as:

java -jar jython.jar

This could potentially open up converting the JDBC runner to a simple Jython script, then swapping the JDK for a JRE

[jasonwjones]

Or maybe even use existing JDBC driver on system... need extra parameter?

jdbc:weblogic:sqlserver://db:1433;databaseName=EPM_EAS;loadLibraryPath=/opt/Oracle/Middleware/wlserver_10.3/server/lib

[jasonwjones]

Despite best efforts it doesn't want to connect:

    java -cp .:/opt/Oracle/Middleware/wlserver_10.3/server/lib/wlsqlserver.jar SimpleJdbcRunner \
    -driver weblogic.jdbc.sqlserver.SQLServerDriver \
    -url jdbc:weblogic:sqlserver://$SQL_HOST:1433;loadLibraryPath=/opt/Oracle/Middleware/wlserver_10.3/server/lib
    -username sa \
    -password "$SQL_PASSWORD" \
    -query "CREATE DATABASE FOO"

Unable to connect to database on attempt 1, waiting 5s before attempting again, will try 4 more times

[jasonwjones]

Almost work but Java still seems to be trying Kerberos auth:

    java -cp .:/opt/Oracle/Middleware/wlserver_10.3/server/lib/wlsqlserver.jar SimpleJdbcRunner \
    -driver weblogic.jdbc.sqlserver.SQLServerDriver \
    -url jdbc:weblogic:sqlserver://$SQL_HOST:1433;AuthenticationMethod=userIdPassword;User=sa;Password=$SQL_PASSWORD
    -username sa \
    -password "$SQL_PASSWORD" \
    -query "CREATE DATABASE FOO"