Ask a Question

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

mukulgupta
Occasional Contributor

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

Team,

The solution mentioned below post doesn't work for me

https://community.smartbear.com/t5/SoapUI-Open-Source/JDBC-connectivity-issue-No-matching-authentica...

 

We recently migrated from Oracle 11g (Edition release 11.2.0.4) to Oracle 19C (Enterprise Edition - 19.0.0.0) and started facing this issue. Below connection, strings work fine for Oracle 11 but for Oracle 19 it is giving an issue.

Connection String  -- jdbc:oracle:thin:myUser/myPass@myHost:myPort:myDB 

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

 

PS -- With plain java code in eclipse, we are able to connect both. Don't know why SOAPUI is throwing such an error.

 

Error Log

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

               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)

               at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

               at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)

               at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)

               at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:295)

               at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)

               at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)

               at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

               at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

               at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802)

               at com.eviware.soapui.support.GroovyUtils$DriverProxy.connect(GroovyUtils.java:148)

               at java.sql.DriverManager.getConnection(Unknown Source)

               at java.sql.DriverManager.getConnection(Unknown Source)

               at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:62)

               at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcRequestTestStepDesktopPanel$TestConnectionAction.actionPerformed(JdbcRequestTestStepDesktopPanel.java:631)

               at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

               at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

               at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

               at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

               at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

               at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)

               at java.awt.Component.processMouseEvent(Unknown Source)

               at javax.swing.JComponent.processMouseEvent(Unknown Source)

               at java.awt.Component.processEvent(Unknown Source)

               at java.awt.Container.processEvent(Unknown Source)

               at java.awt.Component.dispatchEventImpl(Unknown Source)

               at java.awt.Container.dispatchEventImpl(Unknown Source)

               at java.awt.Component.dispatchEvent(Unknown Source)

               at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

               at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

               at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

               at java.awt.Container.dispatchEventImpl(Unknown Source)

               at java.awt.Window.dispatchEventImpl(Unknown Source)

               at java.awt.Component.dispatchEvent(Unknown Source)

               at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

               at java.awt.EventQueue.access$500(Unknown Source)

               at java.awt.EventQueue$3.run(Unknown Source)

               at java.awt.EventQueue$3.run(Unknown Source)

               at java.security.AccessController.doPrivileged(Native Method)

               at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

               at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

               at java.awt.EventQueue$4.run(Unknown Source)

               at java.awt.EventQueue$4.run(Unknown Source)

               at java.security.AccessController.doPrivileged(Native Method)

               at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

               at java.awt.EventQueue.dispatchEvent(Unknown Source)

               at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

               at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

               at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

               at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

               at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

               at java.awt.EventDispatchThread.run(Unknown Source)

 

3 REPLIES 3
nmrao
Community Hero

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

You should also check in oracle forums for quick help


Regards,
Rao.
Jacobsonl
Occasional Visitor

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

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

 

public class JDBC2 {

 

 

public static void main(String[] args) {

	// TODO Auto-generated method stub

 

 

MyAARPMedicare

richie
Community Hero

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

Hey @mukulgupta

The issue youre having is typically due to a mismatch between the jre, the jdbc driver and the database youre trying to connect to.

Have you checked?

1. The version of java needed by oracle 19?
2. The version of jdbc driver matches the java version?
3. The bit type (dunno what else to call it, i mean ensure everything ia consistent...either everything 32bit or everything 64bit...you cant mix and match)

Ta

Rich


T
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
cancel
Showing results for 
Search instead for 
Did you mean: