Java Doc for Oracle9iDialect.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
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorials
Maya Tutorials
Flash Tutorials
3ds-Max Tutorials
Illustrator Tutorials
GIMP Tutorials
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Tutorial
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net 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.Oracle9iDialect

Oracle9iDialect
public class Oracle9iDialect extends Oracle9Dialect implements HibernateDialect(Code)
A description of this class goes here...



Constructor Summary
public  Oracle9iDialect()
    

Method Summary
public  booleancanPasteTo(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  StringgetColumnCommentAlterSQL(TableColumnInfo info)
     Returns the SQL statement to use to add a comment to the specified column of the specified table.
public  StringgetColumnDefaultAlterSQL(TableColumnInfo info)
     Returns the SQL command to change the specified column's default value alter table test modify mychar default 'foo' alter table test modify nullint default 0
Parameters:
  info - the column to modify and it's default value.
public  StringgetColumnDropSQL(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  intgetColumnLength(int columnSize, int dataType)
    
public  StringgetColumnNameAlterSQL(TableColumnInfo from, TableColumnInfo to)
     Returns the SQL that is used to change the column name.
public  StringgetColumnNullableAlterSQL(TableColumnInfo info)
     Returns the SQL used to alter the specified column to allow/disallow null values, based on the value of isNullable.
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  StringgetDisplayName()
     The string which identifies this dialect in the dialect chooser.
public  StringgetDropForeignKeySQL(String fkName, String tableName)
     Returns the SQL command to drop the specified table's foreign key constraint.
public  StringgetDropPrimaryKeySQL(String pkName, String tableName)
     Returns the SQL command to drop the specified table's primary key.
public  StringgetLengthFunction(int dataType)
    
public  StringgetMaxFunction()
    
public  intgetMaxPrecision(int dataType)
    
public  intgetMaxScale(int dataType)
    
public  intgetPrecisionDigits(int columnSize, int dataType)
    
public  List<String>getTableDropSQL(ITableInfo ti, boolean cascadeConstraints, boolean isMaterializedView)
     Returns the SQL that forms the command to drop the specified table.
public  booleansupportsAlterColumnDefault()
     Returns a boolean value indicating whether or not this database dialect supports changing a column's default value.
public  booleansupportsAlterColumnNull()
     Returns a boolean value indicating whether or not this database dialect supports changing a column from null to not-null and vice versa.
public  booleansupportsAlterColumnType()
     Returns a boolean value indicating whether or not this dialect supports modifying a columns type.
public  booleansupportsColumnComment()
     Returns a boolean value indicating whether or not this dialect supports adding comments to columns.
public  booleansupportsDropColumn()
     Returns a boolean value indicating whether or not this database dialect supports dropping columns from tables.
public  booleansupportsProduct(String databaseProductName, String databaseProductVersion)
     Returns boolean value indicating whether or not this dialect supports the specified database product/version.
public  booleansupportsRenameColumn()
     Returns a boolean value indicating whether or not this database dialect supports renaming columns.
public  booleansupportsSchemasInTableDefinition()
    


Constructor Detail
Oracle9iDialect
public Oracle9iDialect()(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.
Parameters:
  columns - 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(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.
Parameters:
  tableName - the name of the table to create the SQL for.
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 alter table test modify mychar default 'foo' alter table test modify nullint default 0
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.
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 allow/disallow null values, based on the value of isNullable. alter table test modify mycol 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 test modify (mycol varchar(100))
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 ti, 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:
  cascadeConstraints - whether or not to drop any FKs that may reference the specified table.
Parameters:
  ti - the table to drop 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
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.