jstrachan 2002/10/28 08:16:47
Added: sql/src/java/org/apache/commons/sql/task
JdbcToSchemaTask.java
Log:
applied J. Russell Smyth 's patches
a Task that uses JdbcModelReader and Betwixt to read a JDBC database
and write the CommonsSql schema for it.
Revision Changes Path
1.1
jakarta-commons-sandbox/sql/src/java/org/apache/commons/sql/task/JdbcToSchemaTask.java
Index: JdbcToSchemaTask.java
===================================================================
/*
* $Header: $
* $Revision: $
* $Date: $
*
* ====================================================================
*
* The Apache Software License, Version 1.1
*
* Copyright (c) 1999-2002 The Apache Software Foundation. All rights
* reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
*
* 1. Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
*
* 2. Redistributions in binary form must reproduce the above copyright
* notice, this list of conditions and the following disclaimer in
* the documentation and/or other materials provided with the
* distribution.
*
* 3. The end-user documentation included with the redistribution, if
* any, must include the following acknowlegement:
* "This product includes software developed by the
* Apache Software Foundation (http://www.apache.org/)."
* Alternately, this acknowlegement may appear in the software itself,
* if and wherever such third-party acknowlegements normally appear.
*
* 4. The names "The Jakarta Project", "Commons", and "Apache Software
* Foundation" must not be used to endorse or promote products derived
* from this software without prior written permission. For written
* permission, please contact [EMAIL PROTECTED]
*
* 5. Products derived from this software may not be called "Apache"
* nor may "Apache" appear in their names without prior written
* permission of the Apache Group.
*
* THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
* WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
* OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
* ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
* USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
* OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
* OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
* SUCH DAMAGE.
* ====================================================================
*
* This software consists of voluntary contributions made by many
* individuals on behalf of the Apache Software Foundation. For more
* information on the Apache Software Foundation, please see
* <http://www.apache.org/>.
*
*/
package org.apache.commons.sql.task;
import java.io.FileOutputStream;
import java.io.PrintWriter;
import java.io.IOException;
import java.io.FileWriter;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Hashtable;
import java.util.List;
import java.util.Vector;
import java.util.Iterator;
import org.apache.tools.ant.BuildException;
import org.apache.tools.ant.Task;
import org.apache.commons.sql.io.DatabaseWriter;
import org.apache.commons.sql.io.JdbcModelReader;
import org.apache.commons.sql.model.*;
/**
* This class generates an XML schema of an existing database from
* JDBC metadata.
*
* @author <a href="mailto:drfish@;cox.net">J. Russell Smyth</a>
* @version $Id: $
*/
public class JdbcToSchemaTask extends Task
{
/** Name of database schema file produced. */
protected String outputFile;
/** JDBC URL. */
protected String dbUrl;
/** JDBC driver. */
protected String dbDriver;
/** JDBC user name. */
protected String dbUser;
/** JDBC password. */
protected String dbPassword;
/** DB catalog to use. */
protected String dbCatalog;
/** DB schema to use. */
protected String dbSchema;
/** Hashtable of columns that have primary keys. */
protected Hashtable primaryKeys;
/** Hashtable to track what table a column belongs to. */
protected Hashtable columnTableMap;
protected boolean useTypeNames = false;
public String getDbSchema()
{
return dbSchema;
}
public void setDbCatalog(String dbCatalog)
{
this.dbCatalog = dbCatalog;
}
public void setDbSchema(String dbSchema)
{
this.dbSchema = dbSchema;
}
public void setDbUrl(String v)
{
dbUrl = v;
}
public void setDbDriver(String v)
{
dbDriver = v;
}
public void setDbUser(String v)
{
dbUser = v;
}
public void setDbPassword(String v)
{
dbPassword = v;
}
public void setOutputFile (String v)
{
outputFile = v;
}
public void setUseTypeNames(boolean b)
{
useTypeNames = b;
}
/**
* Default constructor.
*/
public void execute() throws BuildException
{
System.err.println("Commons-Sql JdbcToSchema starting\n");
System.err.println("Your DB settings are:");
System.err.println("driver : " + dbDriver);
System.err.println("URL : " + dbUrl);
System.err.println("user : " + dbUser);
System.err.println("password : " + dbPassword);
System.err.println("schema : " + dbSchema);
Database db = null;
try{
db = getDbFromJdbc();
DatabaseWriter w = new DatabaseWriter(new FileWriter(outputFile));
// w.setWriteIDs(true);
w.write(db);
w.close();
}catch(Exception e){
System.out.println("exception during load:"+e.getMessage());
}
}
/**
*/
public Database getDbFromJdbc() throws Exception
{
// Load the database Driver.
Class.forName(dbDriver);
System.err.println("DB driver sucessfuly instantiated");
// Attemtp to connect to a database.
Connection con = DriverManager.getConnection(dbUrl,
dbUser,
dbPassword);
System.err.println("DB connection established");
JdbcModelReader reader = new JdbcModelReader(con);
if ( dbCatalog!=null ) {
reader.setCatalog(dbCatalog);
}
if ( dbSchema!=null ) {
reader.setSchema(dbSchema);
}
Database db = reader.getDatabase();
return db;
}
}
--
To unsubscribe, e-mail: <mailto:commons-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:commons-dev-help@;jakarta.apache.org>
