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


org.apache.derbyTesting.junit.BaseJDBCTestCase
   org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest

PreparedStatementTest
public class PreparedStatementTest extends BaseJDBCTestCase (Code)
This class is used to test JDBC4 specific methods in the PreparedStatement(s) object. A number of methods and variables are in place to aid the writing of tests:
  • setBinaryStreamOnBlob
  • setAsciiStream
  • key - an id. One is generated each time setUp is run.
  • reqeustKey() - generate a new unique id.
  • psInsertX - prepared statements for insert.
  • psFetchX - prepared statements for fetching values.
For table creation, see the suite-method.



Constructor Summary
public  PreparedStatementTest(String name)
     Create a test with the given name.

Method Summary
public  voidsetUp()
     Obtain a "regular" connection and PreparedStatement that the tests can use.
public static  Testsuite()
    
public  voidtearDown()
    
public  voidtestBlobExceptionDoesNotRollbackOtherStatements()
    
public  voidtestExceptionPathMultiplePages_bs()
    
public  voidtestExceptionPathOnePage_bs()
    
public  voidtestIsNotWrapperForCallableStatement()
    
public  voidtestIsNotWrapperForResultSet()
    
public  voidtestIsPoolable()
    
public  voidtestIsWrapperForPreparedStatement()
    
public  voidtestIsWrapperForStatement()
    
public  voidtestSetAsciiStream()
    
public  voidtestSetAsciiStreamLengthLess1KOnClob()
    
public  voidtestSetAsciiStreamLengthLess32KOnClob()
    
public  voidtestSetAsciiStreamLengthLess65KOnClob()
    
public  voidtestSetAsciiStreamLengthLessOnClobTooLong()
    
public  voidtestSetAsciiStreamLengthLessOnClobTooLongTruncate()
    
public  voidtestSetAsciiStreamLengthless()
    
public  voidtestSetAsciiStreamLengthlessOnLongVarCharDontTruncate()
    
public  voidtestSetAsciiStreamLengthlessOnLongVarCharTooLong()
    
public  voidtestSetBinaryStream()
    
public  voidtestSetBinaryStreamLengthLess1KOnBlob()
    
public  voidtestSetBinaryStreamLengthLess32KOnBlob()
    
public  voidtestSetBinaryStreamLengthLess65KOnBlob()
    
public  voidtestSetBinaryStreamLengthLessOnBlobTooLong()
    
public  voidtestSetBinaryStreamLengthless()
    
public  voidtestSetBlob()
    
public  voidtestSetBlobLengthless()
     Insert Blob without specifying length and read it back for verification. Beacuse we don't yet support Connection.createBlob in the client driver, we must first insert data into the database and read back a Blob object.
public  voidtestSetCharacterStream()
    
public  voidtestSetCharacterStreamLengthless()
    
public  voidtestSetClob()
    
public  voidtestSetClobLengthless()
     Insert Clob without specifying length and read it back for verification. Beacuse we don't yet support Connection.createClob in the client driver, we must first insert data into the database and read back a Clob object.
public  voidtestSetNCharacterStream()
    
public  voidtestSetNCharacterStreamLengthlessNotImplemented()
    
public  voidtestSetNClob1()
    
public  voidtestSetNClob2()
    
public  voidtestSetNClobLengthlessNotImplemented()
    
public  voidtestSetNString()
    
public  voidtestSetPoolable()
    
public  voidtestSetRowId()
    
public  voidtestSetSQLXML()
    
public  voidtestUnwrapCallableStatement()
    
public  voidtestUnwrapPreparedStatement()
    
public  voidtestUnwrapResultSet()
    
public  voidtestUnwrapStatement()
    


Constructor Detail
PreparedStatementTest
public PreparedStatementTest(String name)(Code)
Create a test with the given name.
Parameters:
  name - name of the test.




Method Detail
setUp
public void setUp() throws SQLException(Code)
Obtain a "regular" connection and PreparedStatement that the tests can use.
throws:
  SQLException -



suite
public static Test suite()(Code)



tearDown
public void tearDown() throws Exception(Code)
Release the resources that are used in this test
throws:
  SQLException -



testBlobExceptionDoesNotRollbackOtherStatements
public void testBlobExceptionDoesNotRollbackOtherStatements() throws IOException, SQLException(Code)



testExceptionPathMultiplePages_bs
public void testExceptionPathMultiplePages_bs() throws SQLException(Code)



testExceptionPathOnePage_bs
public void testExceptionPathOnePage_bs() throws SQLException(Code)



testIsNotWrapperForCallableStatement
public void testIsNotWrapperForCallableStatement() throws SQLException(Code)



testIsNotWrapperForResultSet
public void testIsNotWrapperForResultSet() throws SQLException(Code)



testIsPoolable
public void testIsPoolable() throws SQLException(Code)
Tests the PreparedStatement interface method isPoolable
throws:
  SQLException -



testIsWrapperForPreparedStatement
public void testIsWrapperForPreparedStatement() throws SQLException(Code)



testIsWrapperForStatement
public void testIsWrapperForStatement() throws SQLException(Code)



testSetAsciiStream
public void testSetAsciiStream() throws Exception(Code)
Tests the PreparedStatement interface method setAsciiStream
throws:
  SQLException -



