Java Doc for HSQLDialect.java in » Database-Client » squirrel-sql-2.6.5a » net » sourceforge » squirrel_sql » fw » dialects » 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 » squirrel sql 2.6.5a » net.sourceforge.squirrel_sql.fw.dialects

Source Cross Reference

Class Diagram

Java Document (Java Doc)

net.sourceforge.squirrel_sql.fw.dialects .HSQLDialect

HSQLDialect
public class HSQLDialect extends org.hibernate.dialect.HSQLDialect implements HibernateDialect(Code)
	An extension to the standard Hibernate MySQL dialect

Constructor Summary
public	HSQLDialect()

Method Summary
public boolean	canPasteTo(IDatabaseObjectInfo info)
public String[]	getAddPrimaryKeySQL(String pkName, TableColumnInfo[] columns, ITableInfo ti) Returns the SQL that forms the command to add a primary key to the specified table composed of the given column names.
public String[]	getColumnAddSQL(TableColumnInfo info) Returns the SQL statement to use to add a column to the specified table using the information about the new column specified by info.
public String	getColumnCommentAlterSQL(String tableName, String columnName, String comment) Returns the SQL statement to use to add a comment to the specified column of the specified table.
public String	getColumnCommentAlterSQL(TableColumnInfo info) Returns the SQL statement to use to add a comment to the specified column of the specified table.
public String	getColumnDefaultAlterSQL(TableColumnInfo info) Returns the SQL command to change the specified column's default value Parameters: info - the column to modify and it's default value.
public String	getColumnDropSQL(String tableName, String columnName) Returns the SQL that forms the command to drop the specified colum in the specified table. Parameters: tableName - the name of the table that has the column Parameters: columnName - the name of the column to drop. throws: UnsupportedOperationException - if the database doesn't support dropping columns.
public int	getColumnLength(int columnSize, int dataType)
public String	getColumnNameAlterSQL(TableColumnInfo from, TableColumnInfo to) Returns the SQL that is used to change the column name.
public String	getColumnNullableAlterSQL(TableColumnInfo info)
public List<String>	getColumnTypeAlterSQL(TableColumnInfo from, TableColumnInfo to) Returns the SQL that is used to change the column type.
public List<String>	getCreateTableSQL(List<ITableInfo> tables, ISQLDatabaseMetaData md, CreateScriptPreferences prefs, boolean isJdbcOdbc) Returns the SQL command to create the specified table. Parameters: tables - the tables to get create statements for Parameters: md - the metadata from the ISession Parameters: prefs - preferences about how the resultant SQL commands should be formed. Parameters: isJdbcOdbc - whether or not the connection is via JDBC-ODBC bridge.
public String	getDisplayName() The string which identifies this dialect in the dialect chooser.
public String	getDropForeignKeySQL(String fkName, String tableName) Returns the SQL command to drop the specified table's foreign key constraint.
public String	getDropPrimaryKeySQL(String pkName, String tableName) Returns the SQL command to drop the specified table's primary key.
public String	getLengthFunction(int dataType)
public String	getMaxFunction()
public int	getMaxPrecision(int dataType)
public int	getMaxScale(int dataType)
public int	getPrecisionDigits(int columnSize, int dataType)
public List<String>	getTableDropSQL(ITableInfo iTableInfo, boolean cascadeConstraints, boolean isMaterializedView) Returns the SQL that forms the command to drop the specified table.
public boolean	supportsAlterColumnDefault() Returns a boolean value indicating whether or not this database dialect supports changing a column's default value.
public boolean	supportsAlterColumnNull() Returns a boolean value indicating whether or not this database dialect supports changing a column from null to not-null and vice versa.
public boolean	supportsAlterColumnType() Returns a boolean value indicating whether or not this dialect supports modifying a columns type.
public boolean	supportsColumnComment() Returns a boolean value indicating whether or not this dialect supports adding comments to columns.
public boolean	supportsDropColumn() Returns a boolean value indicating whether or not this database dialect supports dropping columns from tables.
public boolean	supportsProduct(String databaseProductName, String databaseProductVersion) Returns boolean value indicating whether or not this dialect supports the specified database product/version.
public boolean	supportsRenameColumn() Returns a boolean value indicating whether or not this database dialect supports renaming columns.
public boolean	supportsSchemasInTableDefinition()

