| /* |
| * Licensed to the Apache Software Foundation (ASF) under one or more |
| * contributor license agreements. See the NOTICE file distributed with |
| * this work for additional information regarding copyright ownership. |
| * The ASF licenses this file to You under the Apache License, Version 2.0 |
| * (the "License"); you may not use this file except in compliance with |
| * the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, software |
| * distributed under the License is distributed on an "AS IS" BASIS, |
| * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| * See the License for the specific language governing permissions and |
| * limitations under the License. |
| */ |
| |
| package org.apache.ignite.internal.jdbc; |
| |
| 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.ParameterMetaData; |
| import java.sql.PreparedStatement; |
| import java.sql.Ref; |
| import java.sql.ResultSet; |
| 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.util.Calendar; |
| |
| /** |
| * JDBC prepared statement implementation. |
| * |
| * @deprecated Using Ignite client node based JDBC driver is preferable. |
| * See documentation of {@link org.apache.ignite.IgniteJdbcDriver} for details. |
| */ |
| @Deprecated |
| public class JdbcPreparedStatement extends JdbcStatement implements PreparedStatement { |
| /** SQL query. */ |
| private final String sql; |
| |
| /** Arguments count. */ |
| private final int argsCnt; |
| |
| /** |
| * Creates new prepared statement. |
| * |
| * @param conn Connection. |
| * @param sql SQL query. |
| */ |
| JdbcPreparedStatement(JdbcConnection conn, String sql) { |
| super(conn); |
| |
| this.sql = sql; |
| |
| argsCnt = sql.replaceAll("[^?]", "").length(); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public ResultSet executeQuery() throws SQLException { |
| return executeQuery(sql); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public int executeUpdate() throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Updates are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setNull(int paramIdx, int sqlType) throws SQLException { |
| setArgument(paramIdx, null); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setBoolean(int paramIdx, boolean x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setByte(int paramIdx, byte x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setShort(int paramIdx, short x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setInt(int paramIdx, int x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setLong(int paramIdx, long x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setFloat(int paramIdx, float x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setDouble(int paramIdx, double x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setBigDecimal(int paramIdx, BigDecimal x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setString(int paramIdx, String x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setBytes(int paramIdx, byte[] x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setDate(int paramIdx, Date x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setTime(int paramIdx, Time x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setTimestamp(int paramIdx, Timestamp x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setAsciiStream(int paramIdx, InputStream x, int length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setUnicodeStream(int paramIdx, InputStream x, int length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setBinaryStream(int paramIdx, InputStream x, int length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void clearParameters() throws SQLException { |
| ensureNotClosed(); |
| |
| args = null; |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setObject(int paramIdx, Object x, int targetSqlType) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setObject(int paramIdx, Object x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public boolean execute() throws SQLException { |
| return execute(sql); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void addBatch() throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Updates are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setCharacterStream(int paramIdx, Reader x, int length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setRef(int paramIdx, Ref x) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setBlob(int paramIdx, Blob x) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setClob(int paramIdx, Clob x) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setArray(int paramIdx, Array x) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public ResultSetMetaData getMetaData() throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Meta data for prepared statement is not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setDate(int paramIdx, Date x, Calendar cal) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setTime(int paramIdx, Time x, Calendar cal) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setTimestamp(int paramIdx, Timestamp x, Calendar cal) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setNull(int paramIdx, int sqlType, String typeName) throws SQLException { |
| setNull(paramIdx, sqlType); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setURL(int paramIdx, URL x) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public ParameterMetaData getParameterMetaData() throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Meta data for prepared statement is not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setRowId(int paramIdx, RowId x) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setNString(int paramIdx, String val) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setNCharacterStream(int paramIdx, Reader val, long length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setNClob(int paramIdx, NClob val) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setClob(int paramIdx, Reader reader, long length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setBlob(int paramIdx, InputStream inputStream, long length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setNClob(int paramIdx, Reader reader, long length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setSQLXML(int paramIdx, SQLXML xmlObj) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setObject(int paramIdx, Object x, int targetSqlType, |
| int scaleOrLength) throws SQLException { |
| setArgument(paramIdx, x); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setAsciiStream(int paramIdx, InputStream x, long length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setBinaryStream(int paramIdx, InputStream x, long length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setCharacterStream(int paramIdx, Reader x, long length) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setAsciiStream(int paramIdx, InputStream x) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setBinaryStream(int paramIdx, InputStream x) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setCharacterStream(int paramIdx, Reader x) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("Streams are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setNCharacterStream(int paramIdx, Reader val) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setClob(int paramIdx, Reader reader) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setBlob(int paramIdx, InputStream inputStream) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** {@inheritDoc} */ |
| @Override public void setNClob(int paramIdx, Reader reader) throws SQLException { |
| ensureNotClosed(); |
| |
| throw new SQLFeatureNotSupportedException("SQL-specific types are not supported."); |
| } |
| |
| /** |
| * Sets query argument value. |
| * |
| * @param paramIdx Index. |
| * @param val Value. |
| * @throws SQLException If index is invalid. |
| */ |
| private void setArgument(int paramIdx, Object val) throws SQLException { |
| ensureNotClosed(); |
| |
| if (paramIdx < 1 || paramIdx > argsCnt) |
| throw new SQLException("Parameter index is invalid: " + paramIdx); |
| |
| if (args == null) |
| args = new Object[argsCnt]; |
| |
| args[paramIdx - 1] = val; |
| } |
| } |