Java Doc for MSCursorResultSet.java in  » Database-JDBC-Connection-Pool » jTDS » net » sourceforge » jtds » jdbc » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation
1. 6.0 JDK Core
2. 6.0 JDK Modules
3. 6.0 JDK Modules com.sun
4. 6.0 JDK Modules com.sun.java
5. 6.0 JDK Modules sun
6. 6.0 JDK Platform
7. Ajax
8. Apache Harmony Java SE
9. Aspect oriented
10. Authentication Authorization
11. Blogger System
12. Build
13. Byte Code
14. Cache
15. Chart
16. Chat
17. Code Analyzer
18. Collaboration
19. Content Management System
20. Database Client
21. Database DBMS
22. Database JDBC Connection Pool
23. Database ORM
24. Development
25. EJB Server geronimo
26. EJB Server GlassFish
27. EJB Server JBoss 4.2.1
28. EJB Server resin 3.1.5
29. ERP CRM Financial
30. ESB
31. Forum
32. GIS
33. Graphic Library
34. Groupware
35. HTML Parser
36. IDE
37. IDE Eclipse
38. IDE Netbeans
39. Installer
40. Internationalization Localization
41. Inversion of Control
42. Issue Tracking
43. J2EE
44. JBoss
45. JMS
46. JMX
47. Library
48. Mail Clients
49. Net
50. Parser
51. PDF
52. Portal
53. Profiler
54. Project Management
55. Report
56. RSS RDF
57. Rule Engine
58. Science
59. Scripting
60. Search Engine
61. Security
62. Sevlet Container
63. Source Control
64. Swing Library
65. Template Engine
66. Test Coverage
67. Testing
68. UML
69. Web Crawler
70. Web Framework
71. Web Mail
72. Web Server
73. Web Services
74. Web Services apache cxf 2.0.1
75. Web Services AXIS2
76. Wiki Engine
77. Workflow Engines
78. XML
79. XML UI
Java
Java Tutorial
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Java Source Code / Java Documentation » Database JDBC Connection Pool » jTDS » net.sourceforge.jtds.jdbc 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


java.lang.Object
   net.sourceforge.jtds.jdbc.JtdsResultSet
      net.sourceforge.jtds.jdbc.MSCursorResultSet

MSCursorResultSet
public class MSCursorResultSet extends JtdsResultSet (Code)
This class extends the JtdsResultSet to support scrollable and or updateable cursors on Microsoft servers.

The undocumented Microsoft sp_cursor procedures are used.

Implementation notes:

  1. All of Alin's cursor result set logic is incorporated here.
  2. This logic was originally implemented in the JtdsResultSet class but on reflection it seems that Alin's original approch of having a dedicated cursor class leads to a more flexible and maintainable design.

author:
   Alin Sinpalean
author:
   Mike Hutchinson
version:
   $Id: MSCursorResultSet.java,v 1.59 2007/07/11 20:02:45 bheineman Exp $



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

Method Summary
public  booleanabsolute(int row)
    
public  voidafterLast()
    
public  voidbeforeFirst()
    
public  voidcancelRowUpdates()
    
public  voidclose()
    
public  voiddeleteRow()
    
public  booleanfirst()
    
protected  ObjectgetColumn(int index)
     Get the specified column's data item.
protected  Object[]getCurrentRow()
    
static  intgetCursorConcurrencyOpt(int resultSetConcurrency)
     Translates a JDBC result set concurrency into SQL Server native @ccOpt value for use with stored procedures such as sp_cursoropen, sp_cursorprepare or sp_cursorprepexec.
static  intgetCursorScrollOpt(int resultSetType, int resultSetConcurrency, boolean parameterized)
     Translates a JDBC result set type into SQL Server native @scrollOpt value for use with stored procedures such as sp_cursoropen, sp_cursorprepare or sp_cursorprepexec.
public  voidinsertRow()
    
public  booleanisLast()
    
public  booleanlast()
    
public  voidmoveToCurrentRow()
    
public  voidmoveToInsertRow()
    
public  booleannext()
    
public  booleanprevious()
    
public  voidrefreshRow()
    
public  booleanrelative(int row)
    
public  booleanrowDeleted()
    
public  booleanrowInserted()
    
public  booleanrowUpdated()
    
protected  ObjectsetColValue(int colIndex, int jdbcType, Object value, int length)
     Set the specified column's data value.
public  voidupdateRow()
    


