Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Unable to pre-load connection to the connection pool

  1. #1

    Default Unable to pre-load connection to the connection pool

    Hi:

    We are using Kettle 2.5.0 GA [ build 25002 from 2007/05/04 00:20:04 ]

    Operating System is linux

    # uname -a
    Linux <hostname> 2.6.9-42.EL #1 Wed Jul 12 23:16:43 EDT 2006 i686 i686 i386 GNU/Linux

    and Database is Oracle 10g (Release 10.2.0.1.0)

    While running ETL, we get following error:

    Error occured while trying to connect to the database
    Error occured while trying to connect to the database
    Unable to pre-load connection to the connection pool
    Network error IOException: Connection refused


    Please note that:
    1. This issue doesn't occur with Windows+Sql server 2005 environment. It happens only with Linux+Oracle 10g environment.
    2. I can connect to Oracle through sqlplus using the same user name and password specified in shared.xml
    3. I tried creating a sample transformation (that selects from a table) inside spoon and I was able to execute the transformation without running into any error.

    Max Pool size specified in shared.xml is 10 as shown below:

    <attributes>
    <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
    <attribute><code>MAXIMUM_POOL_SIZE</code><attribute>10</attribute></attribute>
    <attribute><code>PORT_NUMBER</code><attribute>1521</attribute></attribute>
    <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
    <attribute><code>USE_POOLING</code><attribute>Y</attribute></attribute>
    </attributes>

    Any idea?

    Thanks
    Tapasvi

  2. #2

    Default

    Please ignore the message I posted earlier. Issue is with our customized ETL environment.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.