Java SQLException类代码示例

import java.sql.SQLException; //导入依赖的package包/类
private static void createDatabase() throws SQLException {

        new File("testdb.backup").delete();
        new File("testdb.data").delete();
        new File("testdb.properties").delete();
        new File("testdb.script").delete();

        Connection con = DriverManager.getConnection("jdbc:hsqldb:testdb",
            "sa", "");
        String[] saDDL = {
            "CREATE CACHED TABLE XB (EIACODXA VARCHAR(10) NOT NULL, LSACONXB VARCHAR(18) NOT NULL, ALTLCNXB VARCHAR(2) NOT NULL, LCNTYPXB VARCHAR(1) NOT NULL, LCNINDXB VARCHAR(1), LCNAMEXB VARCHAR(19), UPDT_BY VARCHAR(32), LST_UPDT TIMESTAMP, CONSTRAINT XPKXB PRIMARY KEY (EIACODXA, LSACONXB, ALTLCNXB, LCNTYPXB));",
            "CREATE INDEX XIF2XB ON XB (EIACODXA);",
            "CREATE CACHED TABLE CA ( EIACODXA VARCHAR(10) NOT NULL, LSACONXB VARCHAR(18) NOT NULL, ALTLCNXB VARCHAR(2) NOT NULL, LCNTYPXB VARCHAR(1) NOT NULL, TASKCDCA VARCHAR(7) NOT NULL, TSKFRQCA NUMERIC(7,4), UPDT_BY VARCHAR(32), LST_UPDT TIMESTAMP, CONSTRAINT XPKCA PRIMARY KEY (EIACODXA, LSACONXB, ALTLCNXB, LCNTYPXB, TASKCDCA),        CONSTRAINT R_XB_CA FOREIGN KEY (EIACODXA, LSACONXB, ALTLCNXB, LCNTYPXB) REFERENCES XB ON DELETE CASCADE);",
            "CREATE INDEX XIF26CA ON CA ( EIACODXA, LSACONXB, ALTLCNXB, LCNTYPXB);"
        };
        Statement stmt = con.createStatement();

        for (int index = 0; index < saDDL.length; index++) {
            stmt.executeUpdate(saDDL[index]);
        }

        con.close();
    }
 

import java.sql.SQLException; //导入依赖的package包/类
public synchronized void setClientInfo(java.sql.Connection conn, Properties properties) throws SQLClientInfoException {
    try {
        Enumeration<?> propNames = properties.propertyNames();

        while (propNames.hasMoreElements()) {
            String name = (String) propNames.nextElement();
            String value = properties.getProperty(name);

            setClientInfo(conn, name, value);
        }
    } catch (SQLException sqlEx) {
        SQLClientInfoException clientInfoEx = new SQLClientInfoException();
        clientInfoEx.initCause(sqlEx);

        throw clientInfoEx;
    }
}
 

import java.sql.SQLException; //导入依赖的package包/类
@Override
public void updateInt(String columnLabel, int x) throws SQLException {
    throw new UnsupportedOperationException("Not supported yet.");
}
 

import java.sql.SQLException; //导入依赖的package包/类
protected synchronized void checkParameterBounds(int parameterIndex) throws SQLException
{
    checkClosed();
    if ((parameterIndex < 1) || (parameterIndex > this.Query.getParameterCount())) {
        throw SQLError.get(SQLError.PARAMETER_NOT_FOUND, parameterIndex, this.Query.getParameterCount());
    }
}
 

import java.sql.SQLException; //导入依赖的package包/类
public void setClientInfo(Properties properties) throws SQLClientInfoException {
    try {
        getClientInfoProviderImpl().setClientInfo(this, properties);
    } catch (SQLClientInfoException ciEx) {
        throw ciEx;
    } catch (SQLException sqlEx) {
        SQLClientInfoException clientInfoEx = new SQLClientInfoException();
        clientInfoEx.initCause(sqlEx);

        throw clientInfoEx;
    }
}
 

import java.sql.SQLException; //导入依赖的package包/类
/**
 * Initialize data base with 'MDA' JIRA project.
 */
@BeforeClass
public static void initializeJiraDataBaseForImport() throws SQLException {
	datasource = new SimpleDriverDataSource(new JDBCDriver(), "jdbc:hsqldb:mem:dataSource", null, null);
	final Connection connection = datasource.getConnection();
	try {
		ScriptUtils.executeSqlScript(connection,
				new EncodedResource(new ClassPathResource("sql/base-1/jira-create.sql"), StandardCharsets.UTF_8));
		ScriptUtils.executeSqlScript(connection,
				new EncodedResource(new ClassPathResource("sql/base-2/jira-create.sql"), StandardCharsets.UTF_8));
		ScriptUtils.executeSqlScript(connection,
				new EncodedResource(new ClassPathResource("sql/upload/jira-create.sql"), StandardCharsets.UTF_8));

		ScriptUtils.executeSqlScript(connection, new EncodedResource(new ClassPathResource("sql/base-1/jira.sql"), StandardCharsets.UTF_8));
		ScriptUtils.executeSqlScript(connection, new EncodedResource(new ClassPathResource("sql/base-2/jira.sql"), StandardCharsets.UTF_8));
		ScriptUtils.executeSqlScript(connection, new EncodedResource(new ClassPathResource("sql/upload/jira.sql"), StandardCharsets.UTF_8));
	} finally {
		connection.close();
	}
}
 

