All Downloads are FREE. Search and download functionalities are using the official Maven repository.

tech.ydb.jdbc.impl.YdbPreparedStatementImpl Maven / Gradle / Ivy

There is a newer version: 2.3.5
Show newest version
package tech.ydb.jdbc.impl;

import java.io.InputStream;
import java.io.Reader;
import java.math.BigDecimal;
import java.net.URL;
import java.sql.Array;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.Date;
import java.sql.NClob;
import java.sql.Ref;
import java.sql.ResultSetMetaData;
import java.sql.RowId;
import java.sql.SQLException;
import java.sql.SQLFeatureNotSupportedException;
import java.sql.SQLXML;
import java.sql.Time;
import java.sql.Timestamp;
import java.sql.Types;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Objects;
import java.util.logging.Logger;

import tech.ydb.jdbc.YdbConnection;
import tech.ydb.jdbc.YdbConst;
import tech.ydb.jdbc.YdbParameterMetaData;
import tech.ydb.jdbc.YdbPreparedStatement;
import tech.ydb.jdbc.YdbResultSet;
import tech.ydb.jdbc.YdbTypes;
import tech.ydb.jdbc.common.MappingSetters;
import tech.ydb.jdbc.exception.YdbExecutionException;
import tech.ydb.jdbc.query.YdbQuery;
import tech.ydb.table.query.Params;
import tech.ydb.table.values.Type;
import tech.ydb.table.values.VoidType;

public class YdbPreparedStatementImpl extends BaseYdbStatement implements YdbPreparedStatement {
    private static final Logger LOGGER = Logger.getLogger(YdbPreparedStatementImpl.class.getName());
    private final YdbQuery query;
    private final YdbJdbcParams params;
    private final YdbTypes types;

    public YdbPreparedStatementImpl(YdbConnection connection, YdbQuery query, YdbJdbcParams params, int resultSetType) {
        super(LOGGER, connection, resultSetType, true); // is poolable by default

        this.query = Objects.requireNonNull(query);
        this.params = Objects.requireNonNull(params);
        this.types = connection.getYdbTypes();
    }

    @Override
    public String getQuery() {
        return query.originSQL();
    }

    @Override
    public void addBatch() throws SQLException {
        params.addBatch();
    }

    @Override
    public void clearBatch() throws SQLException {
        params.clearBatch();
    }

    @Override
    public void clearParameters() {
        params.clearParameters();
    }

    @Override
    public YdbParameterMetaData getParameterMetaData() {
        return new YdbParameterMetaDataImpl(params);
    }

    @Override
    public void close() {
        clearParameters();
        super.close();
    }

    @Override
    public int[] executeBatch() throws SQLException {
        cleanState();

        int[] results = new int[params.batchSize()];
        if (results.length == 0) {
            return results;
        }

        try {
            for (Params prm: params.getBatchParams()) {
                executeDataQuery(query, prm);
            }
        } finally {
            clearBatch();
        }

        Arrays.fill(results, SUCCESS_NO_INFO);
        return results;
    }

    @Override
    public YdbResultSet executeQuery() throws SQLException {
        if (!execute()) {
            throw new SQLException(YdbConst.QUERY_EXPECT_RESULT_SET);
        }
        return getResultSet();
    }

    @Override
    public int executeUpdate() throws SQLException {
        if (execute()) {
            throw new SQLException(YdbConst.QUERY_EXPECT_UPDATE);
        }
        return getUpdateCount();
    }

    @Override
    public boolean execute() throws SQLException {
        cleanState();
        clearBatch();

        ResultState newState = EMPTY_STATE;
        switch (query.type()) {
            case DATA_QUERY:
                newState = executeDataQuery(query, params.getCurrentParams());
                break;
            case SCAN_QUERY:
                newState = executeScanQuery(query, params.getCurrentParams());
                break;
            default:
                throw new IllegalStateException("Internal error. Unsupported query type " + query.type());
        }
        params.clearParameters();

        return updateState(newState);
    }

    @Override
    public YdbResultSet executeScanQuery() throws SQLException {
        cleanState();
        ResultState state = executeScanQuery(query, params.getCurrentParams());
        params.clearParameters();
        updateState(state);
        return getResultSet();
    }

    @Override
    public YdbResultSet executeExplainQuery() throws SQLException {
        cleanState();
        ResultState state = executeExplainQuery(query);
        updateState(state);
        return getResultSet();
    }

    private Type ydbType(int sqlType) {
        return types.toYdbType(sqlType);
    }

    private Type ydbType(Class clazz) {
        return types.toYdbType(clazz);
    }

    private void setImplReader(String name, Reader reader, long length) throws SQLException {
        params.setParam(name, MappingSetters.CharStream.fromReader(reader, length), ydbType(Types.VARCHAR));
    }

