Java Doc for Dialect.java in » Database-JDBC-Connection-Pool » HA-JDBC » net » sf » hajdbc » 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 JDBC Connection Pool » HA JDBC » net.sf.hajdbc

Source Cross Reference

Class Diagram

Java Document (Java Doc)

net.sf.hajdbc .Dialect

All known Subclasses:   net.sf.hajdbc.dialect .StandardDialect,  net.sf.hajdbc.dialect .TestStandardDialect,
Dialect
public interface Dialect (Code)
Encapsulates database vendor specific SQL syntax.
author:
   Paul Ferraro
since:
   1.1

Method Summary
public String evaluateCurrentDate(String sql, java.sql.Date date)
     Replaces non-deterministic CURRENT_DATE functions with deterministic static values.
public String evaluateCurrentTime(String sql, java.sql.Time time)
     Replaces non-deterministic CURRENT_TIME functions with deterministic static values.
public String evaluateCurrentTimestamp(String sql, java.sql.Timestamp timestamp)
     Replaces non-deterministic CURRENT_TIMESTAMP functions with deterministic static values.
public String evaluateRand(String sql)
     Replaces non-deterministic RAND() functions with deterministic static values.
public String getAlterIdentityColumnSQL(TableProperties table, ColumnProperties column, long value)
     Returns a SQL statement used reset the current value of an identity column.
public String getAlterSequenceSQL(SequenceProperties sequence, long value)
     Returns a SQL statement used reset the current value of a sequence.
public int getColumnType(ColumnProperties properties)
     Returns the data type of the specified column of the specified schema and table.
public String getCreateForeignKeyConstraintSQL(ForeignKeyConstraint constraint)
     Returns a SQL statement used to create a foreign key constraint.
public String getCreateUniqueConstraintSQL(UniqueConstraint constraint)
     Returns a SQL statement used to create a unique constraint.
public List<String> getDefaultSchemas(DatabaseMetaData metaData)

public String getDropForeignKeyConstraintSQL(ForeignKeyConstraint constraint)
     Returns a SQL statement used to drop a foreign key constraint.
public String getDropUniqueConstraintSQL(UniqueConstraint constraint)
     Returns a SQL statement used to drop a unique constraint.
public Pattern getIdentifierPattern(DatabaseMetaData metaData)

public String getNextSequenceValueSQL(SequenceProperties sequence)

public Collection<QualifiedName> getSequences(DatabaseMetaData metaData)
     Returns a collection of all sequences in this database.
public String getSimpleSQL()
     Returns a simple SQL statement used to validate whether a database is alive or not.
public String getTruncateTableSQL(TableProperties properties)
     Returns a SQL statement used to truncate a table.
public boolean isIdentity(ColumnProperties properties)
     Indicates whether or not the specified column is an identity column.
public boolean isSelectForUpdate(String sql)
     Determines whether the specified SQL is a SELECT ...
public String parseInsertTable(String sql)
     Parses a table name from the specified INSERT SQL statement that may contain identity columns.
public String parseSequence(String sql)
     Parses a sequence name from the specified SQL statement.

Method Detail
evaluateCurrentDate
public String evaluateCurrentDate(String sql, java.sql.Date date) throws SQLException(Code)
Replaces non-deterministic CURRENT_DATE functions with deterministic static values.
Parameters:
  sql - an SQL statement
Parameters:
  date - the replacement date an equivalent deterministic SQL statement
throws:
  SQLException -
since:
   2.0.2

evaluateCurrentTime
public String evaluateCurrentTime(String sql, java.sql.Time time) throws SQLException(Code)
Replaces non-deterministic CURRENT_TIME functions with deterministic static values.
Parameters:
  sql - an SQL statement
Parameters:
  time - the replacement time an equivalent deterministic SQL statement
throws:
  SQLException -
since:
   2.0.2

evaluateCurrentTimestamp
public String evaluateCurrentTimestamp(String sql, java.sql.Timestamp timestamp) throws SQLException(Code)
Replaces non-deterministic CURRENT_TIMESTAMP functions with deterministic static values.
Parameters:
  sql - an SQL statement
Parameters:
  timestamp - the replacement timestamp an equivalent deterministic SQL statement
throws:
  SQLException -
since:
   2.0.2

evaluateRand
public String evaluateRand(String sql) throws SQLException(Code)
Replaces non-deterministic RAND() functions with deterministic static values.
Parameters:
  sql - an SQL statement an equivalent deterministic SQL statement
throws:
  SQLException -
since:
   2.0.2

getAlterIdentityColumnSQL
public String getAlterIdentityColumnSQL(TableProperties table, ColumnProperties column, long value) throws SQLException(Code)
Returns a SQL statement used reset the current value of an identity column.
Parameters:
  table - a sequence name
Parameters:
  column - a sequence name
