mukulgupta
Occasional Contributor
Joined 10 years ago
User Profile
User Widgets
Contributions
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.6KViews0likes3CommentsGetting error message while running the Sybase DB query
Hello everyone, I am getting the error "Error getting response;null" while running the Sybase DB query in SOPAUI jdbc step ERROR:com.sybase.jdbc2.utils.UnimplementedOperationException: The method com.sybase.jdbc2.tds.RowFormatToken.getTableName has not been completed and should not be called. PS- I am able to successfully test Sybase DB connection and query is also working (tested it in DbVisualizer). com.sybase.jdbc2.jdbc.SybDriver jdbc:sybase:Tds:dBname:4000?user=username&password=password query type- Select * from tablename where NDC=475 and HLR=11 and REGION = 33 and SN= 540000 I am using jconn2 jar and SoapUi Version is 5.3.0 Thanks784Views0likes0CommentsIs HermesJMS not supported by JAVA 8?
Hi Everyone, I am not able to start HermesJMS from SOAPUI. It was running fine with Java version 7 but as I changed the version of Java to 8, it has stopped working. is it not supported? or are there any changes to be made to run it with java8? Thanks in advance Cheers, Mukul Gupta2.5KViews0likes4CommentsError getting response; javax.net.ssl.SSLHandshakeException: Remote host closed
Hi Everyone, I am struggling with below error from past few days Error getting response; javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake I have imported the SSL keystore and it's status is ok. But when i am sending the soap request, gettting error. PFA snap. Please let me know if any setting needs to be changed. Thanks1.3KViews0likes0CommentsRe: can we access websphere default messaging provider queues from SOAPUI-HermesJMS?
Geetting error while trying to connect to websphere8 default messaging provider using following jars using hermesJMS com.ibm.ws.orb_8.0.0.jar com.ibm.was.sib.client.thin.jms_8.0.0.jar com.ibm.ws.ejb.thinclient_8.0.0.jar Error- javax.naming.NamingException: Error getting WsnNameService properties [Root exception is org.omg.CORBA.TRANSIENT: initial and forwarded IOR inaccessible vmcid: 0x4942f000 minor code: 3591 completed: No1.5KViews0likes0CommentsHow to connect Websphere Default Messaging provider using Hermes JMS?
Hello everyone, Someone please help me here. I am not able to connect to Websphere Default Messaging provider using HermesJMS. Any lead will help me. I have tried it with com.ibm.mq.jms.MQQueueConnectionFactory and hermes.JNDIQueueConnectionFactory, Details to connect ProviderURL=corbaloc:iiop:localhost:2809 JNDIFACTORY=com.ibm.websphere.naming.WsnInitialContextFactory JMSFACTORY=qcf_poc Thanks a lot in advance.763Views0likes0Comments