Constructor Detail
MSCursorResultSet
MSCursorResultSet(JtdsStatement statement, String sql, String procName, ParamInfo[] procedureParams, int resultSetType, int concurrency) throws SQLException(Code)
Construct a cursor result set using Microsoft sp_cursorcreate etc.
Parameters:
  statement - The parent statement object or null.
Parameters:
  resultSetType - one of FORWARD_ONLY, SCROLL_INSENSITIVE, SCROLL_SENSITIVE.
Parameters:
  concurrency - One of CONCUR_READ_ONLY, CONCUR_UPDATE.
throws:
  SQLException -



Method Detail
absolute
public boolean absolute(int row) throws SQLException(Code)


afterLast
public void afterLast() throws SQLException(Code)


beforeFirst
public void beforeFirst() throws SQLException(Code)


cancelRowUpdates
public void cancelRowUpdates() throws SQLException(Code)


close
public void close() throws SQLException(Code)


deleteRow
public void deleteRow() throws SQLException(Code)


first
public boolean first() throws SQLException(Code)


getColumn
protected Object getColumn(int index) throws SQLException(Code)
Get the specified column's data item.
Parameters:
  index - the column index in the row the column value as an Object
throws:
  SQLException - if the index is out of bounds or there is nocurrent row


getCurrentRow
protected Object[] getCurrentRow()(Code)


getCursorConcurrencyOpt
static int getCursorConcurrencyOpt(int resultSetConcurrency)(Code)
Translates a JDBC result set concurrency into SQL Server native @ccOpt value for use with stored procedures such as sp_cursoropen, sp_cursorprepare or sp_cursorprepexec.
Parameters:
  resultSetConcurrency - JDBC result set concurrency (one of theResultSet.CONCUR_XXXvalues) a value for the @scrollOpt parameter


getCursorScrollOpt
static int getCursorScrollOpt(int resultSetType, int resultSetConcurrency, boolean parameterized)(Code)
Translates a JDBC result set type into SQL Server native @scrollOpt value for use with stored procedures such as sp_cursoropen, sp_cursorprepare or sp_cursorprepexec.
Parameters:
  resultSetType - JDBC result set type (one of theResultSet.TYPE_XXXvalues)
Parameters:
  resultSetConcurrency - JDBC result set concurrency (one of theResultSet.CONCUR_XXXvalues) a value for the @scrollOpt parameter


insertRow
public void insertRow() throws SQLException(Code)


isLast
public boolean isLast() throws SQLException(Code)


last
public boolean last() throws SQLException(Code)


moveToCurrentRow
public void moveToCurrentRow() throws SQLException(Code)


moveToInsertRow
public void moveToInsertRow() throws SQLException(Code)


next
public boolean next() throws SQLException(Code)


previous
public boolean previous() throws SQLException(Code)


refreshRow
public void refreshRow() throws SQLException(Code)


relative
public boolean relative(int row) throws SQLException(Code)


rowDeleted
public boolean rowDeleted() throws SQLException(Code)


rowInserted
public boolean rowInserted() throws SQLException(Code)


rowUpdated
public boolean rowUpdated() throws SQLException(Code)


setColValue
protected Object setColValue(int colIndex, int jdbcType, Object value, int length) throws SQLException(Code)
Set the specified column's data value.
Parameters:
  colIndex - index of the column
Parameters:
  value - new column value the value, possibly converted to an internal type


updateRow
public void updateRow() throws SQLException(Code)


Fields inherited from net.sourceforge.jtds.jdbc.JtdsResultSet
final static int CLOSE_CURSORS_AT_COMMIT(Code)(Java Doc)
final static int HOLD_CURSORS_OVER_COMMIT(Code)(Java Doc)
final protected static int INITIAL_ROW_COUNT(Code)(Java Doc)
final protected static int POS_AFTER_LAST(Code)(Java Doc)
final protected static int POS_BEFORE_FIRST(Code)(Java Doc)
protected boolean cancelled(Code)(Java Doc)
protected boolean closed(Code)(Java Doc)
protected int columnCount(Code)(Java Doc)
protected ColInfo[] columns(Code)(Java Doc)
protected int concurrency(Code)(Java Doc)
protected Object[] currentRow(Code)(Java Doc)
protected String cursorName(Code)(Java Doc)
protected int direction(Code)(Java Doc)
protected int fetchDirection(Code)(Java Doc)
protected int fetchSize(Code)(Java Doc)
protected int pos(Code)(Java Doc)
protected int resultSetType(Code)(Java Doc)
protected ArrayList rowData(Code)(Java Doc)
protected int rowPtr(Code)(Java Doc)
protected int rowsInResult(Code)(Java Doc)
protected JtdsStatement statement(Code)(Java Doc)
protected boolean wasNull(Code)(Java Doc)

