Java DbException.toSQLException方法代码示例

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * Change the ignore list. The ignore list is a comma separated list of
 * common words that must not be indexed. The default ignore list is empty.
 * If indexes already exist at the time this list is changed, reindex must
 * be called.
 *
 * @param conn the connection
 * @param commaSeparatedList the list
 */
public static void setIgnoreList(Connection conn, String commaSeparatedList)
        throws SQLException {
    try {
        init(conn);
        FullTextSettings setting = FullTextSettings.getInstance(conn);
        setIgnoreList(setting, commaSeparatedList);
        Statement stat = conn.createStatement();
        stat.execute("TRUNCATE TABLE " + SCHEMA + ".IGNORELIST");
        PreparedStatement prep = conn.prepareStatement("INSERT INTO " +
                SCHEMA + ".IGNORELIST VALUES(?)");
        prep.setString(1, commaSeparatedList);
        prep.execute();
    } catch (DbException e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * Change the whitespace characters. The whitespace characters are used to
 * separate words. If indexes already exist at the time this list is
 * changed, reindex must be called.
 *
 * @param conn the connection
 * @param whitespaceChars the list of characters
 */
public static void setWhitespaceChars(Connection conn,
        String whitespaceChars) throws SQLException {
    try {
        init(conn);
        FullTextSettings setting = FullTextSettings.getInstance(conn);
        setting.setWhitespaceChars(whitespaceChars);
        PreparedStatement prep = conn.prepareStatement("MERGE INTO " +
                SCHEMA + ".SETTINGS VALUES(?, ?)");
        prep.setString(1, "whitespaceChars");
        prep.setString(2, whitespaceChars);
        prep.execute();
    } catch (DbException e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * Tries to start the server.
 * @return the server if successful
 * @throws SQLException if the server could not be started
 */
public Server start() throws SQLException {
    try {
        started = true;
        service.start();
        String name = service.getName() + " (" + service.getURL() + ")";
        Thread t = new Thread(this, name);
        t.setDaemon(service.isDaemon());
        t.start();
        for (int i = 1; i < 64; i += i) {
            wait(i);
            if (isRunning(false)) {
                return this;
            }
        }
        if (isRunning(true)) {
            return this;
        }
        throw DbException.get(ErrorCode.EXCEPTION_OPENING_PORT_2,
                name, "timeout; " +
                "please check your network configuration, specially the file /etc/hosts");
    } catch (DbException e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * Open a database connection.
 * This method should not be called by an application.
 * Instead, the method DriverManager.getConnection should be used.
 *
 * @param url the database URL
 * @param info the connection properties
 * @return the new connection or null if the URL is not supported
 */
@Override
public Connection connect(String url, Properties info) throws SQLException {
    try {
        if (info == null) {
            info = new Properties();
        }
        if (!acceptsURL(url)) {
            return null;
        }
        if (url.equals(DEFAULT_URL)) {
            return DEFAULT_CONNECTION.get();
        }
        Connection c = DbUpgrade.connectOrUpgrade(url, info);
        if (c != null) {
            return c;
        }
        return new JdbcConnection(url, info);
    } catch (Exception e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
private void sendErrorResponse(Exception re) throws IOException {
    SQLException e = DbException.toSQLException(re);
    server.traceError(e);
    startMessage('E');
    write('S');
    writeString("ERROR");
    write('C');
    writeString(e.getSQLState());
    write('M');
    writeString(e.getMessage());
    write('D');
    writeString(e.toString());
    write(0);
    sendMessage();
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * Create a new server for the given service.
 *
 * @param service the service
 * @param args the command line arguments
 */
public Server(Service service, String... args) throws SQLException {
    verifyArgs(args);
    this.service = service;
    try {
        service.init(args);
    } catch (Exception e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
@Override
public void runTool(String... args) throws SQLException {
    String dir = ".";
    String cipher = null;
    char[] decryptPassword = null;
    char[] encryptPassword = null;
    String db = null;
    boolean quiet = false;
    for (int i = 0; args != null && i < args.length; i++) {
        String arg = args[i];
        if (arg.equals("-dir")) {
            dir = args[++i];
        } else if (arg.equals("-cipher")) {
            cipher = args[++i];
        } else if (arg.equals("-db")) {
            db = args[++i];
        } else if (arg.equals("-decrypt")) {
            decryptPassword = args[++i].toCharArray();
        } else if (arg.equals("-encrypt")) {
            encryptPassword = args[++i].toCharArray();
        } else if (arg.equals("-quiet")) {
            quiet = true;
        } else if (arg.equals("-help") || arg.equals("-?")) {
            showUsage();
            return;
        } else {
            showUsageAndThrowUnsupportedOption(arg);
        }
    }
    if ((encryptPassword == null && decryptPassword == null) || cipher == null) {
        showUsage();
        throw new SQLException(
                "Encryption or decryption password not set, or cipher not set");
    }
    try {
        process(dir, db, cipher, decryptPassword, encryptPassword, quiet);
    } catch (Exception e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * Dumps the contents of a database to a SQL script file.
 *
 * @param dir the directory
 * @param db the database name (null for all databases)
 */
public static void execute(String dir, String db) throws SQLException {
    try {
        new Recover().process(dir, db);
    } catch (DbException e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
@Override
public void runTool(String... args) throws SQLException {
    String zipFileName = "backup.zip";
    String dir = ".";
    String db = null;
    boolean quiet = false;
    for (int i = 0; args != null && i < args.length; i++) {
        String arg = args[i];
        if (arg.equals("-dir")) {
            dir = args[++i];
        } else if (arg.equals("-db")) {
            db = args[++i];
        } else if (arg.equals("-quiet")) {
            quiet = true;
        } else if (arg.equals("-file")) {
            zipFileName = args[++i];
        } else if (arg.equals("-help") || arg.equals("-?")) {
            showUsage();
            return;
        } else {
            showUsageAndThrowUnsupportedOption(arg);
        }
    }
    try {
        process(zipFileName, dir, db, quiet);
    } catch (Exception e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * Open a new database connection with the given settings.
 *
 * @param driver the driver class name
 * @param url the database URL
 * @param prop the properties containing at least the user name and password
 * @return the database connection
 */
public static Connection getConnection(String driver, String url,
        Properties prop) throws SQLException {
    if (StringUtils.isNullOrEmpty(driver)) {
        JdbcUtils.load(url);
    } else {
        Class<?> d = loadUserClass(driver);
        if (java.sql.Driver.class.isAssignableFrom(d)) {
            return DriverManager.getConnection(url, prop);
        } else if (javax.naming.Context.class.isAssignableFrom(d)) {
            // JNDI context
            try {
                Context context = (Context) d.newInstance();
                DataSource ds = (DataSource) context.lookup(url);
                String user = prop.getProperty("user");
                String password = prop.getProperty("password");
                if (StringUtils.isNullOrEmpty(user) && StringUtils.isNullOrEmpty(password)) {
                    return ds.getConnection();
                }
                return ds.getConnection(user, password);
            } catch (Exception e) {
                throw DbException.toSQLException(e);
            }
        } else {
            // don't know, but maybe it loaded a JDBC Driver
            return DriverManager.getConnection(url, prop);
        }
    }
    return DriverManager.getConnection(url, prop);
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * INTERNAL.
 * Convert the object to a string.
 *
 * @param data the object
 * @param type the SQL type
 * @return the string
 */
protected static String asString(Object data, int type) throws SQLException {
    if (data == null) {
        return "NULL";
    }
    switch (type) {
    case Types.BIT:
    case Types.BOOLEAN:
    case Types.INTEGER:
    case Types.BIGINT:
    case Types.DECIMAL:
    case Types.DOUBLE:
    case Types.FLOAT:
    case Types.NUMERIC:
    case Types.REAL:
    case Types.SMALLINT:
    case Types.TINYINT:
    case Types.DATE:
    case Types.TIME:
    case Types.TIMESTAMP:
    case Types.LONGVARCHAR:
    case Types.CHAR:
    case Types.VARCHAR:
        return data.toString();
    case Types.CLOB:
        try {
            if (data instanceof Clob) {
                data = ((Clob) data).getCharacterStream();
            }
            return IOUtils.readStringAndClose((Reader) data, -1);
        } catch (IOException e) {
            throw DbException.toSQLException(e);
        }
    case Types.VARBINARY:
    case Types.LONGVARBINARY:
    case Types.BINARY:
    case Types.JAVA_OBJECT:
    case Types.OTHER:
    case Types.BLOB:
    case Types.STRUCT:
    case Types.REF:
    case Types.NULL:
    case Types.ARRAY:
    case Types.DATALINK:
    case Types.DISTINCT:
        throw throwException("Unsupported column data type: " + type);
    default:
        return "";
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
private void process(Connection conn, boolean continueOnError, String path,
        Reader reader, Charset charset) throws SQLException, IOException {
    Statement stat = conn.createStatement();
    ScriptReader r = new ScriptReader(reader);
    while (true) {
        String sql = r.readStatement();
        if (sql == null) {
            break;
        }
        String trim = sql.trim();
        if (trim.length() == 0) {
            continue;
        }
        if (trim.startsWith("@") && StringUtils.toUpperEnglish(trim).
                startsWith("@INCLUDE")) {
            sql = trim;
            sql = sql.substring("@INCLUDE".length()).trim();
            if (!FileUtils.isAbsolute(sql)) {
                sql = path + SysProperties.FILE_SEPARATOR + sql;
            }
            process(conn, sql, continueOnError, charset);
        } else {
            try {
                if (showResults && !trim.startsWith("-->")) {
                    out.print(sql + ";");
                }
                if (showResults || checkResults) {
                    boolean query = stat.execute(sql);
                    if (query) {
                        ResultSet rs = stat.getResultSet();
                        int columns = rs.getMetaData().getColumnCount();
                        StringBuilder buff = new StringBuilder();
                        while (rs.next()) {
                            buff.append("\n-->");
                            for (int i = 0; i < columns; i++) {
                                String s = rs.getString(i + 1);
                                if (s != null) {
                                    s = StringUtils.replaceAll(s, "\r\n", "\n");
                                    s = StringUtils.replaceAll(s, "\n", "\n-->    ");
                                    s = StringUtils.replaceAll(s, "\r", "\r-->    ");
                                }
                                buff.append(' ').append(s);
                            }
                        }
                        buff.append("\n;");
                        String result = buff.toString();
                        if (showResults) {
                            out.print(result);
                        }
                        if (checkResults) {
                            String expected = r.readStatement() + ";";
                            expected = StringUtils.replaceAll(expected, "\r\n", "\n");
                            expected = StringUtils.replaceAll(expected, "\r", "\n");
                            if (!expected.equals(result)) {
                                expected = StringUtils.replaceAll(expected, " ", "+");
                                result = StringUtils.replaceAll(result, " ", "+");
                                throw new SQLException(
                                        "Unexpected output for:\n" + sql.trim() +
                                        "\nGot:\n" + result + "\nExpected:\n" + expected);
                            }
                        }

                    }
                } else {
                    stat.execute(sql);
                }
            } catch (Exception e) {
                if (continueOnError) {
                    e.printStackTrace(out);
                } else {
                    throw DbException.toSQLException(e);
                }
            }
        }
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
@Override
public void runTool(String... args) throws SQLException {
    String file = null;
    String find = null;
    boolean head = false, tail = false;
    int lines = 30;
    boolean quiet = false;
    long start = 0;
    for (int i = 0; args != null && i < args.length; i++) {
        String arg = args[i];
        if (arg.equals("-file")) {
            file = args[++i];
        } else if (arg.equals("-find")) {
            find = args[++i];
        } else if (arg.equals("-start")) {
            start = Long.decode(args[++i]).longValue();
        } else if (arg.equals("-head")) {
            head = true;
        } else if (arg.equals("-tail")) {
            tail = true;
        } else if (arg.equals("-lines")) {
            lines = Integer.decode(args[++i]).intValue();
        } else if (arg.equals("-quiet")) {
            quiet = true;
        } else if (arg.equals("-help") || arg.equals("-?")) {
            showUsage();
            return;
        } else {
            showUsageAndThrowUnsupportedOption(arg);
        }
    }
    if (file == null) {
        showUsage();
        return;
    }
    if (!head && !tail && find == null) {
        head = true;
    }
    try {
        process(file, find, head, tail, start, lines, quiet);
    } catch (IOException e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * Searches from the full text index for this database.
 * The returned result set has the following column:
 * <ul><li>QUERY (varchar): the query to use to get the data.
 * The query does not include 'SELECT * FROM '. Example:
 * PUBLIC.TEST WHERE ID = 1
 * </li><li>SCORE (float) the relevance score. This value is always 1.0
 * for the native fulltext search.
 * </li></ul>
 *
 * @param conn the connection
 * @param text the search query
 * @param limit the maximum number of rows or 0 for no limit
 * @param offset the offset or 0 for no offset
 * @return the result set
 */
public static ResultSet search(Connection conn, String text, int limit,
        int offset) throws SQLException {
    try {
        return search(conn, text, limit, offset, false);
    } catch (DbException e) {
        throw DbException.toSQLException(e);
    }
}
 

import org.h2.message.DbException; //导入方法依赖的package包/类
/**
 * Searches from the full text index for this database. The result contains
 * the primary key data as an array. The returned result set has the
 * following columns:
 * <ul>
 * <li>SCHEMA (varchar): the schema name. Example: PUBLIC </li>
 * <li>TABLE (varchar): the table name. Example: TEST </li>
 * <li>COLUMNS (array of varchar): comma separated list of quoted column
 * names. The column names are quoted if necessary. Example: (ID) </li>
 * <li>KEYS (array of values): comma separated list of values. Example: (1)
 * </li>
 * <li>SCORE (float) the relevance score. This value is always 1.0
 * for the native fulltext search.
 * </li>
 * </ul>
 *
 * @param conn the connection
 * @param text the search query
 * @param limit the maximum number of rows or 0 for no limit
 * @param offset the offset or 0 for no offset
 * @return the result set
 */
public static ResultSet searchData(Connection conn, String text, int limit,
        int offset) throws SQLException {
    try {
        return search(conn, text, limit, offset, true);
    } catch (DbException e) {
        throw DbException.toSQLException(e);
    }
}