Java Doc for JDBC.java in » Database-DBMS » db-derby-10.2 » org » apache » derbyTesting » junit » 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

Illustrator Tutorials

GIMP Tutorials

C# / C Sharp

C# / CSharp Tutorial

C# / CSharp Open Source

SQL Server / T-SQL Tutorial

Oracle PL / SQL

Oracle PL/SQL 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.junit

Source Cross Reference

Class Diagram

Java Document (Java Doc)

java.lang .Object

org.apache.derbyTesting.junit .JDBC

JDBC
public class JDBC (Code)
	JDBC utility methods for the JUnit tests.

Method Summary
public static void	assertDrainResults(ResultSet rs) Drain a single ResultSet by reading all of its rows and columns.
public static void	assertMetaDataMatch(DatabaseMetaData dmd, ResultSetMetaData rsmd) Assert all columns in the ResultSetMetaData match the table's defintion through DatabaseMetadDta.
public static void	cleanup(Connection conn) Rollback and close a connection for cleanup.
public static void	dropSchema(DatabaseMetaData dmd, String schema) Drop a database schema by dropping all objects in it and then executing DROP SCHEMA.
public static String	escape(String name) Escape a non-qualified name so that it is suitable for use in a SQL query executed by JDBC.
public static String	escape(String schema, String name) Escape a schama-qualified name so that it is suitable for use in a SQL query executed by JDBC.
public static boolean	vmSupportsJDBC2() Return true if the virtual machine environment supports JDBC2 or later.
public static boolean	vmSupportsJDBC3() Return true if the virtual machine environment supports JDBC3 or later.
public static boolean	vmSupportsJDBC4() Return true if the virtual machine environment supports JDBC4 or later.
public static boolean	vmSupportsJSR169() Return true if the virtual machine environment supports JSR169 (JDBC 3 subset).

Method Detail

assertDrainResults
public static void assertDrainResults(ResultSet rs) throws SQLException(Code)
	Drain a single ResultSet by reading all of its rows and columns. Each column is accessed using getString() and asserted that the returned value matches the state of ResultSet.wasNull(). Provides simple testing of the ResultSet when the contents are not important. Parameters: rs - throws: SQLException -

assertMetaDataMatch
public static void assertMetaDataMatch(DatabaseMetaData dmd, ResultSetMetaData rsmd) throws SQLException(Code)
	Assert all columns in the ResultSetMetaData match the table's defintion through DatabaseMetadDta. Only works if the complete select list correspond to columns from base tables. Does not require that the complete set of any table's columns are returned. throws: SQLException -

cleanup
public static void cleanup(Connection conn) throws SQLException(Code)
	Rollback and close a connection for cleanup. Test code that is expecting Connection.close to succeed normally should just call conn.close(). If conn is not-null and isClosed() returns false then both rollback and close will be called. If both methods throw exceptions then they will be chained together and thrown. throws: SQLException - Error closing connection.

dropSchema
public static void dropSchema(DatabaseMetaData dmd, String schema) throws SQLException(Code)
	Drop a database schema by dropping all objects in it and then executing DROP SCHEMA. If the schema is APP it is cleaned but DROP SCHEMA is not executed. TODO: Handle dependencies by looping in some intelligent way until everything can be dropped. Parameters: dmd - DatabaseMetaData object for database Parameters: schema - Name of the schema throws: SQLException - database error

escape
public static String escape(String name)(Code)
	Escape a non-qualified name so that it is suitable for use in a SQL query executed by JDBC.

escape
public static String escape(String schema, String name)(Code)
	Escape a schama-qualified name so that it is suitable for use in a SQL query executed by JDBC.

vmSupportsJDBC2
public static boolean vmSupportsJDBC2()(Code)
	Return true if the virtual machine environment supports JDBC2 or later.

vmSupportsJDBC3
public static boolean vmSupportsJDBC3()(Code)
	Return true if the virtual machine environment supports JDBC3 or later.

vmSupportsJDBC4
public static boolean vmSupportsJDBC4()(Code)
	Return true if the virtual machine environment supports JDBC4 or later.

vmSupportsJSR169
public static boolean vmSupportsJSR169()(Code)
	Return true if the virtual machine environment supports JSR169 (JDBC 3 subset).

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

All other trademarks are property of their respective owners.