import java.sql.SQLException; //导入依赖的package包/类
public static void deleteProductoPresupuesto(String id, String producto_id, String producto_unidad_medida_id, String proyecto_id, String proyecto_subprograma_id, String proyecto_subprograma_programa_id, String proyecto_subprograma_programa_tipo_presupuesto_id, String proyecto_subprograma_programa_entidad_id, String proyecto_subprograma_programa_entidad_nivel_id){
 	 Connection conect=ConnectionConfiguration.conectar();
 	 Statement statement = null;
 String 														query = "delete from producto_presupusto ";
 //if (id!="")													query+= "id=\""+id+"\", ";
 /*if (numero_fila!="")											query+= "numero_fila=\""+numero_fila+"\", ";
 if (anho!="")													query+= "anho=\""+anho+"\", ";
 //if (producto_id!="")											query+= "producto_id=\""+producto_id+"\", ";
 //if (producto_unidad_medida_id!="")							query+= "producto_unidad_medida_id=\""+producto_unidad_medida_id+"\", ";
 //if (proyecto_id!="")											query+= "proyecto_id=\""+proyecto_id+"\", ";
 //if (proyecto_subprograma_id!="")								query+= "proyecto_subprograma_id=\""+proyecto_subprograma_id+"\", ";
 //if (proyecto_subprograma_programa_id!="")					query+= "proyecto_subprograma_programa_id=\""+proyecto_subprograma_programa_id+"\", ";
 //if (proyecto_subprograma_programa_tipo_presupuesto_id!="")	query+= "proyecto_subprograma_programa_tipo_presupuesto_id=\""+proyecto_subprograma_programa_tipo_presupuesto_id+"\", ";
 //if (proyecto_subprograma_programa_entidad_id!="")			query+= "proyecto_subprograma_programa_entidad_id=\""+proyecto_subprograma_programa_entidad_id+"\", ";
 //if (proyecto_subprograma_programa_entidad_nivel_id!="")		query+= "proyecto_subprograma_programa_entidad_nivel_id=\""+proyecto_subprograma_programa_entidad_nivel_id+"\", ";
 if (version!="")			query+= "version=\""+version+"\", ";
 query = query.substring(0, query.length()-2);*/
 query+="where id="+id+" and producto_id="+producto_id+" and producto_unidad_medida_id="+producto_unidad_medida_id+" and proyecto_id="+proyecto_id+" and proyecto_subprograma_id="+proyecto_subprograma_id+" and proyecto_subprograma_programa_id="+proyecto_subprograma_programa_id+" and proyecto_subprograma_programa_tipo_presupuesto_id="+proyecto_subprograma_programa_tipo_presupuesto_id+" and proyecto_subprograma_programa_entidad_id="+proyecto_subprograma_programa_entidad_id+" and proyecto_subprograma_programa_entidad_nivel_id="+proyecto_subprograma_programa_entidad_nivel_id;
		
try {
	statement=conect.createStatement();
	statement.execute(query);
    conect.close();
} catch (SQLException e) {e.printStackTrace();}
 }
 

import java.sql.SQLException; //导入依赖的package包/类
public void setClientInfo(String name, String value) throws SQLClientInfoException {
    try {
        checkClosed();

        ((java.sql.Connection) this.mc).setClientInfo(name, value);
    } catch (SQLException sqlException) {
        try {
            checkAndFireConnectionError(sqlException);
        } catch (SQLException sqlEx2) {
            SQLClientInfoException clientEx = new SQLClientInfoException();
            clientEx.initCause(sqlEx2);

            throw clientEx;
        }
    }
}
 

import java.sql.SQLException; //导入依赖的package包/类
public void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException {
    try {
        if (this.wrappedStmt != null) {
            ((CallableStatement) this.wrappedStmt).setCharacterStream(parameterName, reader, length);
        } else {
            throw SQLError.createSQLException("No operations allowed after statement closed", SQLError.SQL_STATE_GENERAL_ERROR, this.exceptionInterceptor);
        }
    } catch (SQLException sqlEx) {
        checkAndFireConnectionError(sqlEx);
    }
}
 

import java.sql.SQLException; //导入依赖的package包/类
/**
 * Gets tables.
 *
 * @param connection the connection
 * @param keys keys
 * @param tablesOverride the tables override @return the tables
 * @throws SQLException the sql exception
 */
