Java Doc for JdbcUtils.java in » Database-Client » LiquiBase » liquibase » util » 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 Client » LiquiBase » liquibase.util

Source Cross Reference Class Diagram Java Document (Java Doc)

java.lang .Object

liquibase.util .JdbcUtils

JdbcUtils
abstract public class JdbcUtils (Code)

Field Summary
final public static int	TYPE_UNKNOWN Constant that indicates an unknown (or unspecified) SQL type.

Method Summary
public static void	closeResultSet(ResultSet rs) Close the given JDBC ResultSet and ignore any thrown exception.
public static void	closeStatement(Statement stmt) Close the given JDBC Statement and ignore any thrown exception.
public static Object	getResultSetValue(ResultSet rs, int index) Retrieve a JDBC column value from a ResultSet, using the most appropriate value type.
public static boolean	isNumeric(int sqlType) Check whether the given SQL type is numeric.
public static Object	requiredSingleResult(Collection results) Return a single result object from the given Collection.

Field Detail

TYPE_UNKNOWN
final public static int TYPE_UNKNOWN(Code)
	Constant that indicates an unknown (or unspecified) SQL type. See Also: java.sql.Types

Method Detail

closeResultSet
public static void closeResultSet(ResultSet rs)(Code)
	Close the given JDBC ResultSet and ignore any thrown exception. This is useful for typical finally blocks in manual JDBC code. Parameters: rs - the JDBC ResultSet to close (may be `null`)

closeStatement
public static void closeStatement(Statement stmt)(Code)
	Close the given JDBC Statement and ignore any thrown exception. This is useful for typical finally blocks in manual JDBC code. Parameters: stmt - the JDBC Statement to close (may be `null`)

getResultSetValue
public static Object getResultSetValue(ResultSet rs, int index) throws SQLException(Code)
	Retrieve a JDBC column value from a ResultSet, using the most appropriate value type. The returned value should be a detached value object, not having any ties to the active ResultSet: in particular, it should not be a Blob or Clob object but rather a byte array respectively String representation. Uses the `getObject(index)` method, but includes additional "hacks" to get around Oracle 10g returning a non-standard object for its TIMESTAMP datatype and a `java.sql.Date` for DATE columns leaving out the time portion: These columns will explicitly be extracted as standard `java.sql.Timestamp` object. Parameters: rs - is the ResultSet holding the data Parameters: index - is the column index the value object throws: SQLException - if thrown by the JDBC API See Also: java.sql.Blob See Also: java.sql.Clob See Also: java.sql.Timestamp

isNumeric
public static boolean isNumeric(int sqlType)(Code)
	Check whether the given SQL type is numeric. Parameters: sqlType - the SQL type to be checked whether the type is numeric

requiredSingleResult
public static Object requiredSingleResult(Collection results) throws JDBCException(Code)
	Return a single result object from the given Collection. Throws an exception if 0 or more than 1 element found. Parameters: results - the result Collection (can be `null`) the single result object

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.