Uses of Class net.sourceforge.jtds.jdbc.ParamInfo

Uses in package net.sourceforge.jtds.jdbc

Constructors with parameter type net.sourceforge.jtds.jdbc.ParamInfo

CachedResultSet.CachedResultSet(JtdsStatement statement, String sql, String procName, ParamInfo[] procedureParams, int resultSetType, int concurrency)
Constructs a new cached result set.
MSCursorResultSet.MSCursorResultSet(JtdsStatement statement, String sql, String procName, ParamInfo[] procedureParams, int resultSetType, int concurrency)
Construct a cursor result set using Microsoft sp_cursorcreate etc.

Fields of type net.sourceforge.jtds.jdbc.ParamInfo

ParamInfo[]
Used to optimize the getParameters() call
ParamInfo
Cursor handle parameter.
ParamInfo
sp_cursorfetch fetchtype parameter.
ParamInfo
sp_cursorfetch numrows IN parameter (for actual fetches).
ParamInfo
sp_cursorfetch numrows OUT parameter (for FETCH_INFO).
ParamInfo
sp_cursor optype parameter.
ParamInfo
sp_cursor rownum parameter.
ParamInfo
sp_cursorfetch rownum IN parameter (for actual fetches).
ParamInfo
sp_cursorfetch rownum OUT parameter (for FETCH_INFO).
ParamInfo
sp_cursor table parameter.
ParamInfo[]
Buffer row used for inserts.
ParamInfo[]
The "insert row".
ParamInfo[]
The cached parameter meta data.
ParamInfo[]
Parameter meta data (Sybase only).
ParamInfo[]
ParamInfo[]
The parameter list for the call.
ParamInfo[]
The array of parameter meta data objects for the current procedure call.
ParamInfo[]
Original parameters.
ParamInfo
The return parameter meta data object for the current procedure call.
ParamInfo[]
The "update" row.
ParamInfo[]
The "update row".

Methods with parameter type net.sourceforge.jtds.jdbc.ParamInfo

void
MSCursorResultSet.cursor(Integer opType, ParamInfo[] row)
Support general cursor operations such as delete, update etc.
void
MSCursorResultSet.cursorCreate(String sql, String procName, ParamInfo[] parameters)
Create a new Cursor result set using the internal sp_cursoropen procedure.
boolean
JtdsStatement.executeSQL(String sql, String spName, ParamInfo[] params, boolean returnKeys, boolean update, boolean useCursor)
Executes any type of SQL.
void
TdsCore.executeSQL(String sql, String procName, ParamInfo[] parameters, boolean noMetaData, int timeOut, int maxRows, int maxFieldSize, boolean sendNow)
Send an SQL statement with optional parameters to the server.
void
TdsCore.executeSQL42(String sql, String procName, ParamInfo[] parameters, boolean noMetaData, boolean sendNow)
Execute SQL using TDS 4.2 protocol.
void
TdsCore.executeSQL50(String sql, String procName, ParamInfo[] parameters)
Execute SQL using TDS 5.0 protocol.
void
TdsCore.executeSQL70(String sql, String procName, ParamInfo[] parameters, boolean noMetaData, boolean sendNow)
Execute SQL using TDS 7.0 protocol.
ResultSet
JtdsStatement.executeSQLQuery(String sql, String spName, ParamInfo[] params, boolean useCursor)
Executes SQL to obtain a result set.
void
Retrieve the TDS native type code for the parameter.
String
Constructs a parameter definition string for use with sp_executesql, sp_prepare, sp_prepexec, sp_cursoropen, sp_cursorprepare and sp_cursorprepexec.
String
Support.getStatementKey(String sql, ParamInfo[] params, int serverType, String catalog, boolean autoCommit, boolean cursor)
Generates a unique statement key for a given SQL statement.
int
TdsData.getTds5ParamSize(String charset, boolean isWideChar, ParamInfo pi, boolean useParamNames)
Calculate the size of the parameter descriptor array for TDS 5 packets.
String
TdsCore.microsoftPrepare(String sql, ParamInfo[] params, boolean needCursor, int resultSetType, int resultSetConcurrency)
Prepares the SQL for use with Microsoft server.
String
ConnectionJDBC2.prepareSQL(JtdsPreparedStatement pstmt, String sql, ParamInfo[] params, boolean returnKeys, boolean cursorNeeded)
Try to convert the SQL statement into a statement prepare.
void
TDS 8 requires collation information for char data descriptors.
void
Update the cached parameter meta data information.
void
Sets the parameter meta data.
String
Update the SQL string and replace the ? markers with parameter names eg @P0, @P1 etc.
String
Support.substituteParameters(String sql, ParamInfo[] list, ConnectionJDBC2 connection)
Substitute actual data for the parameter markers to simulate parameter substitution in a PreparedStatement.
String
TdsCore.sybasePrepare(String sql, ParamInfo[] params)
Creates a light weight stored procedure on a Sybase server.
void
TdsData.writeParam(RequestStream out, CharsetInfo charsetInfo, byte[] collation, ParamInfo pi)
Write a parameter to the server request stream.
void
Write the actual TDS 5 parameter data.
void
TdsData.writeTds5ParamFmt(RequestStream out, String charset, boolean isWideChar, ParamInfo pi, boolean useParamNames)
Write a TDS 5 parameter format descriptor.

Methods with return type net.sourceforge.jtds.jdbc.ParamInfo

ParamInfo
CachedResultSet.buildParameter(int pos, ColInfo info, Object value, boolean isUnicode)
Creates a parameter object for an UPDATE, DELETE or INSERT statement.
ParamInfo[]
CachedResultSet.buildWhereClause(StringBuffer sql, ArrayList params, boolean select)
Builds a WHERE clause for UPDATE or DELETE statements.
ParamInfo[]
Retrieves the parameter meta data array.
ParamInfo
JtdsPreparedStatement.getParameter(int parameterIndex)
Check the supplied index and return the selected parameter.
ParamInfo
ParamInfo[]
Retrieve the parameter meta data from a Sybase prepare.

Generated on September 18 2009