Metacat

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:
AbstractDatabase
OracleAdapter
PostgresqlAdapter
SqlserverAdapter

included new function that returns db specific non-null function name