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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