    private void setImplStream(String name, InputStream stream, long length) throws SQLException {
        params.setParam(name, MappingSetters.ByteStream.fromInputStream(stream, length), ydbType(Types.BINARY));
    }

    private void setImplReader(int index, Reader reader, long length) throws SQLException {
        params.setParam(index, MappingSetters.CharStream.fromReader(reader, length), ydbType(Types.VARCHAR));
    }

    private void setImplStream(int index, InputStream stream, long length) throws SQLException {
        params.setParam(index, MappingSetters.ByteStream.fromInputStream(stream, length), ydbType(Types.BINARY));
    }

    @Override
    public void setObject(String parameterName, Object value, Type type) throws SQLException {
        params.setParam(parameterName, value, type);
    }

    @Override
    public void setObject(int parameterIndex, Object value, Type type) throws SQLException {
        params.setParam(parameterIndex, value, type);
    }

    @Override
    public void setObject(String parameterName, Object x) throws SQLException {
        if (x == null) {
            throw new YdbExecutionException(String.format(YdbConst.UNABLE_TO_SET_NULL_OBJECT));
        }
        params.setParam(parameterName, x, ydbType(x.getClass()));
    }

    @Override
    public void setObject(int parameterIndex, Object x) throws SQLException {
        if (x == null) {
            throw new YdbExecutionException(String.format(YdbConst.UNABLE_TO_SET_NULL_OBJECT));
        }
        params.setParam(parameterIndex, x, ydbType(x.getClass()));
    }

    @Override
    public void setNull(String parameterName, int sqlType) throws SQLException {
        Type type = ydbType(sqlType);
        if (type == null) {
            type = VoidType.of();
        }
        params.setParam(parameterName, null, type);
    }

