import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;


/**
 * Created by joander on 08/05/17.
 */
public class Import {

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

        PreparedStatement pstmt = null;
        Connection conn = null;
        FileInputStream in = null;
        try {

            System.out.println( "inicio" );

            String path =
                "/home/joander/developer/algar/algarcrm/source/algarcrm/source/scripts/workflow/AC_Enviar_Documento_Cliente.xml";

            String sql = "UPDATE ALGARCRM.OS_WORKFLOWDEFS SET WF_DEFINITION = ?  WHERE WF_NAME = 'AC_Enviar_Documento_Cliente'";

            //Sales_Order_v2
            //AC_Activity_Equipment_Delivery

            //HOMOLOGACAO
            DriverManager.registerDriver( (Driver) Class.forName( "oracle.jdbc.driver.OracleDriver" ).newInstance() );
            conn = DriverManager.getConnection( "jdbc:oracle:thin:@10.11.133.188:1521:crmhbase", "algarcrmdev", "alga4crmdev$" );
            conn.setAutoCommit( false );

            pstmt = conn.prepareStatement( sql );

            File blob = new File( path );
            in = new FileInputStream( blob );

            pstmt.setBinaryStream( 1, in, (int) blob.length() );

            pstmt.executeUpdate();
            conn.commit();

            System.out.println( "fim" );

        } catch ( Exception e ) {
            e.printStackTrace();

        } finally {
            pstmt.close();
            conn.close();
            in.close();
        }
    }
}