Parameters:
  value - a sequence value a SQL statement
throws:
  SQLException -
since:
   2.0.2

getAlterSequenceSQL
public String getAlterSequenceSQL(SequenceProperties sequence, long value) throws SQLException(Code)
Returns a SQL statement used reset the current value of a sequence.
Parameters:
  sequence - a sequence name
Parameters:
  value - a sequence value a SQL statement
throws:
  SQLException -
since:
   2.0

getColumnType
public int getColumnType(ColumnProperties properties) throws SQLException(Code)
Returns the data type of the specified column of the specified schema and table. This method is intended to correct JDBC driver type mapping flaws.
Parameters:
  properties - table column meta data the JDBC data type of this column
throws:
  SQLException -

getCreateForeignKeyConstraintSQL
public String getCreateForeignKeyConstraintSQL(ForeignKeyConstraint constraint) throws SQLException(Code)
Returns a SQL statement used to create a foreign key constraint.
Parameters:
  constraint - foreign key constraint meta data a SQL statement
throws:
  SQLException - if there was an error fetching meta data.

getCreateUniqueConstraintSQL
public String getCreateUniqueConstraintSQL(UniqueConstraint constraint) throws SQLException(Code)
Returns a SQL statement used to create a unique constraint.
Parameters:
  constraint - unique constraint meta data a SQL statement
throws:
  SQLException - if there was an error fetching meta data.

getDefaultSchemas
public List<String> getDefaultSchemas(DatabaseMetaData metaData) throws SQLException(Code)
Returns a search path of schemas
Parameters:
  metaData - a list of schema names
throws:
  SQLException -
since:
   2.0

getDropForeignKeyConstraintSQL
public String getDropForeignKeyConstraintSQL(ForeignKeyConstraint constraint) throws SQLException(Code)
Returns a SQL statement used to drop a foreign key constraint.
Parameters:
  constraint - foreign key constraint meta data a SQL statement
throws:
  SQLException - if there was an error fetching meta data.

getDropUniqueConstraintSQL
public String getDropUniqueConstraintSQL(UniqueConstraint constraint) throws SQLException(Code)
Returns a SQL statement used to drop a unique constraint.
Parameters:
  constraint - unique constraint meta data a SQL statement
throws:
  SQLException - if there was an error fetching meta data.

getIdentifierPattern
public Pattern getIdentifierPattern(DatabaseMetaData metaData) throws SQLException(Code)
Returns a pattern for identifiers that do not require quoting
Parameters:
  metaData - a regular expression pattern
throws:
  SQLException -
since:
   2.0.2

getNextSequenceValueSQL
public String getNextSequenceValueSQL(SequenceProperties sequence) throws SQLException(Code)
Returns a SQL statement for obtaining the next value the specified sequence
Parameters:
  sequence - a sequence name a SQL statement
throws:
  SQLException -
since:
   2.0

getSequences
public Collection<QualifiedName> getSequences(DatabaseMetaData metaData) throws SQLException(Code)
Returns a collection of all sequences in this database.
Parameters:
  metaData - database meta data a collection of sequence names
throws:
  SQLException -
since:
   2.0

getSimpleSQL
public String getSimpleSQL() throws SQLException(Code)
Returns a simple SQL statement used to validate whether a database is alive or not. a SQL statement
throws:
  SQLException -

getTruncateTableSQL
public String getTruncateTableSQL(TableProperties properties) throws SQLException(Code)
Returns a SQL statement used to truncate a table.
Parameters:
  properties - table meta data a SQL statement
throws:
  SQLException - if there was an error fetching meta data.

isIdentity
public boolean isIdentity(ColumnProperties properties) throws SQLException(Code)
Indicates whether or not the specified column is an identity column.
Parameters:
  properties - a table column true, if this column is an identity column, false otherwise
throws:
  SQLException -
since:
   2.0

isSelectForUpdate
public boolean isSelectForUpdate(String sql) throws SQLException(Code)
Determines whether the specified SQL is a SELECT ... FOR UPDATE statement
Parameters:
  sql - a SQL statement true if this is a SELECT ... FOR UPDATE statement, false if it is not
throws:
  SQLException - if there was an error fetching meta data.

parseInsertTable
public String parseInsertTable(String sql) throws SQLException(Code)
Parses a table name from the specified INSERT SQL statement that may contain identity columns.
Parameters:
  sql - a SQL statement the name of a table, or null if this SQL statement is not an INSERT statement or this dialect does not support identity columns
throws:
  SQLException -
since:
   2.0

parseSequence
public String parseSequence(String sql) throws SQLException(Code)
Parses a sequence name from the specified SQL statement.
Parameters:
  sql - a SQL statement the name of a sequence, or null if this SQL statement does not reference a sequence or this dialect does not support sequences
throws:
  SQLException -
since:
   2.0

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.