jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Neil <ncorbe...@hotmail.com>
Subject Are DBA Changes to the Jackrabbit Tables Ok?
Date Sat, 12 Feb 2011 18:52:00 GMT

Hello all,

       The dba for my company wants to make some changes to the tables that
were created in Oracle for my Jackrabbit app. I tried to explain to him that
JCR is not relational and that the Table creation was handled by the
repository on startup and when accessing the workspace the first time. Being
a DBA he couldn't let it go, so he made the following changes and I would
like to get some feedback on the dangers if any these changes could pose.

      For the {$workspaceName}_BUNDLE and {$workspaceName}_BINVAL tables:
            1. Changed the LOB storage to SECUREFILE type
            2. Added an INSERT_DATE and LAST_MODIFIED fields that are update
by before Insert and Update
            3. Removed Unique Index constraint and created Primary Key on

      For the DATASTORE table:
            1.   Changed LOB storage to SECUREFILE type.


View this message in context: http://jackrabbit.510166.n4.nabble.com/Are-DBA-Changes-to-the-Jackrabbit-Tables-Ok-tp3303004p3303004.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

View raw message