webMethods

 View Only
Expand all | Collapse all

Jdbc Adapter Connection Issue

  • 1.  Jdbc Adapter Connection Issue

    Posted Wed June 19, 2024 02:01 AM

    I’m trying to create a connection and have entered all the necessary information, but I keep receiving this error. I’ve tried creating connections with different connections, reinstalling the Oracle database, and placing the necessary jars, but the problem persists.
    Additionally, sometimes after 1000 attempts, I succeed once and the connection is immediately enabled again. I would appreciate any assistance.

    ERROR :
    Error encountered

    [ART.118.5011] Adapter Runtime (Connection): Unable to create new connection JDBC_Connection.connection:OracleDatabase. [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”. Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=localhost))(CONNECT_DATA=(SID=XE)))


    #Universal-Messaging-Broker
    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 2.  RE: Jdbc Adapter Connection Issue

    Posted Wed June 19, 2024 09:22 AM

    Hi Manikanta,

    please provide your IS version, JDBC Adapter version, Database Version and Driver version.
    Any Fixes applied to IS and JDBC Adapter?

    Are you able to connect to the database with another client, i.e. Oracle SQL Developer?

    Regards,
    Holger


    #Universal-Messaging-Broker
    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 3.  RE: Jdbc Adapter Connection Issue

    Posted Wed June 19, 2024 11:22 AM

    My gut feeling is that this the first point to check.

    What is your OS? Have you checked that the DB is actually listening on the port?

    What IP address does localhost point to? Some Linux distros do funny changes to /etc/hosts out-of-the-box.


    #Universal-Messaging-Broker
    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 4.  RE: Jdbc Adapter Connection Issue

    Posted Wed June 19, 2024 11:41 AM

    Hi Christoph,

    in this case it might be a good idea to try with explicit 127.0.0.1 address.

    Regards,
    Holger


    #Integration-Server-and-ESB
    #Universal-Messaging-Broker
    #Adapters-and-E-Standards
    #webMethods


  • 5.  RE: Jdbc Adapter Connection Issue

    Posted Thu June 20, 2024 03:18 AM

    Hi @Holger_von_Thomsen,

    I’ve included the necessary information you requested; please study it.

    IS version = 10.15
    JDBC Adapter version = 10.3
    Database Version = 10.2.0.1.0 (Oracle Database 10g Express Edition)
    Any Fixes applied to IS and JDBC Adapter =I recently changed my licence key, however the problem persisted even before.

    http://127.0.0.1:8080/apex/f?p=4500:1003:2337244119763506::NO::: I’m connecting to my local Oracle database using this URL.

    Thanks,
    Manikanta Anisetti.


    #webMethods
    #Adapters-and-E-Standards
    #Universal-Messaging-Broker
    #Integration-Server-and-ESB


  • 6.  RE: Jdbc Adapter Connection Issue

    Posted Fri June 21, 2024 09:47 AM

    Try connecting using the same port. You tested with a different protocol. Port 8080 can be functional while 1521 is disabled somewhere.


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #Universal-Messaging-Broker


  • 7.  RE: Jdbc Adapter Connection Issue