Constructor Detail

HSQLDialect
public HSQLDialect()(Code)

Method Detail

canPasteTo
public boolean canPasteTo(IDatabaseObjectInfo info)(Code)

getAddPrimaryKeySQL
public String[] getAddPrimaryKeySQL(String pkName, TableColumnInfo[] columns, ITableInfo ti)(Code)
	Returns the SQL that forms the command to add a primary key to the specified table composed of the given column names. ALTER TABLE ADD [CONSTRAINT ] PRIMARY KEY (); Parameters: pkName - the name of the constraint Parameters: columnNames - the columns that form the key

getColumnAddSQL
public String[] getColumnAddSQL(TableColumnInfo info) throws UnsupportedOperationException(Code)
	Returns the SQL statement to use to add a column to the specified table using the information about the new column specified by info. Parameters: info - information about the new column such as type, name, etc. throws: UnsupportedOperationException - if the database doesn't support adding columns after a table has already been created.

getColumnCommentAlterSQL
public String getColumnCommentAlterSQL(String tableName, String columnName, String comment) throws UnsupportedOperationException(Code)
	Returns the SQL statement to use to add a comment to the specified column of the specified table. Parameters: tableName - the name of the table to create the SQL for. Parameters: columnName - the name of the column to create the SQL for. Parameters: comment - the comment to add. throws: UnsupportedOperationException - if the database doesn't support annotating columns with a comment.

getColumnCommentAlterSQL
public String getColumnCommentAlterSQL(TableColumnInfo info) throws UnsupportedOperationException(Code)
	Returns the SQL statement to use to add a comment to the specified column of the specified table. Parameters: info - information about the column such as type, name, etc. throws: UnsupportedOperationException - if the database doesn't support annotating columns with a comment.

getColumnDefaultAlterSQL
public String getColumnDefaultAlterSQL(TableColumnInfo info)(Code)
	Returns the SQL command to change the specified column's default value Parameters: info - the column to modify and it's default value. SQL to make the change

getColumnDropSQL
public String getColumnDropSQL(String tableName, String columnName)(Code)
	Returns the SQL that forms the command to drop the specified colum in the specified table. Parameters: tableName - the name of the table that has the column Parameters: columnName - the name of the column to drop. throws: UnsupportedOperationException - if the database doesn't support dropping columns.

getColumnLength
public int getColumnLength(int columnSize, int dataType)(Code)

getColumnNameAlterSQL
public String getColumnNameAlterSQL(TableColumnInfo from, TableColumnInfo to)(Code)
	Returns the SQL that is used to change the column name. ALTER TABLE ALTER COLUMN RENAME TO Parameters: from - the TableColumnInfo as it is Parameters: to - the TableColumnInfo as it wants to be the SQL to make the change

getColumnNullableAlterSQL
public String getColumnNullableAlterSQL(TableColumnInfo info)(Code)
	Returns the SQL used to alter the specified column to not allow null values ALTER TABLE ALTER COLUMN SET [NOT] NULL Parameters: info - the column to modify the SQL to execute

getColumnTypeAlterSQL
public List<String> getColumnTypeAlterSQL(TableColumnInfo from, TableColumnInfo to) throws UnsupportedOperationException(Code)
	Returns the SQL that is used to change the column type. ALTER TABLE table_name ALTER COLUMN column_name data_type; Parameters: from - the TableColumnInfo as it is Parameters: to - the TableColumnInfo as it wants to be the SQL to make the change

