geterrors.bsh

来自「opennms得相关源码 请大家看看」· BSH 代码 · 共 51 行

//  $Id: geterrors.bsh 1158 2004-11-10 22:12:21Z djgregor $

/*
 *   THIS SCRIPT IS DESTRUCTIVE ON THE DATABASE!
 *
 *   It attempts to drop the iplike and eventtime functions.
 */

/*
 * You'll want to do something like this:
 *   java -cp <somewhere>/bsh-2.0b1.jar:../../../lib/pg74.215.jdbc3.jar \
 *     -Djdbc.drivers=org.postgresql.Driver bsh.Interpreter geterrors.bsh
 */

import java.sql.*;

public SQLException doIt(Statement st, String cmd) {
	try {     
		ResultSet rs = st.executeQuery(cmd);
	} catch (SQLException e) {
		return e;
	}

	return null;
}

public void printIt(SQLException e) {
	if (e == null) {
		print("null");
		return;
	}
	print("message: " + e);
	print("state: " + e.getSQLState());
}

db = DriverManager.getConnection("jdbc:postgresql:opennms", "opennms", "");
st = db.createStatement();

SQLException e;

printIt(doIt(st, "SELECT MAX(notifyId) as max FROM notifications"));
printIt(doIt(st, "SELECT MAX(asdfasdf) as max FROM notifications"));
printIt(doIt(st, "SELECT MAX(asdfasdf) as max FROM asdfasdfasf"));
printIt(doIt(st, "insert into distPoller (dpName, dpIP, dpComment, dpDiscLimit, dpLastNodePull, dpLastEventPull, dpLastPackagePush, dpAdminState, dpRunState) values ('localhost', '127.0.0.1', 'This is the default poller.', 0.10, null, null, null, 1, 1);"));
printIt(doIt(st, "DROP FUNCTION iplike(text,text)"));
printIt(doIt(st, "DROP FUNCTION eventtime(text)"));

exit();

EOF