Java Doc for DataStoreInterfaceFirebird.java in  » Content-Management-System » harmonise » org » openharmonise » commons » dsi » impl » 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 » Content Management System » harmonise » org.openharmonise.commons.dsi.impl   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.openharmonise.commons.dsi.AbstractDataStoreInterface       org.openharmonise.commons.dsi.impl.DataStoreInterfaceFirebird DataStoreInterfaceFirebird public class DataStoreInterfaceFirebird extends AbstractDataStoreInterface (Code) Class providing interface to a Firebird database. author:    Fidel Viegas See Also:   java.sql Constructor Summary public   DataStoreInterfaceFirebird()      Constructs a firebird data store interface with no DB settings. public   DataStoreInterfaceFirebird(String sJDBCDriver, String sDBurl, String sDBUsr, String sDBPwd)      Constructs a firebird data store interface with the given DB settings. public   DataStoreInterfaceFirebird(int nConnectionType)      Constructs a firebird data store interface with the given connection type. Method Summary protected  String addEscapeChars(String sOldString)      public  void createTable(TableDefinition tblDef)      protected  String generateFromClause(AbstractDMLStatement DML, Vector saTables)      Generate 'from' clause from the given DML statment. protected  String generateOrderByClause(SelectStatement select)      protected  String generateWhereClause(SelectStatement select)      protected  String generateWhereClause(AbstractDMLStatement DML)      public  String getBooleanDataType()      public  String getCLOBDataType()      public  String getClob(String sTable, String sColumn, String sCondition)      protected  String getDateAsSQL(String date)      public  String getDateDataType()      public  String getDeleteStatement(DeleteStatement delete)      protected  String getFunction(Function func)      public  String getInnerJoinCondition(ColumnRef ref1, ColumnRef ref2)      Returns the SQL inner join condition for the two given column references. public  String getInsertStatement(InsertStatement insert)      public  String getJoinCondition(ColumnRef ref1, ColumnRef ref2, boolean bIsOuter)      protected  String getOrderByRef(ColumnRef ordercol)      public  String getOuterJoinCondition(ColumnRef ref1, ColumnRef ref2, AbstractDMLStatement DML)      public  String getSelectStatement(SelectStatement select)      public  List getSequenceList()      public  int getSequenceNextValue(String sSeqName)      public  List getTableList()      public  String getUpdateStatement(UpdateStatement update)      public  void insertClob(String sTable, String sColumn, String sClob, String sCondition)      public  void updateClob(String sTable, String sColumn, String sClob, String sCondition)      Constructor Detail DataStoreInterfaceFirebird public DataStoreInterfaceFirebird()(Code) Constructs a firebird data store interface with no DB settings. DataStoreInterfaceFirebird public DataStoreInterfaceFirebird(String sJDBCDriver, String sDBurl, String sDBUsr, String sDBPwd)(Code) Constructs a firebird data store interface with the given DB settings. Parameters:   sJDBCDriver - the JDBC driver class name Parameters:   sDBurl - the database URI Parameters:   sDBUsr - the database user name Parameters:   sDBPwd - the database user password DataStoreInterfaceFirebird public DataStoreInterfaceFirebird(int nConnectionType) throws DataStoreException(Code) Constructs a firebird data store interface with the given connection type. Parameters:   nConnectionType - the connection type throws:   DataStoreException - if an error occurs Method Detail addEscapeChars protected String addEscapeChars(String sOldString)(Code) createTable public void createTable(TableDefinition tblDef) throws DataStoreException(Code) generateFromClause protected String generateFromClause(AbstractDMLStatement DML, Vector saTables) throws DataStoreException(Code) Generate 'from' clause from the given DML statment. Parameters:   DML - the DML statement Parameters:   saTables - the list of table names from the DML statment the 'from' clause throws:   DataStoreException - if an error occurs generateOrderByClause protected String generateOrderByClause(SelectStatement select)(Code) generateWhereClause protected String generateWhereClause(SelectStatement select) throws DataStoreException(Code) generateWhereClause protected String generateWhereClause(AbstractDMLStatement DML) throws DataStoreException(Code) getBooleanDataType public String getBooleanDataType()(Code) getCLOBDataType public String getCLOBDataType()(Code) getClob public String getClob(String sTable, String sColumn, String sCondition) throws DataStoreException(Code) getDateAsSQL protected String getDateAsSQL(String date)(Code) getDateDataType public String getDateDataType()(Code) getDeleteStatement public String getDeleteStatement(DeleteStatement delete) throws DataStoreException(Code) getFunction protected String getFunction(Function func) throws DataStoreException(Code) getInnerJoinCondition public String getInnerJoinCondition(ColumnRef ref1, ColumnRef ref2)(Code) Returns the SQL inner join condition for the two given column references. Parameters:   ref1 - the first column reference Parameters:   ref2 - the second column reference the SQL inner join condition getInsertStatement public String getInsertStatement(InsertStatement insert) throws DataStoreException(Code) getJoinCondition public String getJoinCondition(ColumnRef ref1, ColumnRef ref2, boolean bIsOuter)(Code) getOrderByRef protected String getOrderByRef(ColumnRef ordercol)(Code) getOuterJoinCondition public String getOuterJoinCondition(ColumnRef ref1, ColumnRef ref2, AbstractDMLStatement DML)(Code) Parameters:   ref1 - Parameters:   ref2 - Parameters:   DML - getSelectStatement public String getSelectStatement(SelectStatement select) throws DataStoreException(Code) getSequenceList public List getSequenceList() throws DataStoreException(Code) getSequenceNextValue public int getSequenceNextValue(String sSeqName) throws DataStoreException, SQLException(Code) getTableList public List getTableList() throws DataStoreException(Code) getUpdateStatement public String getUpdateStatement(UpdateStatement update) throws DataStoreException(Code) insertClob public void insertClob(String sTable, String sColumn, String sClob, String sCondition) throws DataStoreException(Code) updateClob public void updateClob(String sTable, String sColumn, String sClob, String sCondition) throws DataStoreException(Code) Fields inherited from org.openharmonise.commons.dsi.AbstractDataStoreInterface final public static int DB_CONNECTION_BROKER(Code)(Java Doc) protected static String DB_DATEFORMAT(Code)(Java Doc) final public static int OTHER_CONNECTION(Code)(Java Doc) final public static int POOLED_CONNECTION(Code)(Java Doc) protected static boolean m_bIsNationalCharacterSupported(Code)(Java Doc) Methods inherited from org.openharmonise.commons.dsi.AbstractDataStoreInterface abstract protected String addEscapeChars(String sOldString)(Code)(Java Doc) public void closeConnection(Connection conn)(Code)(Java Doc) abstract public void createTable(TableDefinition tblDef) throws DataStoreException(Code)(Java Doc) public void disconnect() throws SQLException(Code)(Java Doc) public void execute(String sSql) throws DataStoreException(Code)(Java Doc) public ResultSet execute(SelectStatement query) throws DataStoreException(Code)(Java Doc) public int execute(UpdateStatement update) throws DataStoreException(Code)(Java Doc) public void execute(InsertStatement insert) throws DataStoreException(Code)(Java Doc) public void execute(DeleteStatement delete) throws DataStoreException(Code)(Java Doc) public void executeInsert(InsertStatement insert) throws DataStoreException(Code)(Java Doc) public ResultSet executeQuery(String sSql) throws DataStoreException(Code)(Java Doc) public ResultSet executeQuery(SelectStatement query) throws DataStoreException(Code)(Java Doc) public int executeUpdate(String sSql) throws DataStoreException(Code)(Java Doc) public int executeUpdate(UpdateStatement update) throws DataStoreException(Code)(Java Doc) protected String generateFromClause(SelectStatement select) throws DataStoreException(Code)(Java Doc) protected String generateOrderByClause(SelectStatement select)(Code)(Java Doc) protected String generateWhereClause(SelectStatement select) throws DataStoreException(Code)(Java Doc) protected String generateWhereClause(AbstractDMLStatement DML) throws DataStoreException(Code)(Java Doc) protected String generateWhereClause(WhereConditionGroup where) throws DataStoreException(Code)(Java Doc) abstract public String getBooleanDataType()(Code)(Java Doc) abstract public String getCLOBDataType()(Code)(Java Doc) abstract public String getClob(String sTable, String sColumn, String sCondition) throws DataStoreException(Code)(Java Doc) public Connection getConnection() throws DataStoreException(Code)(Java Doc) public String getDatabaseURL()(Code)(Java Doc) abstract protected String getDateAsSQL(String date)(Code)(Java Doc) abstract public String getDateDataType()(Code)(Java Doc) public String getDeleteStatement(DeleteStatement delete) throws DataStoreException(Code)(Java Doc) abstract protected String getFunction(Function func) throws DataStoreException(Code)(Java Doc) public String getInsertStatement(InsertStatement insert) throws DataStoreException(Code)(Java Doc) abstract public String getJoinCondition(ColumnRef ref1, ColumnRef ref2, boolean bIsOuter)(Code)(Java Doc) protected String getOrderByRef(ColumnRef ordercol)(Code)(Java Doc) public String getSelectStatement(SelectStatement select) throws DataStoreException(Code)(Java Doc) abstract public List getSequenceList() throws DataStoreException(Code)(Java Doc) abstract public int getSequenceNextValue(String sSeqName) throws DataStoreException, SQLException(Code)(Java Doc) abstract public List getTableList() throws DataStoreException(Code)(Java Doc) public String getUpdateStatement(UpdateStatement update) throws DataStoreException(Code)(Java Doc) public void initialise(int nConnectionType) throws Exception(Code)(Java Doc) abstract public void insertClob(String sTable, String sColumn, String sClob, String sCondition) throws DataStoreException(Code)(Java Doc) protected boolean isNationalCharacterSupported()(Code)(Java Doc) public boolean isPooledConnection()(Code)(Java Doc) public boolean isTableExist(String sTableName) throws DataStoreException(Code)(Java Doc) public static java.util.Date parseDate(String sDate) throws ParseException(Code)(Java Doc) public void setDataStoreDetails(String sJDBCDriver, String sDBurl, String sDBUsr, String sDBPwd)(Code)(Java Doc) protected void setNationalCharacterSupport(boolean bIsSupported)(Code)(Java Doc) abstract public void updateClob(String sTable, String sColumn, String sClob, String sCondition) throws DataStoreException(Code)(Java Doc) 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)