getCreateTableSQL
public List<String> getCreateTableSQL(List<ITableInfo> tables, ISQLDatabaseMetaData md, CreateScriptPreferences prefs, boolean isJdbcOdbc) throws SQLException(Code)
	Returns the SQL command to create the specified table. Parameters: tables - the tables to get create statements for Parameters: md - the metadata from the ISession Parameters: prefs - preferences about how the resultant SQL commands should be formed. Parameters: isJdbcOdbc - whether or not the connection is via JDBC-ODBC bridge. the SQL that is used to create the specified table

getDisplayName
public String getDisplayName()(Code)
	The string which identifies this dialect in the dialect chooser. a descriptive name that tells the user what database this dialectis design to work with.

getDropForeignKeySQL
public String getDropForeignKeySQL(String fkName, String tableName)(Code)
	Returns the SQL command to drop the specified table's foreign key constraint. Parameters: fkName - the name of the foreign key that should be dropped Parameters: tableName - the name of the table whose foreign key should be dropped

getDropPrimaryKeySQL
public String getDropPrimaryKeySQL(String pkName, String tableName)(Code)
	Returns the SQL command to drop the specified table's primary key. Parameters: pkName - the name of the primary key that should be dropped Parameters: tableName - the name of the table whose primary key should be dropped

getLengthFunction
public String getLengthFunction(int dataType)(Code)

getMaxFunction
public String getMaxFunction()(Code)

getMaxPrecision
public int getMaxPrecision(int dataType)(Code)

getMaxScale
public int getMaxScale(int dataType)(Code)

getPrecisionDigits
public int getPrecisionDigits(int columnSize, int dataType)(Code)

getTableDropSQL
public List<String> getTableDropSQL(ITableInfo iTableInfo, boolean cascadeConstraints, boolean isMaterializedView)(Code)
	Returns the SQL that forms the command to drop the specified table. If cascade contraints is supported by the dialect and cascadeConstraints is true, then a drop statement with cascade constraints clause will be formed. Parameters: iTableInfo - the table to drop Parameters: cascadeConstraints - whether or not to drop any FKs that may reference the specified table. the drop SQL command.

supportsAlterColumnDefault
public boolean supportsAlterColumnDefault()(Code)
	Returns a boolean value indicating whether or not this database dialect supports changing a column's default value. true if the database supports modifying column defaults; false otherwise

supportsAlterColumnNull
public boolean supportsAlterColumnNull()(Code)
	Returns a boolean value indicating whether or not this database dialect supports changing a column from null to not-null and vice versa. true if the database supports dropping columns; false otherwise.

supportsAlterColumnType
public boolean supportsAlterColumnType()(Code)
	Returns a boolean value indicating whether or not this dialect supports modifying a columns type. true if supported; false otherwise

supportsColumnComment
public boolean supportsColumnComment()(Code)
	Returns a boolean value indicating whether or not this dialect supports adding comments to columns. true if column comments are supported; false otherwise.

supportsDropColumn
public boolean supportsDropColumn()(Code)
	Returns a boolean value indicating whether or not this database dialect supports dropping columns from tables. true if the database supports dropping columns; false otherwise.

supportsProduct
public boolean supportsProduct(String databaseProductName, String databaseProductVersion)(Code)
	Returns boolean value indicating whether or not this dialect supports the specified database product/version. Parameters: databaseProductName - the name of the database as reported by DatabaseMetaData.getDatabaseProductName() Parameters: databaseProductVersion - the version of the database as reported byDatabaseMetaData.getDatabaseProductVersion() true if this dialect can be used for the specified product nameand version; false otherwise.

supportsRenameColumn
public boolean supportsRenameColumn()(Code)
	Returns a boolean value indicating whether or not this database dialect supports renaming columns. true if the database supports changing the name of columns; false otherwise.

supportsSchemasInTableDefinition
public boolean supportsSchemasInTableDefinition()(Code)

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.