use of ArrayList with scriptella

25 views
Skip to first unread message

maher hattabi

unread,
Aug 23, 2017, 12:35:01 PM8/23/17
to Scriptella ETL

I am using trying to copying column of an oracle with scriptella , i would like to insert them into an ArrayList combining scriptella and janino , in order to use them and compare them later ,

here what i did


<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd">
<etl>
    <description>
        test script Pour table article
    </description>
    <connection id="in" driver="oracle"
        url="jdbc:oracle:thin:@localhost:1521:XE" user="IPTECH" password="IPTECH" />

    <connection id="out" driver="postgresql"
        url="jdbc:postgresql://localhost:5432/gemodb" user="postgres"
        password="maher" />
    <connection id="janino" driver="janino" />

    <query connection-id="in">
        select code,libelle from TMP_STRUCTURE;
        <script connection-id="janino">
            import java.util.*;
            import java.io.*;
            Boolean result=false;
            ArrayList<String> obj = new ArrayList <String>();
            String code =get("code").toString();
            obj.add(code);
        </script>
    </query>
</etl>
I got the following issue
 Unable to parse document: org.xml.sax.SAXParseException; systemId: file:/C:/Users/MHT/eclipse-workspace/Scriptella/test.xml; lineNumber: 23; columnNumber: 5; The element type "String" must be terminated by the matching end-tag "</String>".
Thanks a lot .
Reply all
Reply to author
Forward
0 new messages