Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

2 Factor Authentication Oracle jdbc in Tomcat

user7407291Oct 24 2018 — edited Nov 2 2018

I read MOS note 1441745.1 about using SSL with Oracle's JDBC Thin Driver. 

I need some assistance on how to apply that to Tomcat.  We currently connect to our Oracle RDBMS from Tomcat with the jdbc driver .


Ideally, for this service account, we're being pushed to use 2 factor authentication (I'm fighting the idea of a service account having 2 Factor given the nature of 2 factor) but need to apply the MOS note to figure out how to better secure the password, and possibly implement a 2FA solution.

Any help would be appreciated.

Our Web.xml has the following lines:

        <context-param>

                <param-name>type</param-name>

                <param-value>SIMPLE</param-value>

        </context-param>

        <context-param>

                <param-name>datasource</param-name>

                <param-value> </param-value>

        </context-param>

        <context-param>

                <param-name>driver</param-name>

                <param-value>oracle.jdbc.OracleDriver</param-value>

        </context-param>

        <context-param>

                <param-name>url</param-name>

                <param-value>jdbc:oracle:thin:@//myserv:1521/mysid</param-value>

        </context-param>

                <context-param>

                <param-name>username</param-name>

                <param-value>myuser</param-value>

        </context-param>

                <context-param>

                <param-name>password</param-name>

                <param-value>mypass</param-value>

        </context-param>

Comments
Post Details
Added on Oct 24 2018
2 comments
541 views