Write a CSV file to database1

/*

 * Copyright (c) 2006-2008 North Concepts Inc.  All rights reserved.

 * Proprietary and Confidential.  Use is subject to license terms.

 *

 * http://northconcepts.com/data-pipeline/licensing/

 *

 */

package com.northconcepts.datapipeline.examples.cookbook;



import java.io.File;

import java.sql.Connection;

import java.sql.Driver;

import java.util.Properties;



import com.northconcepts.datapipeline.core.DataReader;

import com.northconcepts.datapipeline.core.DataWriter;

import com.northconcepts.datapipeline.csv.CSVReader;

import com.northconcepts.datapipeline.jdbc.JdbcWriter;

import com.northconcepts.datapipeline.job.JobTemplate;



public class WriteACsvFileToDatabase1 {

    

    public static void main(String[] args) throws Throwable {

        // connect to the database

        Driver driver = (Driver) Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

        Properties properties = new Properties();

        properties.put("user", "scott");

        properties.put("password", "tiger");

        Connection connection = driver.connect("jdbc:odbc:dp-cookbook", properties);



        DataReader reader = new CSVReader(new File("credit-balance.csv"))

            .setFieldNamesInFirstRow(true);

        

        DataWriter writer = new  JdbcWriter(connection, "dp_credit_balance")

            .setAutoCloseConnection(true);

        

        JobTemplate.DEFAULT.transfer(reader, writer);

    }



}
back to examples index