testSetAsciiStreamLengthLess1KOnClob
public void testSetAsciiStreamLengthLess1KOnClob() throws IOException, SQLException(Code)



testSetAsciiStreamLengthLess32KOnClob
public void testSetAsciiStreamLengthLess32KOnClob() throws IOException, SQLException(Code)



testSetAsciiStreamLengthLess65KOnClob
public void testSetAsciiStreamLengthLess65KOnClob() throws IOException, SQLException(Code)



testSetAsciiStreamLengthLessOnClobTooLong
public void testSetAsciiStreamLengthLessOnClobTooLong()(Code)



testSetAsciiStreamLengthLessOnClobTooLongTruncate
public void testSetAsciiStreamLengthLessOnClobTooLongTruncate() throws SQLException(Code)



testSetAsciiStreamLengthless
public void testSetAsciiStreamLengthless() throws IOException, SQLException(Code)



testSetAsciiStreamLengthlessOnLongVarCharDontTruncate
public void testSetAsciiStreamLengthlessOnLongVarCharDontTruncate()(Code)



testSetAsciiStreamLengthlessOnLongVarCharTooLong
public void testSetAsciiStreamLengthlessOnLongVarCharTooLong()(Code)



testSetBinaryStream
public void testSetBinaryStream() throws Exception(Code)
Tests the PreparedStatement interface method setBinaryStream
throws:
  SQLException -



testSetBinaryStreamLengthLess1KOnBlob
public void testSetBinaryStreamLengthLess1KOnBlob() throws IOException, SQLException(Code)



testSetBinaryStreamLengthLess32KOnBlob
public void testSetBinaryStreamLengthLess32KOnBlob() throws IOException, SQLException(Code)



testSetBinaryStreamLengthLess65KOnBlob
public void testSetBinaryStreamLengthLess65KOnBlob() throws IOException, SQLException(Code)



testSetBinaryStreamLengthLessOnBlobTooLong
public void testSetBinaryStreamLengthLessOnBlobTooLong()(Code)



testSetBinaryStreamLengthless
public void testSetBinaryStreamLengthless() throws IOException, SQLException(Code)



testSetBlob
public void testSetBlob() throws IOException, SQLException(Code)
Test the setBlob() method
throws:
  SQLException - if a failure occurs during the call to setBlob



testSetBlobLengthless
public void testSetBlobLengthless() throws IOException, SQLException(Code)
Insert Blob without specifying length and read it back for verification. Beacuse we don't yet support Connection.createBlob in the client driver, we must first insert data into the database and read back a Blob object. This object is then inserted into the database again.



testSetCharacterStream
public void testSetCharacterStream() throws Exception(Code)
Tests the PreparedStatement interface method setCharacterStream
throws:
  SQLException -



testSetCharacterStreamLengthless
public void testSetCharacterStreamLengthless() throws IOException, SQLException(Code)



testSetClob
public void testSetClob() throws IOException, SQLException(Code)
Test the setClob() method
throws:
  SQLException - if a failure occurs during the call to setClob



testSetClobLengthless
public void testSetClobLengthless() throws IOException, SQLException(Code)
Insert Clob without specifying length and read it back for verification. Beacuse we don't yet support Connection.createClob in the client driver, we must first insert data into the database and read back a Clob object. This object is then inserted into the database again.



testSetNCharacterStream
public void testSetNCharacterStream() throws SQLException(Code)
Tests the setNCharacterStream method of the PreparedStatement interface
throws:
  SQLException - upon any failure that occurs in the call to the method.



testSetNCharacterStreamLengthlessNotImplemented
public void testSetNCharacterStreamLengthlessNotImplemented() throws SQLException(Code)



testSetNClob1
public void testSetNClob1() throws SQLException(Code)
Tests the setNClob method of the PreparedStatement interface
throws:
  SQLException - upon any failure that occurs in the call to the method.



testSetNClob2
public void testSetNClob2() throws SQLException(Code)
Tests the setNClob method of the PreparedStatement interface
throws:
  SQLException - upon any failure that occurs in the call to the method.



testSetNClobLengthlessNotImplemented
public void testSetNClobLengthlessNotImplemented() throws SQLException(Code)



testSetNString
public void testSetNString() throws SQLException(Code)
Tests the setNString method of the PreparedStatement interface
throws:
  SQLException - upon any failure that occurs in the call to the method.



testSetPoolable
public void testSetPoolable() throws SQLException(Code)
Tests the PreparedStatement interface method setPoolable
throws:
  SQLException -



testSetRowId
public void testSetRowId() throws SQLException(Code)
Tests the setRowId method of the PreparedStatement interface
throws:
  SQLException - upon any failure that occurs in the call to the method.



testSetSQLXML
public void testSetSQLXML() throws SQLException(Code)
Tests the setSQLXML method of the PreparedStatement interface
throws:
  SQLException - upon any failure that occurs in the call to the method.



testUnwrapCallableStatement
public void testUnwrapCallableStatement()(Code)



testUnwrapPreparedStatement
public void testUnwrapPreparedStatement() throws SQLException(Code)



testUnwrapResultSet
public void testUnwrapResultSet()(Code)



testUnwrapStatement
public void testUnwrapStatement() throws SQLException(Code)



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.