    @Override
    public void setBoolean(String parameterName, boolean x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Boolean.class));
    }

    @Override
    public void setByte(String parameterName, byte x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Byte.class));
    }

    @Override
    public void setShort(String parameterName, short x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Short.class));
    }

    @Override
    public void setInt(String parameterName, int x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Integer.class));
    }

    @Override
    public void setLong(String parameterName, long x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Long.class));
    }

    @Override
    public void setFloat(String parameterName, float x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Float.class));
    }

    @Override
    public void setDouble(String parameterName, double x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Double.class));
    }

    @Override
    public void setBigDecimal(String parameterName, BigDecimal x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Types.DECIMAL));
    }

    @Override
    public void setString(String parameterName, String x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Types.VARCHAR));
    }

    @Override
    public void setBytes(String parameterName, byte[] x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Types.BINARY));
    }

    @Override
    public void setDate(String parameterName, Date x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Types.DATE));
    }

    @Override
    public void setTime(String parameterName, Time x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Types.TIME));
    }

    @Override
    public void setTimestamp(String parameterName, Timestamp x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Types.TIMESTAMP));
    }

    @Override
    public void setUnicodeStream(String parameterName, InputStream x, int length) throws SQLException {
        setImplStream(parameterName, x, length);
    }

    @Override
    public void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException {
        setImplStream(parameterName, x, length);
    }

    @Override
    public void setObject(String parameterName, Object x, int targetSqlType) throws SQLException {
        params.setParam(parameterName, x, ydbType(targetSqlType));
    }

    @Override
    public void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException {
        setImplReader(parameterName, reader, length);
    }

    @Override
    public void setDate(String parameterName, Date x, Calendar cal) throws SQLException {
        // TODO: check cal
        params.setParam(parameterName, x, ydbType(Types.DATE));
    }

    @Override
    public void setTime(String parameterName, Time x, Calendar cal) throws SQLException {
        // TODO: check cal
        params.setParam(parameterName, x, ydbType(Types.TIME));
    }

    @Override
    public void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException {
        // TODO: check cal
        params.setParam(parameterName, x, ydbType(Types.TIMESTAMP));
    }

    @Override
    public void setNull(String parameterName, int sqlType, String typeName) throws SQLException {
        Type type = types.toYdbType(typeName);
        if (type == null) {
            type = types.toYdbType(sqlType);
        }
        if (type == null) {
            type = VoidType.of();
        }
        params.setParam(parameterName, null, type);
    }

    @Override
    public void setURL(String parameterName, URL x) throws SQLException {
        params.setParam(parameterName, x, ydbType(Types.VARCHAR));
    }

    @Override
    public void setNString(String parameterName, String value) throws SQLException {
        params.setParam(parameterName, value, ydbType(Types.VARCHAR));
    }

    @Override
    public void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException {
        setImplReader(parameterName, value, length);
    }

    @Override
    public void setClob(String parameterName, Reader reader, long length) throws SQLException {
        setImplReader(parameterName, reader, length);
    }

    @Override
    public void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException {
        setImplStream(parameterName, inputStream, length);
    }

    @Override
    public void setNClob(String parameterName, Reader reader, long length) throws SQLException {
        setImplReader(parameterName, reader, length);
    }

    @Override
    public void setObject(String parameterName, Object x, int targetSqlType, int scaleOrLength) throws SQLException {
        // TODO: check scaleOrLength
        params.setParam(parameterName, x, ydbType(targetSqlType));
    }

    @Override
    public void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException {
        setImplStream(parameterName, x, length);
    }

    @Override
    public void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException {
        setImplReader(parameterName, reader, length);
    }

    @Override
    public void setBinaryStream(String parameterName, InputStream x) throws SQLException {
        setImplStream(parameterName, x, -1);
    }

    @Override
    public void setCharacterStream(String parameterName, Reader reader) throws SQLException {
        setImplReader(parameterName, reader, -1);
    }

    @Override
    public void setNCharacterStream(String parameterName, Reader value) throws SQLException {
        setImplReader(parameterName, value, -1);
    }

    @Override
    public void setClob(String parameterName, Reader reader) throws SQLException {
        setImplReader(parameterName, reader, -1);
    }

    @Override
    public void setBlob(String parameterName, InputStream inputStream) throws SQLException {
        setImplStream(parameterName, inputStream, -1);
    }

    @Override
    public void setNClob(String parameterName, Reader reader) throws SQLException {
        setImplReader(parameterName, reader, -1);
    }

    @Override
    public void setNull(int parameterIndex, int sqlType) throws SQLException {
        Type type = ydbType(sqlType);
        if (type == null) {
            type = VoidType.of();
        }
        params.setParam(parameterIndex, null, type);
    }

    @Override
    public void setBoolean(int parameterIndex, boolean x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Boolean.class));
    }

    @Override
    public void setByte(int parameterIndex, byte x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Byte.class));
    }

    @Override
    public void setShort(int parameterIndex, short x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Short.class));
    }

    @Override
    public void setInt(int parameterIndex, int x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Integer.class));
    }

    @Override
    public void setLong(int parameterIndex, long x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Long.class));
    }

    @Override
    public void setFloat(int parameterIndex, float x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Float.class));
    }

    @Override
    public void setDouble(int parameterIndex, double x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Double.class));
    }

    @Override
    public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Types.DECIMAL));
    }

    @Override
    public void setString(int parameterIndex, String x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Types.VARCHAR));
    }

    @Override
    public void setBytes(int parameterIndex, byte[] x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Types.BINARY));
    }

    @Override
    public void setDate(int parameterIndex, Date x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Types.DATE));
    }

    @Override
    public void setTime(int parameterIndex, Time x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Types.TIME));
    }

    @Override
    public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Types.TIMESTAMP));
    }

    @Override
    public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException {
        setImplStream(parameterIndex, x, length);
    }

    @Deprecated
    @Override
    public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException {
        setImplStream(parameterIndex, x, length);
    }

    @Override
    public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException {
        setImplStream(parameterIndex, x, length);
    }

    @Override
    public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(targetSqlType));
    }

    @Override
    public void setCharacterStream(int parameterIndex, Reader reader, int length) throws SQLException {
        setImplReader(parameterIndex, reader, length);
    }

    @Override
    public void setRef(int parameterIndex, Ref x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.REF_UNSUPPORTED);
    }

    @Override
    public void setBlob(int parameterIndex, Blob x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.BLOB_UNSUPPORTED);
    }

    @Override
    public void setClob(int parameterIndex, Clob x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.CLOB_UNSUPPORTED);
    }

    @Override
    public void setArray(int parameterIndex, Array x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.ARRAYS_UNSUPPORTED);
    }

    @Override
    public void setDate(int parameterIndex, Date x, Calendar cal) throws SQLException {
        // TODO: check cal
        params.setParam(parameterIndex, x, ydbType(Types.DATE));
    }

    @Override
    public void setTime(int parameterIndex, Time x, Calendar cal) throws SQLException {
        // TODO: check cal
        params.setParam(parameterIndex, x, ydbType(Types.TIME));
    }

    @Override
    public void setTimestamp(int parameterIndex, Timestamp x, Calendar cal) throws SQLException {
        // TODO: check cal
        params.setParam(parameterIndex, x, ydbType(Types.TIMESTAMP));
    }

    @Override
    public void setNull(int parameterIndex, int sqlType, String typeName) throws SQLException {
        Type type = types.toYdbType(typeName);
        if (type == null) {
            type = types.toYdbType(sqlType);
        }
        if (type == null) {
            type = VoidType.of();
        }
        params.setParam(parameterIndex, null, type);
    }

    @Override
    public void setURL(int parameterIndex, URL x) throws SQLException {
        params.setParam(parameterIndex, x, ydbType(Types.VARCHAR));
    }

    @Override
    public void setNString(int parameterIndex, String value) throws SQLException {
        params.setParam(parameterIndex, value, ydbType(Types.VARCHAR));
    }

    @Override
    public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException {
        setImplReader(parameterIndex, value, length);
    }

    @Override
    public void setNClob(int parameterIndex, NClob value) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.NCLOB_UNSUPPORTED);
    }

    @Override
    public void setClob(int parameterIndex, Reader reader, long length) throws SQLException {
        setImplReader(parameterIndex, reader, length);
    }

    @Override
    public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException {
        setImplStream(parameterIndex, inputStream, length);
    }

    @Override
    public void setNClob(int parameterIndex, Reader reader, long length) throws SQLException {
        setImplReader(parameterIndex, reader, length);
    }

    @Override
    public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.SQLXML_UNSUPPORTED);
    }

    @Override
    public void setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) throws SQLException {
        // TODO: handle scaleOrLength
        params.setParam(parameterIndex, x, ydbType(targetSqlType));
    }

    @Override
    public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException {
        setImplStream(parameterIndex, x, length);
    }

    @Override
    public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException {
        setImplStream(parameterIndex, x, length);
    }

    @Override
    public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException {
        setImplReader(parameterIndex, reader, length);
    }

    @Override
    public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException {
        setImplStream(parameterIndex, x, -1);
    }

    @Override
    public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException {
        setImplStream(parameterIndex, x, -1);
    }

    @Override
    public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException {
        setImplReader(parameterIndex, reader, -1);
    }

    @Override
    public void setNCharacterStream(int parameterIndex, Reader value) throws SQLException {
        setImplReader(parameterIndex, value, -1);
    }

    @Override
    public void setClob(int parameterIndex, Reader reader) throws SQLException {
        setImplReader(parameterIndex, reader, -1);
    }

    @Override
    public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException {
        setImplStream(parameterIndex, inputStream, -1);
    }

    @Override
    public void setNClob(int parameterIndex, Reader reader) throws SQLException {
        setImplReader(parameterIndex, reader, -1);
    }

    // UNSUPPORTED
    @Override
    public ResultSetMetaData getMetaData() throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.METADATA_RS_UNSUPPORTED_IN_PS);
    }

    @Override
    public void setRowId(int parameterIndex, RowId x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.ROWID_UNSUPPORTED);
    }

    @Override
    public void executeSchemeQuery(String sql) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public YdbResultSet executeScanQuery(String sql) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public YdbResultSet executeExplainQuery(String sql) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public YdbResultSet executeQuery(String sql) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public boolean execute(String sql) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public boolean execute(String sql, int autoGeneratedKeys) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public boolean execute(String sql, int[] columnIndexes) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public boolean execute(String sql, String[] columnNames) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public int executeUpdate(String sql) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public int executeUpdate(String sql, int[] columnIndexes) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public int executeUpdate(String sql, String[] columnNames) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public void addBatch(String sql) throws SQLException {
        throw new SQLException(YdbConst.CUSTOM_SQL_UNSUPPORTED);
    }

    @Override
    public void setArray(String parameterName, Array x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.ARRAYS_UNSUPPORTED);
    }


    @Override
    public void setAsciiStream(String parameterName, InputStream x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.ASCII_STREAM_UNSUPPORTED);
    }

    @Override
    public void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.ASCII_STREAM_UNSUPPORTED);
    }

    @Override
    public void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.ASCII_STREAM_UNSUPPORTED);
    }

    @Override
    public void setBlob(String parameterName, Blob x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.BLOB_UNSUPPORTED);
    }

    @Override
    public void setClob(String parameterName, Clob x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.CLOB_UNSUPPORTED);
    }

    @Override
    public void setNClob(String parameterName, NClob value) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.NCLOB_UNSUPPORTED);
    }

    @Override
    public void setRef(String parameterName, Ref x) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.REF_UNSUPPORTED);
    }

    @Override
    public void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException {
        throw new SQLFeatureNotSupportedException(YdbConst.SQLXML_UNSUPPORTED);
    }

    @Override
    public  T unwrap(Class iface) throws SQLException {
        if (iface.isAssignableFrom(getClass())) {
            return iface.cast(this);
        }
        throw new SQLException(YdbConst.CANNOT_UNWRAP_TO + iface);
    }

    @Override
    public boolean isWrapperFor(Class iface) {
        return iface.isAssignableFrom(getClass());
    }
}




© 2015 - 2024 Weber Informatics LLC | Privacy Policy