FDMEE OIA Jython Script Issue

@orcle

Hi ,

Can some one help me with the below jython script. I have a requirment to pull PO details from oracle table. Its on FDMEE 11.1.2.3.500.  I can execute the script without any issue but it pulls only one row from the source table. Not sure if i missed array or looping condition.

My assumption is Next () will pull all the records.

Script

import java.text.SimpleDateFormat as SimpleDateFormat

import java.sql as sql

batchName = "Batch_PO"

insertStmt = """

INSERT INTO AIF_OPEN_INTERFACE (

    BATCH_NAME, COL01, COL2, COL3, COL5, AMOUNT )

VALUES (?,?,?)

""""""

sourceConn = sql.DriverManager.getConnection("jdbc:oracle:thin:@orcle.com:0000:orcl"," apps", "password");