/**
 *
 * Copyright (c) 2001 ebXMLsoft Inc.  All rights reserved.
 *
 */

import javax.sql.*;
import java.util.*;
import java.io.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
import org.xml.sax.ContentHandler;
import org.exolab.castor.jdo.*;
import org.exolab.castor.util.*;
import org.exolab.castor.xml.*;
import org.exolab.castor.mapping.Mapping;
import org.apache.xml.serialize.*;
import mortgage.*;


public class Mortgage_unmarshal
{

    // database configuration file
    public static final String DatabaseFile = "database.xml";
    // mapping file
    public static final String MappingFile = "mapping.xml";

    private Mapping  _mapping;

    private JDO      _jdo;

    private Mortgage _mortgage;


    public void Prepenv( PrintWriter writer )
        throws Exception
    {

        // Load the mapping file
        _mapping = new Mapping( getClass().getClassLoader() );
        _mapping.setLogWriter( writer );
        _mapping.loadMapping( getClass().getResource( MappingFile ) );

        _jdo = new JDO();
        _jdo.setLogWriter( writer );
        _jdo.setConfiguration( getClass().getResource( DatabaseFile ).toString() );
        _jdo.setDatabaseName( "ebdb" );
    }


    public void run( PrintWriter writer )
        throws Exception
    {
        Database        db;
        QueryResults    results;

        db = _jdo.getDatabase();

        writer.println( "Begin transaction" );

       System.out.println("Unmarshalling mortgage");
       _mortgage = Mortgage.unmarshal(new FileReader("mortgage.xml"));

      // Insert mortgage
       db.begin();
       writer.println( "Insert mortgage ..." );
       db.create(_mortgage);
       db.commit();


       db.close();

    }


    public static void main( String[] args )
    {
        PrintWriter   writer;
        Mortgage_unmarshal mortgage_unmarshal = new Mortgage_unmarshal();

        writer = new Logger( System.out ).setPrefix( "mortgage_unmarshal" );
        try {
            mortgage_unmarshal.Prepenv( writer );
            mortgage_unmarshal.run( writer );
        } catch ( Exception except ) {
            writer.println( except );
            except.printStackTrace( writer );
        }
    }


}