Java Doc for BlogDatabaseSchema.java in » J2EE » OpenCore » org » opensubsystems » blog » persist » db » 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 » J2EE » OpenCore » org.opensubsystems.blog.persist.db

Source Cross Reference

Class Diagram

Java Document (Java Doc)

org.opensubsystems.blog.persist.db .BlogDatabaseSchema

All known Subclasses:   org.opensubsystems.blog.persist.db.mysql .MySQLBlogDatabaseSchema,  org.opensubsystems.blog.persist.db.hsqldb .HsqlDBBlogDatabaseSchema,  org.opensubsystems.blog.persist.db.postgresql .PostgreSQLBlogDatabaseSchema,  org.opensubsystems.blog.persist.db.oracle .OracleBlogDatabaseSchema,  org.opensubsystems.blog.persist.db.sybase .SybaseBlogDatabaseSchema,  org.opensubsystems.blog.persist.db.sapdb .SapDBBlogDatabaseSchema,  org.opensubsystems.blog.persist.db.mssql .MSSQLBlogDatabaseSchema,  org.opensubsystems.blog.persist.db.db2 .DB2BlogDatabaseSchema,
BlogDatabaseSchema
abstract public class BlogDatabaseSchema extends ModifiableListDatabaseSchemaImpl (Code)
Database specific operations related to persistence of blogs and their entries.
version:
   $Id: BlogDatabaseSchema.java,v 1.6 2007/02/20 02:14:49 bastafidli Exp $
author:
   Miro Halas

Field Summary
final public static int BLOGENTRY_CAPTION_MAXLENGTH
     Maximal length of entry caption.
final public static int BLOGENTRY_COMMENTS_MAXLENGTH
     Maximal length of entry comments.
final public static int[] BLOGENTRY_FILTER_COLUMNS
     Static variable for array of all columns codes that can be used for filtering.
final public static int BLOGENTRY_IMAGEURL_MAXLENGTH
     Maximal length of entry image URL.
final public static int[] BLOGENTRY_MANDATORY_RETRIEVE_COLUMNS
     Columns which always have to be retrieved from the database.
final public static int[] BLOGENTRY_SORT_COLUMNS
     Static variable for array of all columns codes that can be used for sorting.
final public static String BLOGENTRY_TABLE_NAME
     Table name where blog entry informations are stored.
final public static int BLOGENTRY_TARGETURL_MAXLENGTH
     Maximal length of entry target URL.
final public static int BLOG_CAPTION_MAXLENGTH
     Maximal length of blog caption.
final public static String BLOG_COLUMNS

final public static int BLOG_COMMENTS_MAXLENGTH
     Maximal length of blog comments.
final public static int[] BLOG_FILTER_COLUMNS
     Static variable for array of all columns codes that can be used for filtering.
final public static int BLOG_FOLDER_MAXLENGTH
     Maximal length of blog folder.
final public static int[] BLOG_MANDATORY_RETRIEVE_COLUMNS
     Columns which always have to be retrieved from the database.
final public static String BLOG_SCHEMA_NAME
     Name identifies this schema in the database.
final public static int BLOG_SCHEMA_VERSION
     Version of this schema in the database.
final public static int[] BLOG_SORT_COLUMNS
     Static variable for array of all columns codes that can be used for sorting.
final public static String BLOG_TABLE_NAME
     Table name where blog informations are stored.
final public static String ENTRY_COLUMNS

final public static Map FILTERABLE_COLUMNS
     Map of columns that can be used for filtering.
final public static Map MANDATORY_RETRIEVE_COLUMNS
     Map of columns that always have to be retrieved.
final public static Map SORTABLE_COLUMNS
     Map of columns that can be used for sorting.
final public static Map TABLE_NAMES
     Map of table names belonging to this schema.

Constructor Summary
public BlogDatabaseSchema()
     Default constructor.

Method Summary
public StringBuffer getColumns(boolean specific, int[] columns, Object[] prefixes, Object[] postfixes, StringBuffer buffer)

public String getDeleteBlogById()

