Skip to Content
avatar image
Former Member

JDBC Adapter ERROR

Hi experts,

We found this error occurs in message monitoring of xi RWB when sending data to DB by JDBC Adapter.

<i>Attempt to establish database connection failed with SQL error

com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@<IP>:1521:ORACG': SQLException: Listener refused the connection with the following error: ORA-12500, TNS:listener failed to start a dedicated server process The Connection descriptor used by the client was: <IP>:1521:ORACG</i>

The most strange to me is that this error occurs is not always but occasionally.

I am sure that the network is ok when the error occurs.

our Oracle DB : Oracle 9.2

Can somebody help me?

Thanks

Terry

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 27, 2007 at 09:09 AM

    Hi Terry,

    Try using the option "Disconnect databse connection after processing each message".

    Regards,

    Jai Shankar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 27, 2007 at 09:14 AM

    Hi,

    For each open connection a entry is made j2ee stack.So when the it reaches to max and execption is thrown.

    In Jdbc adapter configuration -> advance mode -> Set -> Disconnect from the database after processing each message.

    Should solve the prob

    <b>Cheers,

    *RAJ*

    *REWARD POINTS IF FOUND USEFULL*</b>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 27, 2007 at 09:36 AM

    Hi,

    Thank you for your replies.

    I found that the option "Disconnect databse connection after processing each message" of my channel has checked. So, it looks like that the DB connection reaches to max at that time.What can i do is increasing the max connection number of our DB.

    Any ideas?

    Regards,

    Terry

    Add comment
    10|10000 characters needed characters exceeded