advantage to opening it when configured?
James Stauffer
9.2.0.3.0 database.
James Stauffer
Title: RE: tests/build.xml: Support for Oracle and MS SQL
Do you want them before the tests pass? I figured the build.xml wouldn't change based on the tests but the properties could.
James Stauffer
-Original Message-
From: Ceki Gülcü [mailto:[EMAIL PROTECTED]]
Sent: Friday,
Title: tests/build.xml: Support for Oracle and MS SQL
The following change should add support for Oracle and MS SQL. I haven't included the sample properties files yet but the fact that they are missing shouldn't hurt anything else.
Also this specifically mentions a Weblogic driver. What sh
Title: RE: cvs commit: logging-log4j/src/java/org/apache/log4j/db/dialec t mssql.sql
How is it configured to not log that info (since it is supposed to be expensive)?
Also am I curious why you write "?" instead of just leaving it null.
James Stauffer
-Original Message
Title: RE: cvs commit: logging-log4j/src/java/org/apache/log4j/db/dialect mssql.sql
Why did you add them as non-null? Will they always be written?
James Stauffer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 20, 2004 11:19 AM
To
ConnectionSource.ORACLE_DIALECT;
} else {
James Stauffer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 18, 2004 12:00 PM
To: [EMAIL PROTECTED]
Subject: cvs commit: logging-log4j/src/java/org/apache/log4j/db ConnectionSource.java
OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.log4j.db.dialect;
/**
* The MS SQL Server dialect is untested.
*
* @author James Stauffer
*/
public class MsS
(
event_id INT NOT NULL,
i SMALLINT NOT NULL,
trace_line VARCHAR(254) NOT NULL,
PRIMARY KEY(event_id, i),
FOREIGN KEY (event_id) REFERENCES logging_event(event_id)
)
James Stauffer
-Original Message-----
From: James Stauffer [mailto:[EMAIL PR
level then making it varchar(10) would give plenty of room. Why is it so big?
James Stauffer
thing like 32 (this isn't important to me but 254 seems like a waste of space) and increasing mapped_value to 510 or 1022 (assuming that 254 was chosen as 2 less than a power of 2)?
James Stauffer
NUMBER(38)
James Stauffer
-Original Message-
From: Raymond DeCampo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 13, 2004 10:17 PM
To: Log4J Developers List
Subject: Re: Oracle.sql incorrect
James Stauffer wrote:
> Ceki is correct INTEGER doesn't need to be changed to N
Title: RE: oracle.sql
I just tries it in SQL*Plus and it works for me. Go figure. :-)
James Stauffer
-Original Message-
From: Simon Dorrat [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 13, 2004 9:01 PM
To: 'Log4J Developers List'
Subject: RE: oracle.sql
Yes, work
ne.
SELECT logging_event_id_seq.NEXTVAL
INTO :new.event_id
FROM dual
Doesn't make that much difference, but simpler is better!
Simon
> -Original Message-
> From: James Stauffer [SMTP:[EMAIL PROTECTED]
> Sent: Thursday, 13 May 2004 6:47 AM
>
Log.debug("SQL: " + sql);
DatabaseManager.ExecuteInsert(sql);
} catch(SQLException e) {
LogLog.error("Problem writing Exception lines", e);
}
}
James Stauffer
d_seq_trig;
/
James Stauffer
Title: RE: Oracle.sql incorrect
It seems to be mean "run" or "execute". I know that without it I get a parse error. In Oracle SQL Plus "/" causes the last command to run (again).
James Stauffer
-Original Message-
From: Ceki Gülcü [mailto:[EMAIL PRO
Title: RE: Oracle.sql incorrect
INTEGER/INT and SMALLINT can be left as is. I just tested it. I wrongly assumed that since BIGINT didn't work none of the others would.
James Stauffer
-Original Message-
From: Ceki Gülcü [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 12, 2
Title: mysql.sql and postgresql.sql binary
It appears that mysql.sql and postgresql.sql are marked as binary in cvs. Is there a reason for that?
James Stauffer
INT NOT NULL,
i NUMBER(5) NOT NULL,
trace_line VARCHAR2(254) NOT NULL,
PRIMARY KEY(event_id, i),
FOREIGN KEY (event_id) REFERENCES logging_event(id)
);
End of file
James Stauffer
-Original Message-
From: Ceki
d_seq_trig;
--drop SEQUENCE logging_event_id_seq;
--drop table logging_event_property;
--drop table logging_event_exception;
--drop table logging_event;
James Stauffer
-Original Message-----
From: James Stauffer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 12, 2004 7:33 AM
To: 'Log4J
Title: Message
Ceki is correct
INTEGER doesn't need to be changed to NUMBER(10). Also I think my trigger
still isn't correct. I'll check.
James
Stauffer
-Original Message-----From: James Stauffer
[mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 7:2
ed variable.
Sorry for the white space changes. I didn't notice them. I'll post an updated diff attachment without the white space changes. Ceki mentioned closing the issue and discussing on this list. That is fine with me but would I then post the diff to the list?
James Stauffer
Title: Correct patch format? (Was: DO NOT REPLY [Bug 28907] - db/dialect classes not in log4j-1.3alpha0.jar)
Is my attached patch in the correct format?
James Stauffer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 11, 2004 12:58 PM
To
Title: org\apache\log4j\db\dialect\oracle.sql
The current version of org\apache\log4j\db\dialect\oracle.sql doesn't run on my Oracle instance (9.2). After I get it to work should I create a bugzilla issue with my changes?
James Stauffer
Title: logging_event.id
What do you think of logging_event.id being renamed to logging_event.event_id so that the column name matches the other tables?
James Stauffer
vent logging.
Are arbitrary options supported?
Would everyting have to go in the Database as a string?
How would dates and sequence numbers be handled?
Could we treat the value as a date if(value.startsWith(%d) || (value.startsWith(%d{) && value.indexOf(&qu
Database instead of log4j. Please correct me if I am wrong.
James Stauffer
-Original Message-
From: Danko Mannhaupt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 27, 2004 8:35 AM
To: Log4J Developers List
Subject: Re: PreparedStatementAppender vs. JDBCAppenderP
ce another fileName (producing directories as
necessary). Is this something that you would be interested in having
in log4j? If yes, I can clean it up more and follow any advice you
have. I tried bugzilla but it appears to be down right now.
Questions and comments are welcome.
James Stauffer
29 matches
Mail list logo
