Examples with ConnectionFactoryException com.varsql.core.exception.ConnectionFactoryException used on opensource projects

Example 6 with ConnectionFactoryException

use of com.varsql.core.exception.ConnectionFactoryException in project varsql by varsqlinfo.

the class SimpleConnectionInfoDao method getConnectionInfo.

@Override
public ConnectionInfo getConnectionInfo(String connid) {
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
        conn = ConnectionFactory.getInstance().getConnection();
        StringBuffer querySb = new StringBuffer();
        querySb.append(" select ");
        querySb.append("  a.*  ");
        querySb.append("  , b.DRIVER_PROVIDER_ID, b.DRIVER_CLASS, b.VALIDATION_QUERY, b.DB_TYPE, b.PATH_TYPE, b.DRIVER_PATH ");
        querySb.append("  , c.URL_FORMAT ");
        querySb.append(" from ");
        querySb.append("  VTCONNECTION a left outer join VTDBTYPE_DRIVER_PROVIDER b on a.VDRIVER = b.DRIVER_PROVIDER_ID ");
        querySb.append("  left outer join VTDBTYPE_DRIVER_TYPE c on b.DRIVER_ID = c.DRIVER_ID  ");
        querySb.append(" where 1=1 ");
        querySb.append(" and a.VCONNID = ? ");
        pstmt = conn.prepareStatement(querySb.toString());
        pstmt.setString(1, connid);
        rs = pstmt.executeQuery();
        if (rs == null)
            throw new ConnectionFactoryException("not valid connection infomation :" + connid);
        rs.next();
        ConnectionInfo connInfo = new ConnectionInfo();
        connInfo.setConnid(rs.getString("VCONNID"));
        connInfo.setAliasName(rs.getString("VNAME"));
        connInfo.setType(rs.getString("VTYPE").toLowerCase());
        String urlDirectYn = rs.getString("URL_DIRECT_YN");
        if ("Y".equals(urlDirectYn)) {
            connInfo.setUrl(rs.getString("VURL"));
        } else {
            connInfo.setUrl(VarsqlJdbcUtil.getJdbcUrl(rs.getString("URL_FORMAT"), JdbcURLFormatParam.builder().serverIp(rs.getString("VSERVERIP")).port(Integer.parseInt(rs.getString("VPORT"))).databaseName(rs.getString("VDATABASENAME")).build()));
        }
        connInfo.setUsername(rs.getString("VID"));
        if ("varsql".equals(connInfo.getConnid())) {
            connInfo.setPassword(rs.getString("VPW"));
        } else {
            String str = rs.getString("VPW");
            connInfo.setPassword("");
            if (str != null && !"".equals(str))
                connInfo.setPassword(DBPasswordCryptionFactory.getInstance().decrypt(rs.getString("VPW")));
        }
        connInfo.setPoolOptions(rs.getString("VPOOLOPT"));
        connInfo.setConnectionOptions(rs.getString("VCONNOPT"));
        connInfo.setMaxActive(NumberUtils.toInt(rs.getString("MAX_ACTIVE"), 10));
        connInfo.setMinIdle(NumberUtils.toInt(rs.getString("MIN_IDLE"), 3));
        connInfo.setConnectionTimeOut(NumberUtils.toInt(rs.getString("TIMEOUT"), 18000));
        connInfo.setExportCount(NumberUtils.toInt(rs.getString("EXPORTCOUNT"), 1000));
        connInfo.setTestWhileIdle("Y".equals(rs.getString("TEST_WHILE_IDLE")));
        String conn_query = rs.getString("VQUERY");
        String dbvalidation_query = rs.getString("VALIDATION_QUERY");
        conn_query = (conn_query == null) ? "" : conn_query;
        dbvalidation_query = (dbvalidation_query == null) ? "" : dbvalidation_query;
        String validation_query = !"".equals(conn_query.trim()) ? conn_query : (!"".equals(dbvalidation_query.trim()) ? dbvalidation_query : ValidationProperty.getInstance().validationQuery(connInfo.getType()));
        this.logger.debug("valication_query : {}", validation_query);
        connInfo.setValidationQuery(validation_query);
        String driverProviderId = rs.getString("DRIVER_PROVIDER_ID");
        pstmt.close();
        pstmt = conn.prepareStatement(" select FILE_NAME,FILE_PATH,FILE_EXT from VTDBTYPE_DRIVER_FILE where FILE_CONT_ID = ? ");
        pstmt.setString(1, driverProviderId);
        rs.close();
        rs = pstmt.executeQuery();
        if (rs == null) {
            throw new ConnectionFactoryException("jdbc driver file not found :" + connid);
        }
        List<FileInfo> jarFileList = new ArrayList<>();
        while (rs.next()) {
            FileInfo fi = new FileInfo();
            fi.setName(rs.getString("FILE_NAME"));
            fi.setPath(Paths.get(VarsqlConstants.UPLOAD_PATH).toAbsolutePath().resolve(rs.getString("FILE_PATH")).normalize().toAbsolutePath().toString());
            fi.setExt(rs.getString("FILE_EXT"));
            jarFileList.add(fi);
        }
        JDBCDriverInfo jdbcDriverInfo = new JDBCDriverInfo(rs.getString("DRIVER_PROVIDER_ID"), rs.getString("DRIVER_CLASS"));
        jdbcDriverInfo.setDriverFiles(jarFileList);
        connInfo.setJdbcDriverInfo(jdbcDriverInfo);
        return connInfo;
    } catch (EncryptDecryptException e) {
        this.logger.error("password decrypt error", e);
        throw new ConnectionFactoryException("password decrypt error", e);
    } catch (Exception e) {
        this.logger.error("empty connection info", e);
        throw new ConnectionFactoryException("empty connection info : [" + connid + "]", e);
    } finally {
        JdbcUtils.close(conn, pstmt, rs);
    }
}