org.firebirdsql.jdbc.FBCallableStatement Maven / Gradle / Ivy
Show all versions of jaybird Show documentation
/*
* Firebird Open Source J2ee connector - jdbc driver
*
* Distributable under LGPL license. You may obtain a copy of the License at
* http://www.gnu.org/copyleft/lgpl.html
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the LGPL License for more details.
*
* This file was created by members of the firebird development team. All
* individual contributions remain the Copyright (C) of those individuals.
* Contributors to this file are either listed here or can be obtained from a
* CVS history command.
*
* All rights reserved.
*/
package org.firebirdsql.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.Ref;
import java.sql.ResultSet;
import java.sql.RowId;
import java.sql.SQLException;
import java.sql.SQLXML;
import java.sql.Time;
import java.sql.Timestamp;
import java.sql.Types;
import java.util.Calendar;
import java.util.Map;
import org.firebirdsql.gds.GDSException;
import org.firebirdsql.gds.impl.GDSHelper;
/**
* JDBC 3.0 compliant implementation of {@link java.sql.CallableStatement}.
*/
public class FBCallableStatement extends AbstractCallableStatement {
/**
* Create instance of this class.
*
* @param c
* instance of {@link AbstractConnection}
* @param sql
* SQL statement containing procedure call.
*
* @throws SQLException
* if SQL error occured.
*/
public FBCallableStatement(GDSHelper c, String sql, int rsType,
int rsConcurrency, int rsHoldability,
FBObjectListener.StatementListener statementListener,
FBObjectListener.BlobListener blobListener)
throws SQLException {
super(c, sql, rsType, rsConcurrency, rsHoldability, statementListener, blobListener);
}
// ----------JDBC 3.0 --- java.sql.PreparedStatement methods ---------------
/**
* Sets the designated parameter to the given java.net.URL value.
* The driver converts this to an SQL DATALINK value
* when it sends it to the database.
*
* @param parameterIndex the first parameter is 1, the second is 2, ...
* @param url the java.net.URL object to be set
* @exception SQLException if a database access error occurs
* @since 1.4
*/
public void setURL(int parameterIndex, URL url) throws SQLException {
throw new FBDriverNotCapableException();
}
/**
* Retrieves the number, types and properties of this
* PreparedStatement object's parameters.
*
* @return a ParameterMetaData object that contains information
* about the number, types and properties of this
* PreparedStatement object's parameters
* @exception SQLException if a database access error occurs
* @see ParameterMetaData
* @since 1.4
*/
public ParameterMetaData getParameterMetaData() throws SQLException {
statementListener.executionStarted(this);
Object syncObject = getSynchronizationObject();
synchronized(syncObject) {
try {
prepareFixedStatement(procedureCall.getSQL(selectableProcedure), true);
} catch (GDSException ge) {
throw new FBSQLException(ge);
}
}
return new FBParameterMetaData(fixedStmt.getInSqlda().sqlvar, gdsHelper);
}
// ----------JDBC 3.0 -- java.sql.CallableStatement methods ----------------
public void registerOutParameter(String param1, int param2)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void registerOutParameter(String param1, int param2, int param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void registerOutParameter(String param1, int param2, String param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public URL getURL(int colIndex) throws SQLException {
assertHasData(getCurrentResultSet());
//cast apparently to allow use of jdbc 2 interfaces with jdbc 3
// methods.
return ((FBResultSet) getCurrentResultSet()).getURL(colIndex);
}
public void setURL(String param1, URL param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setNull(String param1, int param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setBoolean(String param1, boolean param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setByte(String param1, byte param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setShort(String param1, short param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setInt(String param1, int param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setLong(String param1, long param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setFloat(String param1, float param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setDouble(String param1, double param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setBigDecimal(String param1, BigDecimal param2)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setString(String param1, String param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setBytes(String param1, byte[] param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setDate(String param1, Date param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setTime(String param1, Time param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setTimestamp(String param1, Timestamp param2)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setAsciiStream(String param1, InputStream param2, int param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setBinaryStream(String param1, InputStream param2, int param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setObject(String param1, Object param2, int param3, int param4)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setObject(String param1, Object param2, int param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setObject(String param1, Object param2) throws SQLException {
throw new SQLException("not yet implemented");
}
public void setCharacterStream(String param1, Reader param2, int param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setDate(String param1, Date param2, Calendar param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setTime(String param1, Time param2, Calendar param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setTimestamp(String param1, Timestamp param2, Calendar param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public void setNull(String param1, int param2, String param3)
throws SQLException {
throw new SQLException("not yet implemented");
}
public String getString(String colName) throws SQLException {
return getString(getCurrentResultSet().findColumn(colName));
}
public boolean getBoolean(String colName) throws SQLException {
return getBoolean(getCurrentResultSet().findColumn(colName));
}
public byte getByte(String colName) throws SQLException {
return getByte(getCurrentResultSet().findColumn(colName));
}
public short getShort(String colName) throws SQLException {
return getShort(getCurrentResultSet().findColumn(colName));
}
public int getInt(String colName) throws SQLException {
return getInt(getCurrentResultSet().findColumn(colName));
}
public long getLong(String colName) throws SQLException {
return getLong(getCurrentResultSet().findColumn(colName));
}
public float getFloat(String colName) throws SQLException {
return getFloat(getCurrentResultSet().findColumn(colName));
}
public double getDouble(String colName) throws SQLException {
return getDouble(getCurrentResultSet().findColumn(colName));
}
public byte[] getBytes(String colName) throws SQLException {
return getBytes(getCurrentResultSet().findColumn(colName));
}
public Date getDate(String colName) throws SQLException {
return getDate(getCurrentResultSet().findColumn(colName));
}
public Time getTime(String colName) throws SQLException {
return getTime(getCurrentResultSet().findColumn(colName));
}
public Timestamp getTimestamp(String colName) throws SQLException {
return getTimestamp(getCurrentResultSet().findColumn(colName));
}
public Object getObject(String colName) throws SQLException {
return getObject(getCurrentResultSet().findColumn(colName));
}
public BigDecimal getBigDecimal(String colName) throws SQLException {
return getBigDecimal(getCurrentResultSet().findColumn(colName));
}
public Object getObject(String colName, Map map) throws SQLException {
return getObject(getCurrentResultSet().findColumn(colName), map);
}
public Ref getRef(String colName) throws SQLException {
return getRef(getCurrentResultSet().findColumn(colName));
}
public Blob getBlob(String colName) throws SQLException {
return getBlob(getCurrentResultSet().findColumn(colName));
}
public Clob getClob(String colName) throws SQLException {
return getClob(getCurrentResultSet().findColumn(colName));
}
public Array getArray(String colName) throws SQLException {
return getArray(getCurrentResultSet().findColumn(colName));
}
public Date getDate(String colName, Calendar cal) throws SQLException {
return getDate(getCurrentResultSet().findColumn(colName), cal);
}
public Time getTime(String colName, Calendar cal) throws SQLException {
return getTime(getCurrentResultSet().findColumn(colName), cal);
}
public Timestamp getTimestamp(String colName, Calendar cal)
throws SQLException {
return getTimestamp(getCurrentResultSet().findColumn(colName), cal);
}
public URL getURL(String colName) throws SQLException {
return getURL(getCurrentResultSet().findColumn(colName));
}
/**
*
* Registers the designated output parameter. This version of
* the method registerOutParameter
* should be used for a user-named or REF output parameter. Examples
* of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and
* named array types.
*
* Before executing a stored procedure call, you must explicitly
* call registerOutParameter to register the type from
* java.sql.Types for each
* OUT parameter. For a user-named parameter the fully-qualified SQL
* type name of the parameter should also be given, while a REF
* parameter requires that the fully-qualified type name of the
* referenced type be given. A JDBC driver that does not need the
* type code and type name information may ignore it. To be portable,
* however, applications should always provide these values for
* user-named and REF parameters.
*
* Although it is intended for user-named and REF parameters,
* this method may be used to register a parameter of any JDBC type.
* If the parameter does not have a user-named or REF type, the
* typeName parameter is ignored.
*
* Note: When reading the value of an out parameter, you
* must use the getXXX method whose Java type XXX corresponds to the
* parameter's registered SQL type.
*
* @param parameterIndex the first parameter is 1, the second is 2,...
* @param sqlType a value from {@link java.sql.Types}
* @param typeName the fully-qualified name of an SQL structured type
* @exception SQLException if a database access error occurs
* @see Types
* @since 1.2
* @see What Is in the JDBC 2.0 API
*/
public void registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException {
throw new FBDriverNotCapableException();
}
/**
* jdbc 3
* @return
* @exception java.sql.SQLException
*/
public ResultSet getGeneratedKeys() throws SQLException {
// TODO: implement this java.sql.Statement method
throw new SQLException("not yet implemented");
}
/**
* jdbc 3
* @param param1
* @param param2
* @return
* @exception java.sql.SQLException
*/
public int executeUpdate(String param1, int param2) throws SQLException {
// TODO: implement this java.sql.Statement method
throw new SQLException("Not yet implemented");
}
/**
* jdbc 3
* @param param1
* @param param2
* @return
* @exception java.sql.SQLException
*/
public int executeUpdate(String param1, int[] param2) throws SQLException {
// TODO: implement this java.sql.Statement method
throw new SQLException("Not yet implemented");
}
/**
* jdbc 3
* @param param1
* @param param2
* @return
* @exception java.sql.SQLException
*/
public int executeUpdate(String param1, String[] param2) throws SQLException {
// TODO: implement this java.sql.Statement method
throw new SQLException("Not yet implemented");
}
/**
* jdbc 3
* @param param1
* @param param2
* @return
* @exception java.sql.SQLException
*/
public boolean execute(String param1, int param2) throws SQLException {
// TODO: implement this java.sql.Statement method
throw new SQLException("not yet implemented");
}
/**
* jdbc 3
* @param param1
* @param param2
* @return
* @exception java.sql.SQLException
*/
public boolean execute(String param1, int[] param2) throws SQLException {
// TODO: implement this java.sql.Statement method
throw new SQLException("not yet implemented");
}
/**
* jdbc 3
* @param param1
* @param param2
* @return
* @exception java.sql.SQLException
*/
public boolean execute(String param1, String[] param2) throws SQLException {
// TODO: implement this java.sql.Statement method
throw new SQLException("not yet implemented");
}
public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setCharacterStream(int parameterIndex, Reader reader, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setClob(int parameterIndex, Reader reader, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setClob(int parameterIndex, Reader reader) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNCharacterStream(int parameterIndex, Reader value, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNCharacterStream(int parameterIndex, Reader value) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNClob(int parameterIndex, NClob value) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNClob(int parameterIndex, Reader reader, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNClob(int parameterIndex, Reader reader) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNString(int parameterIndex, String value) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setRowId(int parameterIndex, RowId x) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setSQLXML(int parameterIndex, SQLXML xmlObject) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public Reader getCharacterStream(int parameterIndex) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public Reader getCharacterStream(String parameterName) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public Reader getNCharacterStream(int parameterIndex) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public Reader getNCharacterStream(String parameterName) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public NClob getNClob(int parameterIndex) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public NClob getNClob(String parameterName) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public String getNString(int parameterIndex) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public String getNString(String parameterName) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public RowId getRowId(int parameterIndex) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public RowId getRowId(String parameterName) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public SQLXML getSQLXML(int parameterIndex) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public SQLXML getSQLXML(String parameterName) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setAsciiStream(String parameterName, InputStream x) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setBinaryStream(String parameterName, InputStream x) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setBlob(String parameterName, Blob x) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setBlob(String parameterName, InputStream inputStream) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setCharacterStream(String parameterName, Reader reader) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setClob(String parameterName, Clob x) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setClob(String parameterName, Reader reader, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setClob(String parameterName, Reader reader) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNCharacterStream(String parameterName, Reader value, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNCharacterStream(String parameterName, Reader value) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNClob(String parameterName, NClob value) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNClob(String parameterName, Reader reader, long length) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNClob(String parameterName, Reader reader) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setNString(String parameterName, String value) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setRowId(String parameterName, RowId x) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public boolean isPoolable() throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public void setPoolable(boolean poolable) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public boolean isWrapperFor(Class arg0) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
public Object unwrap(Class arg0) throws SQLException {
// TODO: implement this java.sql.PreparedStatement method
throw new SQLException("not yet implemented");
}
}