Methods inherited from net.sourceforge.jtds.jdbc.JtdsResultSet
public boolean absolute(int row) throws SQLException(Code)(Java Doc)
public void afterLast() throws SQLException(Code)(Java Doc)
public void beforeFirst() throws SQLException(Code)(Java Doc)
protected void cacheResultSetRows() throws SQLException(Code)(Java Doc)
public void cancelRowUpdates() throws SQLException(Code)(Java Doc)
protected void checkOpen() throws SQLException(Code)(Java Doc)
protected void checkScrollable() throws SQLException(Code)(Java Doc)
protected void checkUpdateable() throws SQLException(Code)(Java Doc)
public void clearWarnings() throws SQLException(Code)(Java Doc)
public void close() throws SQLException(Code)(Java Doc)
protected ColInfo[] copyInfo(ColInfo[] info)(Code)(Java Doc)
protected Object[] copyRow(Object[] row)(Code)(Java Doc)
public void deleteRow() throws SQLException(Code)(Java Doc)
public int findColumn(String columnName) throws SQLException(Code)(Java Doc)
public boolean first() throws SQLException(Code)(Java Doc)
public Array getArray(int columnIndex) throws SQLException(Code)(Java Doc)
public Array getArray(String columnName) throws SQLException(Code)(Java Doc)
public InputStream getAsciiStream(int columnIndex) throws SQLException(Code)(Java Doc)
public InputStream getAsciiStream(String columnName) throws SQLException(Code)(Java Doc)
public BigDecimal getBigDecimal(int columnIndex) throws SQLException(Code)(Java Doc)
public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException(Code)(Java Doc)
public BigDecimal getBigDecimal(String columnName) throws SQLException(Code)(Java Doc)
public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException(Code)(Java Doc)
public InputStream getBinaryStream(int columnIndex) throws SQLException(Code)(Java Doc)
public InputStream getBinaryStream(String columnName) throws SQLException(Code)(Java Doc)
public Blob getBlob(int columnIndex) throws SQLException(Code)(Java Doc)
public Blob getBlob(String columnName) throws SQLException(Code)(Java Doc)
public boolean getBoolean(int columnIndex) throws SQLException(Code)(Java Doc)
public boolean getBoolean(String columnName) throws SQLException(Code)(Java Doc)
public byte getByte(int columnIndex) throws SQLException(Code)(Java Doc)
public byte getByte(String columnName) throws SQLException(Code)(Java Doc)
public byte[] getBytes(int columnIndex) throws SQLException(Code)(Java Doc)
public byte[] getBytes(String columnName) throws SQLException(Code)(Java Doc)
public Reader getCharacterStream(int columnIndex) throws SQLException(Code)(Java Doc)
public Reader getCharacterStream(String columnName) throws SQLException(Code)(Java Doc)
public Clob getClob(int columnIndex) throws SQLException(Code)(Java Doc)
public Clob getClob(String columnName) throws SQLException(Code)(Java Doc)
protected Object getColumn(int index) throws SQLException(Code)(Java Doc)
protected static int getColumnCount(ColInfo[] columns)(Code)(Java Doc)
protected ColInfo[] getColumns()(Code)(Java Doc)
public int getConcurrency() throws SQLException(Code)(Java Doc)
protected Object[] getCurrentRow()(Code)(Java Doc)
public String getCursorName() throws SQLException(Code)(Java Doc)
public Date getDate(int columnIndex) throws SQLException(Code)(Java Doc)
public Date getDate(String columnName) throws SQLException(Code)(Java Doc)
public Date getDate(int columnIndex, Calendar cal) throws SQLException(Code)(Java Doc)
public Date getDate(String columnName, Calendar cal) throws SQLException(Code)(Java Doc)
public double getDouble(int columnIndex) throws SQLException(Code)(Java Doc)
public double getDouble(String columnName) throws SQLException(Code)(Java Doc)
public int getFetchDirection() throws SQLException(Code)(Java Doc)
public int getFetchSize() throws SQLException(Code)(Java Doc)
public float getFloat(int columnIndex) throws SQLException(Code)(Java Doc)
public float getFloat(String columnName) throws SQLException(Code)(Java Doc)
public int getInt(int columnIndex) throws SQLException(Code)(Java Doc)
public int getInt(String columnName) throws SQLException(Code)(Java Doc)
public long getLong(int columnIndex) throws SQLException(Code)(Java Doc)
public long getLong(String columnName) throws SQLException(Code)(Java Doc)
public ResultSetMetaData getMetaData() throws SQLException(Code)(Java Doc)
public Object getObject(int columnIndex) throws SQLException(Code)(Java Doc)
public Object getObject(String columnName) throws SQLException(Code)(Java Doc)
public Object getObject(int columnIndex, Map map) throws SQLException(Code)(Java Doc)
public Object getObject(String columnName, Map map) throws SQLException(Code)(Java Doc)
public Ref getRef(int columnIndex) throws SQLException(Code)(Java Doc)
public Ref getRef(String columnName) throws SQLException(Code)(Java Doc)
public int getRow() throws SQLException(Code)(Java Doc)
public short getShort(int columnIndex) throws SQLException(Code)(Java Doc)
public short getShort(String columnName) throws SQLException(Code)(Java Doc)
public Statement getStatement() throws SQLException(Code)(Java Doc)
public String getString(int columnIndex) throws SQLException(Code)(Java Doc)
public String getString(String columnName) throws SQLException(Code)(Java Doc)
public Time getTime(int columnIndex) throws SQLException(Code)(Java Doc)
public Time getTime(String columnName) throws SQLException(Code)(Java Doc)
public Time getTime(int columnIndex, Calendar cal) throws SQLException(Code)(Java Doc)
public Time getTime(String columnName, Calendar cal) throws SQLException(Code)(Java Doc)
public Timestamp getTimestamp(int columnIndex) throws SQLException(Code)(Java Doc)
public Timestamp getTimestamp(String columnName) throws SQLException(Code)(Java Doc)
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException(Code)(Java Doc)
public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException(Code)(Java Doc)
public int getType() throws SQLException(Code)(Java Doc)
public URL getURL(int columnIndex) throws SQLException(Code)(Java Doc)
public URL getURL(String columnName) throws SQLException(Code)(Java Doc)
public InputStream getUnicodeStream(int columnIndex) throws SQLException(Code)(Java Doc)
public InputStream getUnicodeStream(String columnName) throws SQLException(Code)(Java Doc)
public SQLWarning getWarnings() throws SQLException(Code)(Java Doc)
public void insertRow() throws SQLException(Code)(Java Doc)
public boolean isAfterLast() throws SQLException(Code)(Java Doc)
public boolean isBeforeFirst() throws SQLException(Code)(Java Doc)
public boolean isFirst() throws SQLException(Code)(Java Doc)
public boolean isLast() throws SQLException(Code)(Java Doc)
public boolean last() throws SQLException(Code)(Java Doc)
public void moveToCurrentRow() throws SQLException(Code)(Java Doc)
public void moveToInsertRow() throws SQLException(Code)(Java Doc)
protected Object[] newRow()(Code)(Java Doc)
public boolean next() throws SQLException(Code)(Java Doc)
protected static void notImplemented(String method) throws SQLException(Code)(Java Doc)
public boolean previous() throws SQLException(Code)(Java Doc)
public void refreshRow() throws SQLException(Code)(Java Doc)
public boolean relative(int row) throws SQLException(Code)(Java Doc)
public boolean rowDeleted() throws SQLException(Code)(Java Doc)
public boolean rowInserted() throws SQLException(Code)(Java Doc)
public boolean rowUpdated() throws SQLException(Code)(Java Doc)
protected void setColLabel(int colIndex, String name)(Code)(Java Doc)
protected void setColName(int colIndex, String name)(Code)(Java Doc)
protected void setColType(int colIndex, int jdbcType)(Code)(Java Doc)
protected Object setColValue(int colIndex, int jdbcType, Object value, int length) throws SQLException(Code)(Java Doc)
protected void setColumnCount(int columnCount)(Code)(Java Doc)
public void setFetchDirection(int direction) throws SQLException(Code)(Java Doc)
public void setFetchSize(int rows) throws SQLException(Code)(Java Doc)
public void updateArray(int columnIndex, Array x) throws SQLException(Code)(Java Doc)
public void updateArray(String columnName, Array x) throws SQLException(Code)(Java Doc)
public void updateAsciiStream(int columnIndex, InputStream inputStream, int length) throws SQLException(Code)(Java Doc)
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException(Code)(Java Doc)
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException(Code)(Java Doc)
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException(Code)(Java Doc)
public void updateBinaryStream(int columnIndex, InputStream inputStream, int length) throws SQLException(Code)(Java Doc)
public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException(Code)(Java Doc)
public void updateBlob(int columnIndex, Blob x) throws SQLException(Code)(Java Doc)
public void updateBlob(String columnName, Blob x) throws SQLException(Code)(Java Doc)
public void updateBoolean(int columnIndex, boolean x) throws SQLException(Code)(Java Doc)
public void updateBoolean(String columnName, boolean x) throws SQLException(Code)(Java Doc)
public void updateByte(int columnIndex, byte x) throws SQLException(Code)(Java Doc)
public void updateByte(String columnName, byte x) throws SQLException(Code)(Java Doc)
public void updateBytes(int columnIndex, byte[] x) throws SQLException(Code)(Java Doc)
public void updateBytes(String columnName, byte[] x) throws SQLException(Code)(Java Doc)
public void updateCharacterStream(int columnIndex, Reader reader, int length) throws SQLException(Code)(Java Doc)
public void updateCharacterStream(String columnName, Reader x, int length) throws SQLException(Code)(Java Doc)
public void updateClob(int columnIndex, Clob x) throws SQLException(Code)(Java Doc)
public void updateClob(String columnName, Clob x) throws SQLException(Code)(Java Doc)
public void updateDate(int columnIndex, Date x) throws SQLException(Code)(Java Doc)
public void updateDate(String columnName, Date x) throws SQLException(Code)(Java Doc)
public void updateDouble(int columnIndex, double x) throws SQLException(Code)(Java Doc)
public void updateDouble(String columnName, double x) throws SQLException(Code)(Java Doc)
public void updateFloat(int columnIndex, float x) throws SQLException(Code)(Java Doc)
public void updateFloat(String columnName, float x) throws SQLException(Code)(Java Doc)
public void updateInt(int columnIndex, int x) throws SQLException(Code)(Java Doc)
public void updateInt(String columnName, int x) throws SQLException(Code)(Java Doc)
public void updateLong(int columnIndex, long x) throws SQLException(Code)(Java Doc)
public void updateLong(String columnName, long x) throws SQLException(Code)(Java Doc)
public void updateNull(int columnIndex) throws SQLException(Code)(Java Doc)
public void updateNull(String columnName) throws SQLException(Code)(Java Doc)
public void updateObject(int columnIndex, Object x) throws SQLException(Code)(Java Doc)
public void updateObject(int columnIndex, Object x, int scale) throws SQLException(Code)(Java Doc)
public void updateObject(String columnName, Object x) throws SQLException(Code)(Java Doc)
public void updateObject(String columnName, Object x, int scale) throws SQLException(Code)(Java Doc)
public void updateRef(int columnIndex, Ref x) throws SQLException(Code)(Java Doc)
public void updateRef(String columnName, Ref x) throws SQLException(Code)(Java Doc)
public void updateRow() throws SQLException(Code)(Java Doc)
public void updateShort(int columnIndex, short x) throws SQLException(Code)(Java Doc)
public void updateShort(String columnName, short x) throws SQLException(Code)(Java Doc)
public void updateString(int columnIndex, String x) throws SQLException(Code)(Java Doc)
public void updateString(String columnName, String x) throws SQLException(Code)(Java Doc)
public void updateTime(int columnIndex, Time x) throws SQLException(Code)(Java Doc)
public void updateTime(String columnName, Time x) throws SQLException(Code)(Java Doc)
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException(Code)(Java Doc)
public void updateTimestamp(String columnName, Timestamp x) throws SQLException(Code)(Java Doc)
public boolean wasNull() throws SQLException(Code)(Java Doc)

Methods inherited from java.lang.Object
native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc)
public boolean equals(Object obj)(Code)(Java Doc)
protected void finalize() throws Throwable(Code)(Java Doc)
final native public Class getClass()(Code)(Java Doc)
native public int hashCode()(Code)(Java Doc)
final native public void notify()(Code)(Java Doc)
final native public void notifyAll()(Code)(Java Doc)
public String toString()(Code)(Java Doc)
final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc)
final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc)
final public void wait() throws InterruptedException(Code)(Java Doc)

www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.