Java Doc for PostgreSqlSqlHandler.java in  » Database-ORM » MMBase » org » mmbase » storage » search » implementation » database » 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 ORM » MMBase » org.mmbase.storage.search.implementation.database   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.mmbase.storage.search.implementation.database.BasicSqlHandler       org.mmbase.storage.search.implementation.database.PostgreSqlSqlHandler PostgreSqlSqlHandler public class PostgreSqlSqlHandler extends BasicSqlHandler implements SqlHandler(Code) The PostgreSQL query handler, implements org.mmbase.storage.search.implementation.database.SqlHandler SqlHandler for standard PostgreSql functionality. Derived from BasicSqlHandler BasicSqlHandler , overrides PostgreSqlSqlHandler.toSql toSql() , implements org.mmbase.storage.search.SearchQueryHandler.FEATURE_MAX_NUMBERFEATURE_MAX_NUMBER and org.mmbase.storage.search.SearchQueryHandler.FEATURE_OFFSETFEATURE_OFFSET , by adding a construct like "LIMIT 20" or "LIMIT 20 OFFSET 80" after the body, when appropriate. PostgreSqlSqlHandler.getSupportLevel(int,SearchQuery) getSupportLevel(int,SearchQuery) , returns org.mmbase.storage.search.SearchQueryHandler.SUPPORT_OPTIMALSUPPORT_OPTIMAL for these features, delegates to the superclass for other features. author:    Rob van Maris version:    $Id: PostgreSqlSqlHandler.java,v 1.33 2007/06/12 10:59:41 michiel Exp $ since:    MMBase-1.7 Constructor Summary public   PostgreSqlSqlHandler()      Constructor. Method Summary protected  void appendDateField(StringBuilder sb, Step step, String fieldName, boolean multipleSteps, int datePart)      protected  StringBuilder appendLikeOperator(StringBuilder sb, boolean caseSensitive)      protected  StringBuilder appendSortOrderField(StringBuilder sb, SortOrder sortOrder, boolean multipleSteps, SearchQuery query)      Normally, Postgresql does not sort case senstively, so we should not sort on UPPER(fieldname). protected  void appendTableName(StringBuilder sb, Step step)      Optimizes postgresql queries by adding the ONLY keyword to a relation-table, provided that the role was given (and therefor the selection only applies to the given table). public  int getSupportLevel(int feature, SearchQuery query)      public  String toSql(SearchQuery query, SqlHandler firstInChain)      protected  boolean useLower(FieldCompareConstraint constraint)      Constructor Detail PostgreSqlSqlHandler public PostgreSqlSqlHandler()(Code) Constructor. Method Detail appendDateField protected void appendDateField(StringBuilder sb, Step step, String fieldName, boolean multipleSteps, int datePart)(Code) date time functions appendLikeOperator protected StringBuilder appendLikeOperator(StringBuilder sb, boolean caseSensitive)(Code) appendSortOrderField protected StringBuilder appendSortOrderField(StringBuilder sb, SortOrder sortOrder, boolean multipleSteps, SearchQuery query)(Code) Normally, Postgresql does not sort case senstively, so we should not sort on UPPER(fieldname). This is mainly very bad if the query is also distinct. (ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list), may occur. appendTableName protected void appendTableName(StringBuilder sb, Step step)(Code) Optimizes postgresql queries by adding the ONLY keyword to a relation-table, provided that the role was given (and therefor the selection only applies to the given table). See Also:   org.mmbase.storage.search.implementation.database.BasicSqlHandler.appendTableName(java.lang.StringBuilderorg.mmbase.storage.search.Step) getSupportLevel public int getSupportLevel(int feature, SearchQuery query) throws SearchQueryException(Code) toSql public String toSql(SearchQuery query, SqlHandler firstInChain) throws SearchQueryException(Code) useLower protected boolean useLower(FieldCompareConstraint constraint)(Code) Methods inherited from org.mmbase.storage.search.implementation.database.BasicSqlHandler protected void appendCompositeConstraintToSql(StringBuilder sb, CompositeConstraint compositeConstraint, SearchQuery query, boolean inverse, boolean inComposite, SqlHandler firstInChain) throws SearchQueryException(Code)(Java Doc) public void appendConstraintToSql(StringBuilder sb, Constraint constraint, SearchQuery query, boolean inverse, boolean inComposite)(Code)(Java Doc) protected void appendDateField(StringBuilder sb, Step step, String fieldName, boolean multipleSteps, int datePart)(Code)(Java Doc) protected void appendDateValue(StringBuilder sb, Date value)(Code)(Java Doc) protected void appendField(StringBuilder sb, SortOrder sortOrder, boolean includeTablePrefix)(Code)(Java Doc) protected void appendField(StringBuilder sb, Step step, String fieldName, boolean includeTablePrefix)(Code)(Java Doc) public void appendFieldValue(StringBuilder sb, Object value, boolean toLowerCase, int fieldType)(Code)(Java Doc) protected StringBuilder appendLikeOperator(StringBuilder sb, boolean caseSensitive)(Code)(Java Doc) protected void appendLowerField(StringBuilder sb, Step step, String fieldName, boolean includeTablePrefix)(Code)(Java Doc) public void appendQueryBodyToSql(StringBuilder sb, SearchQuery query, SqlHandler firstInChain) throws SearchQueryException(Code)(Java Doc) protected void appendRelationConstraints(StringBuilder sbRelations, RelationStep relationStep, boolean multipleSteps)(Code)(Java Doc) protected StringBuilder appendSortOrderDirection(StringBuilder sb, SortOrder sortOrder) throws IllegalStateException(Code)(Java Doc) protected StringBuilder appendSortOrderField(StringBuilder sb, SortOrder sortOrder, boolean multipleSteps)(Code)(Java Doc) protected StringBuilder appendSortOrderField(StringBuilder sb, SortOrder sortOrder, boolean multipleSteps, SearchQuery query)(Code)(Java Doc) protected StringBuilder appendSortOrders(StringBuilder sb, SearchQuery query)(Code)(Java Doc) protected void appendTableAlias(StringBuilder sb, Step step)(Code)(Java Doc) protected void appendTableName(StringBuilder sb, Step step)(Code)(Java Doc) public static String forceEncode(String st)(Code)(Java Doc) public String getAllowedValue(String value)(Code)(Java Doc) public int getSupportLevel(int feature, SearchQuery query) throws SearchQueryException(Code)(Java Doc) public int getSupportLevel(Constraint constraint, SearchQuery query) throws SearchQueryException(Code)(Java Doc) public String toSql(SearchQuery query, SqlHandler firstInChain) throws SearchQueryException(Code)(Java Doc) protected String toSqlString(String str)(Code)(Java Doc) protected boolean useLower(FieldCompareConstraint constraint)(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)