Forum Discussion

mukulgupta's avatar
mukulgupta
Occasional Contributor
3 years ago

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-authentication-protocol/m-p/171026

 

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

  • nmrao's avatar
    nmrao
    Champion Level 3
    You should also check in oracle forums for quick help
  • Jacobsonl's avatar
    Jacobsonl
    Occasional Visitor

    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's avatar
    richie
    Community Hero
    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