bizgres - bizgres: Added support for sql statement to be run on db - Mailing list pgsql-committers

From nwakefield@pgfoundry.org (User Nwakefield)
Subject bizgres - bizgres: Added support for sql statement to be run on db
Date
Msg-id 20060308013029.81AB1103381A@pgfoundry.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Added support for sql statement to be run on db connection, such as the setting of the search_path on postgresql.
Added support for pre and post sql to run on the JDBCWriter.

Modified Files:
--------------
    bizgres/KETL/src/com/kni/etl/ketl/writer:
        JasperReportWriter.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/writer/JasperReportWriter.java.diff?r1=1.2&r2=1.3)
        NIOFileWriter.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/writer/NIOFileWriter.java.diff?r1=1.2&r2=1.3)
        JDBCWriter.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/writer/JDBCWriter.java.diff?r1=1.1&r2=1.2)
        JDBCNonBatchedWriter.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/writer/JDBCNonBatchedWriter.java.diff?r1=1.1&r2=1.2)
    bizgres/KETL/src/com/kni/etl/sessionizer:
        PGCopySessionizationWriterRoot.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/sessionizer/PGCopySessionizationWriterRoot.java.diff?r1=1.2&r2=1.3)
        PageParserPageDefinition.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/sessionizer/PageParserPageDefinition.java.diff?r1=1.1&r2=1.2)
        XMLSessionizeJob.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/sessionizer/XMLSessionizeJob.java.diff?r1=1.2&r2=1.3)
        SessionizationWriterRoot.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/sessionizer/SessionizationWriterRoot.java.diff?r1=1.2&r2=1.3)
        JDBCSessionizationWriterRoot.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/sessionizer/JDBCSessionizationWriterRoot.java.diff?r1=1.2&r2=1.3)
        PGCopyWriter.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/sessionizer/PGCopyWriter.java.diff?r1=1.1&r2=1.2)
    bizgres/KETL/src:
        KETL.jardesc (r1.2 -> r1.3)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/KETL.jardesc.diff?r1=1.2&r2=1.3)
    bizgres/KETL/src/com/kni/etl/dbutils:
        SourceColumnDefinitionHelper.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/dbutils/SourceColumnDefinitionHelper.java.diff?r1=1.1&r2=1.2)
        PooledConnection.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/dbutils/PooledConnection.java.diff?r1=1.1&r2=1.2)
        ResourcePool.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/dbutils/ResourcePool.java.diff?r1=1.2&r2=1.3)
        Upsert.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/dbutils/Upsert.java.diff?r1=1.2&r2=1.3)
    bizgres/KETL/src/com/kni/etl:
        SQLJobExecutor.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/SQLJobExecutor.java.diff?r1=1.1&r2=1.2)
        EngineConstants.java (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/EngineConstants.java.diff?r1=1.3&r2=1.4)
        ParallelStreamParser.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ParallelStreamParser.java.diff?r1=1.1&r2=1.2)
        ParallelChannelParser.java (r1.2 -> r1.3)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ParallelChannelParser.java.diff?r1=1.2&r2=1.3)
        SQLJob.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/SQLJob.java.diff?r1=1.1&r2=1.2)
        ChannelParser.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ChannelParser.java.diff?r1=1.1&r2=1.2)
    bizgres/KETL/src/com/kni/etl/ketl/transform:
        JDBCIncrementer.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/transform/JDBCIncrementer.java.diff?r1=1.1&r2=1.2)
        CleanURL.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/transform/CleanURL.java.diff?r1=1.1&r2=1.2)
    bizgres/KETL/src/com/kni/etl/ketl/reader:
        JDBCColumnScanner.java (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/reader/JDBCColumnScanner.java.diff?r1=1.3&r2=1.4)
        JDBCReader.java (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/reader/JDBCReader.java.diff?r1=1.3&r2=1.4)
        JDBCTableScanner.java (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/reader/JDBCTableScanner.java.diff?r1=1.3&r2=1.4)
    bizgres/KETL/src/com/kni/etl/ketl/transformation:
        LookupTransformation.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/transformation/LookupTransformation.java.diff?r1=1.1&r2=1.2)
        JDBCIncrementer.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/transformation/JDBCIncrementer.java.diff?r1=1.1&r2=1.2)
    bizgres/KETL/src/com/kni/etl/ketl:
        ETLInput.java (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/ETLInput.java.diff?r1=1.3&r2=1.4)
        ETLStep.java (r1.3 -> r1.4)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/ETLStep.java.diff?r1=1.3&r2=1.4)
    bizgres/KETL/src/com/kni/etl/urltools:
        URLCleaner.java (r1.1 -> r1.2)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/urltools/URLCleaner.java.diff?r1=1.1&r2=1.2)

Added Files:
-----------
    bizgres/KETL/src/com/kni/etl/ketl/writer:
        JDBCDeleter.java (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/writer/JDBCDeleter.java?rev=1.1&content-type=text/x-cvsweb-markup)
    bizgres/KETL/src/com/kni/util:
        LRUCache.java (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/util/LRUCache.java?rev=1.1&content-type=text/x-cvsweb-markup)
    bizgres/KETL/src/com/kni/etl/ketl:
        DBConnection.java (r1.1)

(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/bizgres/bizgres/KETL/src/com/kni/etl/ketl/DBConnection.java?rev=1.1&content-type=text/x-cvsweb-markup)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Further examination of ltsReleaseBlock usage shows that it's got
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Update /contrib regression tests for escape_string_warning.