Package org.sourceforge.jxdbcon

The jxDBCon package collects the generics that are common to all JDBC driver implementations.

See:
Description

Interface Summary

InfoKeys

InfoKeys defines the common keys used in the connection properties.

Class Summary

AbstractCallableStatement	AbstractCallableStatement implements generics of CallableStatement.
AbstractClob	AbstractClob implements generics of the Clob interface.
AbstractClob$1
AbstractClob$2
AbstractClob$3
AbstractClob$4
AbstractConnection	The main class for all database connection implementations.
AbstractDatabaseMetaData	AbstractDatabaseMetaData implements generics of the DatabaseMetaData interface.
AbstractPreparedStatement	AbstractPreparedStatement implements generics of the PreparedStatement interface.
AbstractResultSet	AbstractResultSet implements generics of the ResultSet interface.
AbstractResultSetRO	AbstractResultSetRO extends AbstractResultSet for read-only sets.
AbstractResultSetRW	AbstractResultSetRW extends AbstractResultSet for read-write sets.
AbstractRowsResultSet	AbstractRowsResultSet defines a ResultSet over data accessed via a ListIterator.
AbstractSQLInput	AbstractSQLInput implements generics of the SQLInput interface.
AbstractSQLOutput	AbstractSQLOutput implements generics of the SQLOutput interface.
AbstractStatement	AbstractStatement implements Statement definining some useful functions.
ArrayResultSet	ArrayResultSet is a concrete immutable ResultSet where the data is stored in a Java array.
ArrayResultSet$1
DefaultArray	DefaulttArray is a default implementation of Array.
DefaultExceptions	.
DefaultResultSetMetaData	DefaultResultSetMetaData is a default implementation of AbstractResultSetMetaData.
DefaultSQLInput	DefaultSQLInput is a default implementation of AbstractSQLInput.
DefaultSQLOutput	DefaultSQLOutput is a default implementation of AbstractSQLOutput.
DefaultStruct	DefaultStruct is a default implementation of Struct
Diag	Diagnostics class.
EscapeContext	This Context is used when simplifying Escape fragments in a command.
EscapeFrags	This class groups together the fragments which can be identified in a SQL command.
EscapeFrags.Call
EscapeFrags.Constant
EscapeFrags.Enumeration
EscapeFrags.Escape
EscapeFrags.Frag
EscapeFrags.FragList
EscapeFrags.Function
EscapeFrags.Keyword
EscapeFrags.Param
EscapeFrags.ParamList
EscapeFrags.PosParam
EscapeFrags.Result
EscapeFrags.Token
EscapeFrags.Value
EscapeFuncs	This class groups the default implementations of the JDBC scalar functions.
EscapeFuncs.abs	ABS(number) Absolute value of number.
EscapeFuncs.acos	ACOS(float) Arccosine, in radians, of float.
EscapeFuncs.ascii	ASCII(string) Integer representing the ASCII code value of the leftmost character in string.
EscapeFuncs.asin	ASIN(float) Arcsine, in radians, of float.
EscapeFuncs.atan	ATAN(float) Arctangent, in radians, of float.
EscapeFuncs.atan2	ATAN2(float1, float2) Arctangent, in radians, of float2 / float1.
EscapeFuncs.cast	CAST(any, typename) Cast a value to a given type.
EscapeFuncs.ceiling	CEILING(number) Smallest integer >= number.
EscapeFuncs.charcode	CHAR(code) Character with ASCII code value code, where code is between 0 and 255
EscapeFuncs.concat	CONCAT(string1, string2) Character string formed by appending string2 to string1; if a string is null, the result is DBMS-dependent.
EscapeFuncs.convert	CONVERT(value, SQLtype) value converted to SQLtype.
EscapeFuncs.cos	COS(float) Cosine of float radians.
EscapeFuncs.cot	COT(float) Cotangent of float radians.
EscapeFuncs.curdate	CURDATE() The current date as a date value.
EscapeFuncs.curtime	CURTIME() The current local time as a time value.
EscapeFuncs.database	DATABASE() Name of the database.
EscapeFuncs.dayname	DAYNAME(date) A character string representing the day component of date; the name for the day is specific to the data source.
EscapeFuncs.dayofmonth	DAYOFMONTH(date) An integer from 1 to 31 representing the day of the month in date.
EscapeFuncs.dayofweek	DAYOFWEEK(date) An integer from 1 to 7 representing the day of the week in date; 1 represents Sunday.
EscapeFuncs.dayofyear	DAYOFYEAR(date) An integer from 1 to 366 representing the day of the year in date.
EscapeFuncs.degrees	DEGREES(number) Degrees in number radians.
EscapeFuncs.difference	DIFFERENCE(string1, string2) Integer indicating the difference between the values returned by the function SOUNDEX for string1 and string2.
EscapeFuncs.exp	EXP(float) Exponential function of float.
EscapeFuncs.floor	FLOOR(number) Largest integer <= number.
EscapeFuncs.hour	HOUR(time) An integer from 0 to 23 representing the hour component of time.
EscapeFuncs.ifnull	IFNULL(expression, value) value if expression is null; expression if expression is not null.
EscapeFuncs.insert	INSERT(string1, start, length, string2) A character string formed by deleting length characters from string1 beginning at start, and inserting string2 into string1 at start.
EscapeFuncs.lcase	LCASE(string) Converts all uppercase characters in string to lowercase.
EscapeFuncs.left	LEFT(string, count) The count leftmost characters from string.
EscapeFuncs.length	LENGTH(string) Number of characters in string, excluding trailing blanks.
EscapeFuncs.locate	LOCATE(string1, string2[, start]) Position in string2 of the first occurrence of string1, searching from the beginning of string2; if start is specified, the search begins from position start.
EscapeFuncs.log	LOG(float) Base e logarithm of float.
EscapeFuncs.log10	LOG10(float) Base 10 logarithm of float.
EscapeFuncs.ltrim	LTRIM(string) Characters of string with leading blank spaces removed.
EscapeFuncs.minute	MINUTE(time) An integer from 0 to 59 representing the minute component of time.
EscapeFuncs.mod	MOD(integer1, integer2) Remainder for integer1 / integer2.
EscapeFuncs.month	MONTH(date) An integer from 1 to 12 representing the month component of date.
EscapeFuncs.monthname	MONTHNAME(date) A character string representing the month component of date; the name for the month is specific to the data source.
EscapeFuncs.NoFunction
EscapeFuncs.now	NOW() A timestamp value representing the current date and time.
EscapeFuncs.OneParamFunction
EscapeFuncs.pi	PI() The constant pi.
EscapeFuncs.power	POWER(number, power) number raised to (integer) power.
EscapeFuncs.quarter	QUARTER(date) An integer from 1 to 4 representing the quarter in date; 1 represents January 1 through March 31.
EscapeFuncs.radians	RADIANS(number) Radians in number degrees.
EscapeFuncs.rand	RAND(integer) Random floating point for seed integer.
EscapeFuncs.repeat	REPEAT(string, count) A character string formed by repeating string count times.
EscapeFuncs.replace	REPLACE(string1, string2, string3) Replaces all occurrences of string2 in string1 with string3
EscapeFuncs.right	RIGHT(string, count) The count rightmost characters in string.
EscapeFuncs.round	ROUND(number, places) number rounded to places places.
EscapeFuncs.rtrim	RTRIM(string) The characters of string with no trailing blanks.
EscapeFuncs.second	SECOND(time) An integer from 0 to 59 representing the second component of time.
EscapeFuncs.sign	SIGN(number) -1 to indicate number is < 0; 0 to indicate number is = 0; 1 to indicate number is > 0.
EscapeFuncs.sin	SIN(float) Sine of float radians.
EscapeFuncs.soundex	SOUNDEX(string) A character string, which is data source-dependent, representing the sound of the words in string; this could be a four-digit SOUNDEX code, a phonetic representation of each word, etc.
EscapeFuncs.space	SPACE(count) A character string consisting of count spaces
EscapeFuncs.sqrt	SQRT(float) Square root of float.
EscapeFuncs.substring	SUBSTRING(string, start, length) A character string formed by extracting length characters from string beginning at start.
EscapeFuncs.tan	TAN(float) Tangent of float radians.
EscapeFuncs.timestampadd	TIMESTAMPADD(interval, count, timestamp) A timestamp calculated by adding count number of interval(s) to timestamp.
EscapeFuncs.timestampdiff	TIMESTAMPDIFF(interval, timestamp1, timestamp2) An integer representing the number of interval by which timestamp2 is greater than timestamp1.
EscapeFuncs.truncate	TRUNCATE(number, places) number truncated to places places.
EscapeFuncs.ucase	UCASE(string) Converts all lowercase characters in string to uppercase.
EscapeFuncs.user	USER() User name in the DBMS.
EscapeFuncs.week	WEEK(date) An integer from 1 to 53 representing the week of the year in date.
EscapeFuncs.year	YEAR(date) An integer representing the year component of date.
EscapeFuncs$1
JXDBConDriver	JXDBConDriver is the interface to the DriverManager, it dispatches the openConnection requests to the appropriate sub driver.
SimpleEscapeParser	This class attempts to tokenize a statement and break it into fragments.
SQLParser	This class attempts to tokenze SQL statements.
SQLParser$1
XAbstractDataSource	XAbstractDataSource implements generics of the DataSource interface.
XAbstractDataSource.ObjectFactory
XAbstractDataSource.StateFactory

Package org.sourceforge.jxdbcon Description

The jxDBCon package collects the generics that are common to all JDBC driver implementations. The definition of the Abstract* and Default* classes ease writing a driver for a specific database manager. The main entry point to the driver is the AbstractConnection class.