Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 579660 Details for
Bug 814839
discuss the need for LOGGING on Oracle tables
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
[patch]
patch to enable logging except for places where the code wants it off
bz814839.patch (text/plain), 8.96 KB, created by
John Mazzitelli
on 2012-04-23 18:52:47 UTC
(
hide
)
Description:
patch to enable logging except for places where the code wants it off
Filename:
MIME Type:
Creator:
John Mazzitelli
Created:
2012-04-23 18:52:47 UTC
Size:
8.96 KB
patch
obsolete
>diff --git a/modules/core/dbutils/src/main/java/org/rhq/core/db/setup/Table.java b/modules/core/dbutils/src/main/java/org/rhq/core/db/setup/Table.java >index 9455aea..ca855ce 100644 >--- a/modules/core/dbutils/src/main/java/org/rhq/core/db/setup/Table.java >+++ b/modules/core/dbutils/src/main/java/org/rhq/core/db/setup/Table.java >@@ -40,7 +40,7 @@ class Table { > private String m_strName; > private boolean m_indexOrganized = false; // Index Organized Table > private boolean m_parallel = false; // Parallel processing >- private boolean m_logging = false; >+ private boolean m_logging = true; > private boolean m_cache = false; > private String m_tableSpace; > private String m_storage; >@@ -290,6 +290,10 @@ class Table { > return ""; > } > >+ /** >+ * This is actually the syntax for NO logging. If logging is set to false, >+ * this returns a string to correspond to syntax that turns off logging. >+ */ > protected String getLoggingSyntax() { > return ""; > } >diff --git a/modules/core/dbutils/src/main/scripts/dbsetup/alert-schema.xml b/modules/core/dbutils/src/main/scripts/dbsetup/alert-schema.xml >index 0cc3736..6e617d6 100644 >--- a/modules/core/dbutils/src/main/scripts/dbsetup/alert-schema.xml >+++ b/modules/core/dbutils/src/main/scripts/dbsetup/alert-schema.xml >@@ -67,7 +67,7 @@ > </table> > > <table name="RHQ_ALERT" tablespace="@@@LARGE_TABLESPACE_FOR_DATA@@@" >- storage-options="freelists 5" cache="true" logging="false"> >+ storage-options="freelists 5" cache="true"> > <column name="ID" default="sequence-only" initial="10001" > primarykey="true" required="true" type="INTEGER"/> > <column name="ALERT_DEFINITION_ID" required="false" type="INTEGER" references="RHQ_ALERT_DEFINITION(ID)"/> >@@ -86,7 +86,7 @@ > </table> > > <table name="RHQ_ALERT_NOTIF_LOG" tablespace="@@@LARGE_TABLESPACE_FOR_DATA@@@" >- storage-options="freelists 5" cache="true" logging="false"> >+ storage-options="freelists 5" cache="true"> > <column name="ID" default="sequence-only" initial="10001" > primarykey="true" required="true" type="INTEGER"/> > <column name="ALERT_ID" required="true" type="INTEGER" references="RHQ_ALERT(ID)"/> >@@ -99,7 +99,7 @@ > </table> > > <table name="RHQ_ALERT_CONDITION_LOG" tablespace="@@@LARGE_TABLESPACE_FOR_DATA@@@" >- storage-options="freelists 5" cache="true" logging="false"> >+ storage-options="freelists 5" cache="true"> > <column name="ID" default="sequence-only" initial="10001" > primarykey="true" required="true" type="INTEGER"/> > <column name="CTIME" required="true" type="LONG"/> >diff --git a/modules/core/dbutils/src/main/scripts/dbsetup/measurement-schema.xml b/modules/core/dbutils/src/main/scripts/dbsetup/measurement-schema.xml >index fecb046..90bd30f 100644 >--- a/modules/core/dbutils/src/main/scripts/dbsetup/measurement-schema.xml >+++ b/modules/core/dbutils/src/main/scripts/dbsetup/measurement-schema.xml >@@ -77,7 +77,7 @@ > </table> > > >- <table name="RHQ_MEASUREMENT_DATA_NUM_1H" logging="false" cache="true" >+ <table name="RHQ_MEASUREMENT_DATA_NUM_1H" cache="true" > tablespace="@@@LARGE_TABLESPACE_FOR_DATA@@@" storage-options="freelists 20"> > > <column name="TIME_STAMP" required="true" type="LONG"/> >@@ -99,7 +99,7 @@ > </table> > > >- <table name="RHQ_MEASUREMENT_DATA_NUM_6H" logging="false" cache="true" >+ <table name="RHQ_MEASUREMENT_DATA_NUM_6H" cache="true" > tablespace="@@@LARGE_TABLESPACE_FOR_DATA@@@" storage-options="freelists 20"> > > <column name="TIME_STAMP" required="true" type="LONG"/> >@@ -121,7 +121,7 @@ > </table> > > >- <table name="RHQ_MEASUREMENT_DATA_NUM_1D" logging="false" cache="true" >+ <table name="RHQ_MEASUREMENT_DATA_NUM_1D" cache="true" > tablespace="@@@LARGE_TABLESPACE_FOR_DATA@@@" storage-options="freelists 20"> > > <column name="TIME_STAMP" required="true" type="LONG"/> >@@ -167,7 +167,7 @@ > </table> > > >- <table name="RHQ_CALLTIME_DATA_VALUE"> >+ <table name="RHQ_CALLTIME_DATA_VALUE" logging="false"> > <column name="ID" type="INTEGER" default="sequence-only" initial="10001" primarykey="true" required="true"/> > <column name="KEY_ID" type="INTEGER" references="RHQ_CALLTIME_DATA_KEY" required="true"/> > <column name="BEGIN_TIME" type="LONG" required="true"/> >@@ -235,7 +235,7 @@ > </table> > > >- <table name="RHQ_MEAS_DATA_NUM_R00"> >+ <table name="RHQ_MEAS_DATA_NUM_R00" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -249,7 +249,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R01"> >+ <table name="RHQ_MEAS_DATA_NUM_R01" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -263,7 +263,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R02"> >+ <table name="RHQ_MEAS_DATA_NUM_R02" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -277,7 +277,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R03"> >+ <table name="RHQ_MEAS_DATA_NUM_R03" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -291,7 +291,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R04"> >+ <table name="RHQ_MEAS_DATA_NUM_R04" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -305,7 +305,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R05"> >+ <table name="RHQ_MEAS_DATA_NUM_R05" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -319,7 +319,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R06"> >+ <table name="RHQ_MEAS_DATA_NUM_R06" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -333,7 +333,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R07"> >+ <table name="RHQ_MEAS_DATA_NUM_R07" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -347,7 +347,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R08"> >+ <table name="RHQ_MEAS_DATA_NUM_R08" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -361,7 +361,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R09"> >+ <table name="RHQ_MEAS_DATA_NUM_R09" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -375,7 +375,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R10"> >+ <table name="RHQ_MEAS_DATA_NUM_R10" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -389,7 +389,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R11"> >+ <table name="RHQ_MEAS_DATA_NUM_R11" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -403,7 +403,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R12"> >+ <table name="RHQ_MEAS_DATA_NUM_R12" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -417,7 +417,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R13"> >+ <table name="RHQ_MEAS_DATA_NUM_R13" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/> >@@ -431,7 +431,7 @@ > </primaryKey> > </constraint> > </table> >- <table name="RHQ_MEAS_DATA_NUM_R14"> >+ <table name="RHQ_MEAS_DATA_NUM_R14" logging="false"> > <column name="TIME_STAMP" type="LONG"/> > <column name="SCHEDULE_ID" type="INTEGER"/> > <column name="VALUE" type="DOUBLE"/>
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 814839
: 579660 |
579981