add link for reference on how to do record limits in oracle
use RDBMS-specific features to limit the resultset for paging -- postgres and oracle have implementations. we don''t really support mssql so I skipped that one.
Change location of PropertyService to properties directory
Merge 1.9 changes into Head
Removed the release ant token from all files in 'src'.
New function which returns the formatted left join query. This is required as Oracle and postgres have different left join syntax
Add class as parent class add method.
Add method as parent class adding method.
Add method as parent class adding a method.
Add a method to get doc list query.
Revise the toDate method for sql server.
Get rid of toDate method and inherit from AbstractAdapter directly.
Get rid of toDate method. It inherentise from AbstractAdaptor.
Add a concrete method toDate which can transfer text string to date type.
Add new method to handle toDate function.
Change back to pass Connection a parameter.
Change back to pass connection as parameter.
Change back to pass connection as a parameter. Because new connection will cause an error.
Change back to pass connection as paramter in getUniqueID, otherwise new connection will cause a error: sequence XML_NODES_ID_SEQ.CURRVAL is not yet defined in this session
Using getDBConenction rather than pass connection as parameter.
Using getDBConnection rather than pass connection as a parameter.
Using getDBConnection method rather than a parameter.
Change the prototype of method getUniqeID
made a ton of changes related to keeping oracle SQL code out of the main classes. fixed a bug where the timing of the index thread was off so when it went to index a document, the document was not already in xml_documents thus breaking the FK relation between xml_documents and xml_index. I think that bug might be the reason for the blank resultset screens in morpho. made the postgres implementation much more robust.
changed all mentions of DBAdapter to the new name AbstractDatabase
rename the DB* classes to:AbstractDatabaseOracleAdapterPostgresqlAdapterSqlserverAdapter
included new function that returns db specific non-null function name
- new db adapter for MS SQL Server- changed the getUniqueID(conn, tableName) to return the last generated by the db unique IDinstead of generating unique ID first by the appl and then supplied to the insert,because SQL Server doesn't have capabilitiesunique ID to be generated on the client and then supplied to the insert.
changed the getDate method to getDateTime and changed the returnstring in the postgresql implementation to "now()" from now()::date
change the method name getDateString() to getDateFunction()return "now()::date" in the DBPostgresql implementation of that method
The Postgres implementation of the dbadapter package, still needs testing andthe getDate... method just returns the db function to return the date; to retreive thecurrent time is a second function so we may want to add a second method to return thecurrent time.
the abstract DBAdapter class and its Oracle implementationfor the new dbadapter package