Java Doc for SURBaseTest.java in  » Database-DBMS » db-derby-10.2 » org » apache » derbyTesting » functionTests » tests » jdbcapi » 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 DBMS » db derby 10.2 » org.apache.derbyTesting.functionTests.tests.jdbcapi 
Source Cross Reference  Class Diagram Java Document (Java Doc) 


org.apache.derbyTesting.junit.BaseJDBCTestCase
   org.apache.derbyTesting.functionTests.tests.jdbcapi.SURBaseTest

All known Subclasses:   org.apache.derbyTesting.functionTests.tests.jdbcapi.SURTest,  org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest,  org.apache.derbyTesting.functionTests.tests.jdbcapi.SURQueryMixTest,  org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest,
SURBaseTest
abstract public class SURBaseTest extends BaseJDBCTestCase (Code)
Base class for testing Scrollable Updatable ResultSets. The setUp() provides a Connection to the database. Tests of this class needs to be decorated by a DBSetup and SURDataModelSetup.
author:
   Andreas Korneliussen


Field Summary
final static  StringCURSOR_NOT_POSITIONED_ON_INSERT_ROW
    
final static  StringCURSOR_NOT_UPDATABLE_SQL_STATE
    
final static  StringCURSOR_OPERATION_CONFLICT
    
final static  StringFOR_UPDATE_NOT_PERMITTED_SQL_STATE
    
final static  StringINVALID_CURSOR_STATE_NO_CURRENT_ROW
    
final static  StringLOCK_TIMEOUT_EXPRESSION_SQL_STATE
    
final static  StringLOCK_TIMEOUT_SQL_STATE
    
final static  StringQUERY_NOT_QUALIFIED_FOR_UPDATABLE_RESULTSET
    
final static  StringRESULTSET_NOT_UPDATABLE_SQL_STATE
    
protected  Connectioncon
    
final  intrecordCount
    

Constructor Summary
public  SURBaseTest(String name)
    
public  SURBaseTest(String name, int records)
    

Method Summary
protected  voidassertFailOnUpdate(ResultSet rs)
     Assert that update of ResultSet fails with a SQLException due to read-only ResultSet.
protected  voidassertWarning(SQLWarning warn, String sqlState)
    
protected  voidinitializeConnection(Connection conn)
     Override a connection's default state to ensure it is always in autocommit false and repeatable read as a starting point.
protected  voidscrollBackward(ResultSet rs)
     Scroll backward to the beginning of the ResultSet, and verify tuples while scrolling.
protected  voidscrollBackwardAndUpdate(ResultSet rs)
    
protected  voidscrollBackwardAndUpdatePositioned(ResultSet rs)
     Scroll backward and update the records using positioned updates.
protected  voidscrollForward(ResultSet rs)
     Scroll forward to the end of the ResultSet, and verify tuples while scrolling.
protected  voidscrollForwardAndUpdate(ResultSet rs)
    
protected  voidscrollForwardAndUpdatePositioned(ResultSet rs)
     Scroll forward and do positioned updates.
public  voidsetUp()
     Set up the connection to the database.
protected  voidupdateTuple(ResultSet rs)
    
protected  voidupdateTuplePositioned(ResultSet rs)
    
protected  voidverifyTuple(ResultSet rs)
     Verify the data of a tuple in the ResultSet, based on the data that were inserted.

Field Detail
CURSOR_NOT_POSITIONED_ON_INSERT_ROW
final static String CURSOR_NOT_POSITIONED_ON_INSERT_ROW(Code)



CURSOR_NOT_UPDATABLE_SQL_STATE
final static String CURSOR_NOT_UPDATABLE_SQL_STATE(Code)



CURSOR_OPERATION_CONFLICT
final static String CURSOR_OPERATION_CONFLICT(Code)



FOR_UPDATE_NOT_PERMITTED_SQL_STATE
final static String FOR_UPDATE_NOT_PERMITTED_SQL_STATE(Code)
Error codes and SQL state



INVALID_CURSOR_STATE_NO_CURRENT_ROW
final static String INVALID_CURSOR_STATE_NO_CURRENT_ROW(Code)



LOCK_TIMEOUT_EXPRESSION_SQL_STATE
final static String LOCK_TIMEOUT_EXPRESSION_SQL_STATE(Code)



LOCK_TIMEOUT_SQL_STATE
final static String LOCK_TIMEOUT_SQL_STATE(Code)



QUERY_NOT_QUALIFIED_FOR_UPDATABLE_RESULTSET
final static String QUERY_NOT_QUALIFIED_FOR_UPDATABLE_RESULTSET(Code)