public String getDeleteEntryById()

public String getInsertBlog()
     Method returns simple insert blog query.
abstract public String getInsertBlogAndFetchGeneratedValues()

public String getInsertEntry()
     Method returns simple insert entry query.
abstract public String getInsertEntryAndFetchGeneratedValues()

public String getSelectBlogByFolder(String strColumns)

public String getSelectBlogById(String strColumns)

public String getSelectEntryById(String strColumns)

public String getSelectLastEntry(String strColumns)

abstract public String getUpdateBlogAndFetchGeneratedValues()

abstract public String getUpdateEntryAndFetchGeneratedValues()

public void handleSQLException(SQLException exc, Connection dbConnection, int iOperationType, int iDataType, Object data)


Field Detail
BLOGENTRY_CAPTION_MAXLENGTH
final public static int BLOGENTRY_CAPTION_MAXLENGTH(Code)
Maximal length of entry caption.

BLOGENTRY_COMMENTS_MAXLENGTH
final public static int BLOGENTRY_COMMENTS_MAXLENGTH(Code)
Maximal length of entry comments.

BLOGENTRY_FILTER_COLUMNS
final public static int[] BLOGENTRY_FILTER_COLUMNS(Code)
Static variable for array of all columns codes that can be used for filtering.

BLOGENTRY_IMAGEURL_MAXLENGTH
final public static int BLOGENTRY_IMAGEURL_MAXLENGTH(Code)
Maximal length of entry image URL.

BLOGENTRY_MANDATORY_RETRIEVE_COLUMNS
final public static int[] BLOGENTRY_MANDATORY_RETRIEVE_COLUMNS(Code)
Columns which always have to be retrieved from the database. We always need data object id and domain id to correctly identify the object and modification date to provide support for optimistic locking. Caption is the allowing user to access defails of the entry and parent id allows access to the blog.

BLOGENTRY_SORT_COLUMNS
final public static int[] BLOGENTRY_SORT_COLUMNS(Code)
Static variable for array of all columns codes that can be used for sorting.

BLOGENTRY_TABLE_NAME
final public static String BLOGENTRY_TABLE_NAME(Code)
Table name where blog entry informations are stored.

BLOGENTRY_TARGETURL_MAXLENGTH
final public static int BLOGENTRY_TARGETURL_MAXLENGTH(Code)
Maximal length of entry target URL.

BLOG_CAPTION_MAXLENGTH
final public static int BLOG_CAPTION_MAXLENGTH(Code)
Maximal length of blog caption.

BLOG_COLUMNS
final public static String BLOG_COLUMNS(Code)
All columns in a blog table in the order in which they will be retrieved

BLOG_COMMENTS_MAXLENGTH
final public static int BLOG_COMMENTS_MAXLENGTH(Code)
Maximal length of blog comments.

BLOG_FILTER_COLUMNS
final public static int[] BLOG_FILTER_COLUMNS(Code)
Static variable for array of all columns codes that can be used for filtering.

BLOG_FOLDER_MAXLENGTH
final public static int BLOG_FOLDER_MAXLENGTH(Code)
Maximal length of blog folder.

BLOG_MANDATORY_RETRIEVE_COLUMNS
final public static int[] BLOG_MANDATORY_RETRIEVE_COLUMNS(Code)
Columns which always have to be retrieved from the database. We always need data object id and domain id to correctly identify the object and modification date to provide support for optimistic locking. Caption is the allowing user to access defails of the blog.

BLOG_SCHEMA_NAME
final public static String BLOG_SCHEMA_NAME(Code)
Name identifies this schema in the database.

BLOG_SCHEMA_VERSION
final public static int BLOG_SCHEMA_VERSION(Code)
Version of this schema in the database.

BLOG_SORT_COLUMNS
final public static int[] BLOG_SORT_COLUMNS(Code)
Static variable for array of all columns codes that can be used for sorting.

BLOG_TABLE_NAME
final public static String BLOG_TABLE_NAME(Code)
Table name where blog informations are stored.

