Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: AS400 DB Connection issue - INSERT / UPDATE STEP in Transformation

  1. #1
    Join Date
    Feb 2011
    Posts
    5

    Default AS400 DB Connection issue - INSERT / UPDATE STEP in Transformation

    Hi All,
    I am getting below error when I try to connect AS400 with Native JDBC. Also I am using connection pooling. I am getting this connection issue frequently. I am using Spoon 4.2.0-RC1. Spoon uses jt400.jar to connect.
    I am using Insert / Update steps in the transformation to connect DB. Also I am using few Insert / Update steps in the same transformation.
    Is there any other way to this connection issue? Please advice.

    ERROR 25-10 05:20:44,128 - Insert / Update - ZBBPOR1PF - Unexpected error
    ERROR 25-10 05:20:44,128 - Insert / Update - ZBBPOR1PF - org.pentaho.di.core.exception.KettleDatabaseException:
    Unable to prepare statement for SQL statement [SELECT ORORDN, ORORDT, ORORPN, ORSDRT, ORREFN FROM ZBBPOR1PF WHERE ( ( ORORDN = ? ) ) AND ( ( ORORDT = ? ) ) AND ( ( ORORPN = ? ) ) AND ( ( ORSDRT = ? ) ) AND ( ( ORREFN = ? ) ) ]
    Connection is closed.

    at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.setLookup(InsertUpdate.java:392)
    at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:252)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: Connection is closed.
    at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.checkOpen(PoolingDriver.java:234)
    at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.prepareStatement(PoolingDriver.java:337)
    at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.setLookup(InsertUpdate.java:388)
    ... 3 more
    Last edited by kanags; 10-25-2013 at 06:29 AM. Reason: To put the details about my spoon version

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.