RESULTSET_NOT_UPDATABLE_SQL_STATE
final static String RESULTSET_NOT_UPDATABLE_SQL_STATE(Code)



con
protected Connection con(Code)



recordCount
final int recordCount(Code)




Constructor Detail
SURBaseTest
public SURBaseTest(String name)(Code)
Creates a new instance of SURBaseTest



SURBaseTest
public SURBaseTest(String name, int records)(Code)
Creates a new instance of SURBaseTest




Method Detail
assertFailOnUpdate
protected void assertFailOnUpdate(ResultSet rs) throws SQLException(Code)
Assert that update of ResultSet fails with a SQLException due to read-only ResultSet.



assertWarning
protected void assertWarning(SQLWarning warn, String sqlState) throws SQLException(Code)
Assert that a warning was received



initializeConnection
protected void initializeConnection(Connection conn) throws SQLException(Code)
Override a connection's default state to ensure it is always in autocommit false and repeatable read as a starting point.



scrollBackward
protected void scrollBackward(ResultSet rs) throws SQLException(Code)
Scroll backward to the beginning of the ResultSet, and verify tuples while scrolling.



scrollBackwardAndUpdate
protected void scrollBackwardAndUpdate(ResultSet rs) throws SQLException(Code)
Scroll backward and update the records using updateXXX() and updateRow()



scrollBackwardAndUpdatePositioned
protected void scrollBackwardAndUpdatePositioned(ResultSet rs) throws SQLException(Code)
Scroll backward and update the records using positioned updates.



scrollForward
protected void scrollForward(ResultSet rs) throws SQLException(Code)
Scroll forward to the end of the ResultSet, and verify tuples while scrolling.



scrollForwardAndUpdate
protected void scrollForwardAndUpdate(ResultSet rs) throws SQLException(Code)
Scroll forward and update the tuples using updateXXX() and updateRow()



scrollForwardAndUpdatePositioned
protected void scrollForwardAndUpdatePositioned(ResultSet rs) throws SQLException(Code)
Scroll forward and do positioned updates.



setUp
public void setUp() throws Exception(Code)
Set up the connection to the database.



updateTuple
protected void updateTuple(ResultSet rs) throws SQLException(Code)
Update the current tuple in the ResultSet using updateXXX() and updateRow()



updateTuplePositioned
protected void updateTuplePositioned(ResultSet rs) throws SQLException(Code)
Update the current tuple in the ResultSet using positioned update



verifyTuple
protected void verifyTuple(ResultSet rs) throws SQLException(Code)
Verify the data of a tuple in the ResultSet, based on the data that were inserted.



Methods inherited from org.apache.derbyTesting.junit.BaseJDBCTestCase
public void assertCompileError(String sqlState, String query)(Code)(Java Doc)
public static void assertEquals(Blob b1, Blob b2) throws IOException, SQLException(Code)(Java Doc)
public static void assertEquals(Clob c1, Clob c2) throws IOException, SQLException(Code)(Java Doc)
public static void assertSQLState(String message, String expected, SQLException exception)(Code)(Java Doc)
public static void assertSQLState(String expected, SQLException exception)(Code)(Java Doc)
public void commit() throws SQLException(Code)(Java Doc)
public Statement createStatement() throws SQLException(Code)(Java Doc)
public Statement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException(Code)(Java Doc)
public Connection getConnection() throws SQLException(Code)(Java Doc)
public Connection getConnection(String databaseName, String connAttrs) throws SQLException(Code)(Java Doc)
public Connection getDefaultConnection(String connAttrs) throws SQLException(Code)(Java Doc)
protected void initializeConnection(Connection conn) throws SQLException(Code)(Java Doc)
public Connection openConnection(String databaseName) throws SQLException(Code)(Java Doc)
public Connection openDefaultConnection() throws SQLException(Code)(Java Doc)
public CallableStatement prepareCall(String sql) throws SQLException(Code)(Java Doc)
public PreparedStatement prepareStatement(String sql) throws SQLException(Code)(Java Doc)
public void rollback() throws SQLException(Code)(Java Doc)
public int runSQLCommands(String sqlCommands) throws UnsupportedEncodingException, SQLException(Code)(Java Doc)
public int runScript(InputStream script, String encoding) throws UnsupportedEncodingException, SQLException(Code)(Java Doc)
protected void tearDown() throws java.lang.Exception(Code)(Java Doc)
public static boolean usingDerbyNet()(Code)(Java Doc)
public static boolean usingDerbyNetClient()(Code)(Java Doc)
public static boolean usingEmbedded()(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.