com.sun.jdo.api.persistence.mapping.ejb.CaptureSchema Maven / Gradle / Ivy
/*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
*
* Copyright (c) 1997-2013 Oracle and/or its affiliates. All rights reserved.
*
* The contents of this file are subject to the terms of either the GNU
* General Public License Version 2 only ("GPL") or the Common Development
* and Distribution License("CDDL") (collectively, the "License"). You
* may not use this file except in compliance with the License. You can
* obtain a copy of the License at
* https://glassfish.dev.java.net/public/CDDL+GPL_1_1.html
* or packager/legal/LICENSE.txt. See the License for the specific
* language governing permissions and limitations under the License.
*
* When distributing the software, include this License Header Notice in each
* file and include the License file at packager/legal/LICENSE.txt.
*
* GPL Classpath Exception:
* Oracle designates this particular file as subject to the "Classpath"
* exception as provided by Oracle in the GPL Version 2 section of the License
* file that accompanied this code.
*
* Modifications:
* If applicable, add the following below the License Header, with the fields
* enclosed by brackets [] replaced by your own identifying information:
* "Portions Copyright [year] [name of copyright owner]"
*
* Contributor(s):
* If you wish your version of this file to be governed by only the CDDL or
* only the GPL Version 2, indicate your decision by adding "[Contributor]
* elects to include this software in this distribution under the [CDDL or GPL
* Version 2] license." If you don't indicate a single choice of license, a
* recipient has the option to distribute your version of this file under
* either the CDDL, the GPL Version 2 or to extend the choice of license to
* its licensees as provided above. However, if you add GPL Version 2 code
* and therefore, elected the GPL Version 2 license, then the option applies
* only if the new code is made subject to such option by the copyright
* holder.
*/
// Portions Copyright [2019] [Payara Foundation and/or its affiliates]
/*
* CaptureSchema.java
*
* Created on March 15, 2002, 4:02 PM
*/
package com.sun.jdo.api.persistence.mapping.ejb;
import org.netbeans.modules.dbschema.*;
import org.netbeans.modules.dbschema.jdbcimpl.*;
import org.netbeans.modules.dbschema.util.*;
import java.io.*;
import java.util.ResourceBundle;
import java.sql.ResultSet;
import java.sql.DatabaseMetaData;
import java.util.Map;
import java.util.HashMap;
import java.util.List;
import java.util.LinkedList;
import java.util.Iterator;
import java.text.MessageFormat;
/**
*
* @author vkraemer
* @version 1.0
*/
public class CaptureSchema {
/** Required filename extension. */
private static final String OUTPUTFILE_EXTENSION = ".dbschema"; // NOI18N
private static final String PASSWORD_MASK_STRING = "Protected value, not to be logged"; // NOI18N
/** Creates new CaptureSchema */
public CaptureSchema() {
}
public static void main(String args[]) {
int help = 0;
ResourceBundle bundle =
ResourceBundle.getBundle("com.sun.jdo.api.persistence.mapping.ejb.Bundle"); // NOI18N
String driver=bundle.getString("STRING_ORACLE_DRIVER_NOI18N"); //NOI18N
String username=bundle.getString("STRING_IASCTS_NOI18N"); //NOI18N
String password=bundle.getString("STRING_IASCTS_NOI18N"); //NOI18N
String dburl=null;
String dbschemaname = null;
String outfile = null;
LinkedList tableList = new LinkedList();
LinkedList vList = new LinkedList();
try {
for (int i=0; i -1 && //NOI18N
(null == dbschemaname || dbschemaname.length() == 0)) {
// this argument combo has problems. print an error message and exit
System.err.println(bundle.getString("ERR_ORACLE_ARGUMENTS")); //NOI18N
err_flag=true;
return;
}
if (tableList.size() == 0) {
outSchemaImpl.initTables(cp);
}
else {
pruneTableList(tableList, cp,bundle);
if (tableList.size() > 0)
outSchemaImpl.initTables(cp, tableList,vList,false);
else {
System.err.println(bundle.getString("MESSAGE_NO_VALID_TABLES")); //NOI18N
err_flag=true;
return;
}
}
System.out.println(bundle.getString("MESSAGE_SCHEMA_CAPTURED")); //NOI18N
System.out.println(bundle.getString("MESSAGE_SAVING_SCHEMA")); //NOI18N
OutputStream outstream = new FileOutputStream(outfile);
se.save(outstream);
}
catch (java.lang.ClassNotFoundException cnfe) {
System.err.println(bundle.getString("ERR_CHECK_CLASSPATH")); //NOI18N
cnfe.printStackTrace(System.err); //NOI18N
err_flag=true;
}
catch (Throwable exc) {
exc.printStackTrace(System.err); //NOI18N
err_flag=true;
}
finally {
if (cp != null) {
cp.closeConnection();
}
}
System.exit(err_flag ? 1 : 0);
}
private static void pruneTableList(List tableList, ConnectionProvider cp,
ResourceBundle bundle) throws java.sql.SQLException {
ResultSet rs;
DatabaseMetaData dmd = cp.getDatabaseMetaData();
Map tables = new HashMap();
String catalog = cp.getConnection().getCatalog();
String user = cp.getSchema();
rs = dmd.getTables(catalog, user, "%", new String[] {"TABLE"}); //NOI18N
if (rs != null) {
while (rs.next()) {
String tn = rs.getString("TABLE_NAME").trim(); //NOI18N
tables.put(tn,tn);
}
rs.close();
}
Iterator iter = tableList.iterator();
String [] args = new String[1];
while (iter.hasNext()) {
String s = (String) iter.next();
if (null == tables.get(s.trim())) {
iter.remove();
args[0] = s;
System.err.println(MessageFormat.format(bundle.getString("ERR_INVALID_TABLE_GIVEN"), (Object []) args)); //NOI18N
}
}
}
static class PropChangeReport implements java.beans.PropertyChangeListener {
public void propertyChange(java.beans.PropertyChangeEvent pce) {
//System.err.println(pce); //NOI18N
}
}
}