ENTRY_COLUMNS
final public static String ENTRY_COLUMNS(Code)
All columns in a entry table in the order in which they will be retrieved

FILTERABLE_COLUMNS
final public static Map FILTERABLE_COLUMNS(Code)
Map of columns that can be used for filtering.

MANDATORY_RETRIEVE_COLUMNS
final public static Map MANDATORY_RETRIEVE_COLUMNS(Code)
Map of columns that always have to be retrieved.

SORTABLE_COLUMNS
final public static Map SORTABLE_COLUMNS(Code)
Map of columns that can be used for sorting.

TABLE_NAMES
final public static Map TABLE_NAMES(Code)
Map of table names belonging to this schema.

Constructor Detail
BlogDatabaseSchema
public BlogDatabaseSchema() throws OSSException(Code)
Default constructor.
throws:
  OSSException - - error occured.

Method Detail
getColumns
public StringBuffer getColumns(boolean specific, int[] columns, Object[] prefixes, Object[] postfixes, StringBuffer buffer) throws OSSException(Code)

getDeleteBlogById
public String getDeleteBlogById()(Code)
Get query to delete blog by id String - query

getDeleteEntryById
public String getDeleteEntryById()(Code)
Get query to delete entry by id String - query

getInsertBlog
public String getInsertBlog() throws OSSException(Code)
Method returns simple insert blog query. This method is common for all databases and can be overwritten for each specific database schema. String - simple insert blog query
throws:
  OSSException - - an error has occured

getInsertBlogAndFetchGeneratedValues
abstract public String getInsertBlogAndFetchGeneratedValues() throws OSSException(Code)
Get query that inserts a blog to the database and fetches database generated values such as the generated id and creation timestamp String - query for simple insert or stored procedure call
throws:
  OSSException - - an error has occured

getInsertEntry
public String getInsertEntry() throws OSSException(Code)
Method returns simple insert entry query. This method is common for all databases and can be overwritten for each specific database schema. String - simple insert entry query
throws:
  OSSException - - an error has occured

getInsertEntryAndFetchGeneratedValues
abstract public String getInsertEntryAndFetchGeneratedValues() throws OSSException(Code)
Get query that inserts a entry to the database and fetches database generated values such as the generated id and creation timestamp String - query for simple insert or stored procedure call
throws:
  OSSException - - an error has occured

getSelectBlogByFolder
public String getSelectBlogByFolder(String strColumns) throws OSSException(Code)
Get query to load blog by folder
Parameters:
  strColumns - - list of specific columns to retrieve String - query
throws:
  OSSException - - an error has occured

getSelectBlogById
public String getSelectBlogById(String strColumns) throws OSSException(Code)
Get query to load blog by id
Parameters:
  strColumns - - list of specific columns to retrieve String - query
throws:
  OSSException - - an error has occured

getSelectEntryById
public String getSelectEntryById(String strColumns) throws OSSException(Code)
Get query to load entry by id
Parameters:
  strColumns - - list of specific columns to retrieve String - query
throws:
  OSSException - - an error has occured

getSelectLastEntry
public String getSelectLastEntry(String strColumns) throws OSSException(Code)
Get query to load last created entry
Parameters:
  strColumns - - list of specific columns to retrieve String - query
throws:
  OSSException - - an error has occured

getUpdateBlogAndFetchGeneratedValues
abstract public String getUpdateBlogAndFetchGeneratedValues() throws OSSException(Code)
Get query that updates blog in the database and fetches database generated values such as the updated modification timestamp String - query for simple update or stored procedure call
throws:
  OSSException - - an error has occured

getUpdateEntryAndFetchGeneratedValues
abstract public String getUpdateEntryAndFetchGeneratedValues() throws OSSException(Code)
Get query that updates entry in the database and fetches database generated values such as the updated modification timestamp String - query for simple update or stored procedure call
throws:
  OSSException - - an error has occured

handleSQLException
public void handleSQLException(SQLException exc, Connection dbConnection, int iOperationType, int iDataType, Object data) throws OSSException(Code)

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.