[Bug 62020] New: "java.sql.SQLException: ORA-28040: No matching authentication protocol" while connecting to Oracle Datasource

[bugzilla]

https://bz.apache.org/bugzilla/show_bug.cgi?id=62020

            Bug ID: 62020
           Summary: "java.sql.SQLException: ORA-28040: No matching
                    authentication protocol" while connecting to Oracle
                    Datasource
           Product: Tomcat 8
           Version: 8.0.47
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Examples
          Assignee: dev@tomcat.apache.org
          Reporter: bhanu.c.pap...@bankofamerica.com
  Target Milestone: ----

Hi Team,

We're migrating from Tomcat 7 to Tomcat 8(Also, we're migrating Oracle 11g to
Oracle 12c). We've used the latest ojdbc7.jar and configured the required
datasource details in tomcat server.xml. But we're getting the below exception
while connecting to the Oracle Database from our application.

Exception: java.sql.SQLException: ORA-28040: No matching authentication
protocol

server.xml:

<Resource name="jdbc/AAS_DEV" auth="Container" 
                 type="oracle.jdbc.pool.OracleDataSource" 
                 driverClassName="oracle.jdbc.OracleDriver" 
                factory="oracle.jdbc.pool.OracleDataSourceFactory" 
                 url="jdbc:oracle:thin:@MASKED:49125:MASKED" 
                 user="MASKED" password="MASKED" maxActive="100" maxIdle="10"
maxWait="5000" />

Code snippet:

DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
InitialContext ic = new InitialContext();
oracle.jdbc.pool.OracleDataSource ds = (oracle.jdbc.pool.OracleDataSource)
ic.lookup("java:comp/env/" + "jdbc/AAS_DEV");

 Connection conn = ds.getConnection();

Please help us whether we're missing any configuration and let us know if you
need more details.

Thanks,
Bhanu

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@tomcat.apache.org
For additional commands, e-mail: dev-h...@tomcat.apache.org