public Map<String, Map<String, Object>> getTables(Connection connection, String keys,
                                                  Map<String, Map<String, Object>> tablesOverride) throws SQLException {
    Map<String, Map<String, Object>> dataMap = new HashMap<>(16);
    DatabaseMetaData metaData = connection.getMetaData();
    // 处理key列表
    List<String> keyList = new ArrayList<>(1);
    if (keys != null) {
        String[] keyArray = keys.split(",");
        keyList = Arrays.asList(keyArray);
    } else {
        keyList.add("%");
    }
    // 根据key列表抽取指定表
    for (String key : keyList) {
        ResultSet resultSet = metaData.getTables(null, null, key, null);
        while (resultSet.next()) {
            Map<String, Object> table = new HashMap<>(4);
            String tableName = resultSet.getString(TABLE_NAME);
            LOGGER.info("抽取表结构>>{}", tableName);
            // 获取主键
            ResultSet primaryKeys = metaData.getPrimaryKeys(null, null, tableName);
            if (primaryKeys.next()) {
                String primaryColumn = primaryKeys.getString(COLUMN_NAME);
                table.put("primaryColumn", primaryColumn);
                table.put("primaryName", StringUtils.getCamelCaseString(primaryColumn, false));
                table.put("primaryAuto", false);
            } else {
                LOGGER.warn("获取表{}主键失败,跳过该表", tableName);
                continue;
            }
            table.put("tableName", tableName);
            table.put("comment", resultSet.getString(REMARKS));
            String className = StringUtils.getCamelCaseString(tableName, true);
            table.put("className", className);

            table.put("imports", new HashSet<>(5));

            // 使用配置文件进行覆盖
            Map<String, Object> tableOverride = tablesOverride.get(tableName);
            Map<String, Map<String, Object>> columnsOverride = new HashMap<>(0);
            if (tableOverride != null) {
                table.putAll(tableOverride);
                table.remove("columns");
                List<Map<String, Object>> columnsOverrideList = (List<Map<String, Object>>) tableOverride.get("columns");
                if (columnsOverrideList != null) {
                    columnsOverride = columnsOverrideList.stream().collect(Collectors.toMap(o -> (String) o.get("columnName"),
                                                                                            o -> o));
                }
            }
            List<Map<String, Object>> columns = getColumns(connection, table, columnsOverride);
            table.put("columns", columns);
            dataMap.put(tableName, table);
        }
    }
    return dataMap;
}
 

import java.sql.SQLException; //导入依赖的package包/类
@Override
public void stop() {
    if(connection != null) {
        try {
            connection.close();
        } catch (SQLException ex) {
            
        }
        connection = null;
    }
}
 

import java.sql.SQLException; //导入依赖的package包/类
/**
* Are stored procedure calls using the stored procedure escape
* syntax supported?
* @return <code>true</code> if so
* @exception SQLException if a database access error occurs
*/
public boolean supportsStoredProcedures() throws SQLException
{
    Boolean storedProcedures = (Boolean)properties.get(PROP_STORED_PROCEDURES);
    if (storedProcedures == null) {
        if (dmd != null) storedProcedures = dmd.supportsStoredProcedures() ? Boolean.TRUE : Boolean.FALSE;
        else throw new SQLException(bundle.getString("EXC_NoDBMetadata")); // NOI18N
        properties.put(PROP_STORED_PROCEDURES, storedProcedures);
    }

    return storedProcedures.booleanValue();
}
 

import java.sql.SQLException; //导入依赖的package包/类
/**
 * 查询对应的实体列表，返回多条记录
 */
public <T> List<T> queryEntityList(Class<T> entityClass, String sql, Object... params) {
    List<T> result;
    try {
    	result = queryRunner.query(sql, new BeanListHandler<T>(entityClass), params);
    } catch (SQLException e) {
        logger.error("查询出错！");
        throw new RuntimeException(e);
    }
    printSQL(sql);
    return result;
}
 

import java.sql.SQLException; //导入依赖的package包/类
public void testBug46637() throws Exception {
    String hostname = getPortFreeHostname(null, new NonRegisteringDriver());
    UnreliableSocketFactory.flushAllStaticData();
    UnreliableSocketFactory.downHost(hostname);

    try {
        Connection noConn = getConnectionWithProps("socketFactory=testsuite.UnreliableSocketFactory");
        noConn.close();
    } catch (SQLException sqlEx) {
        assertTrue(sqlEx.getMessage().indexOf("has not received") != -1);
    } finally {
        UnreliableSocketFactory.flushAllStaticData();
    }
}
 

import java.sql.SQLException; //导入依赖的package包/类
/**
 * Checks if the specified parameter index value is valid in terms of
 * getting an OUT or INOUT parameter value. <p>
 *
 * @param i The parameter index to check
 * @throws SQLException if the specified parameter index is invalid
 */
protected void checkGetParameterIndex(int i) throws SQLException {

    String msg;

    checkClosed();

    if (i < 1 || i > parameterValues.length) {
        msg = "parameter index out of range: " + i;

        throw Util.outOfRangeArgument(msg);
    }

    int mode = parameterModes[i - 1];

    switch (mode) {

        case SchemaObject.ParameterModes.PARAM_UNKNOWN :
        case SchemaObject.ParameterModes.PARAM_OUT :
        case SchemaObject.ParameterModes.PARAM_INOUT :
            break;
        case SchemaObject.ParameterModes.PARAM_IN :
        default :
            msg = "Not OUT or INOUT mode: " + mode + " for parameter: "
                  + i;

            throw Util.invalidArgument(msg);
    }
}