DO NOT REPLY [Bug 28908] - Oracle.sql incorrect

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT . ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bu

DO NOT REPLY [Bug 28908] - Oracle.sql incorrect

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT . ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE. http://issues.apache.org/bugzilla/show_bu

RE: Oracle.sql incorrect

Title: RE: Oracle.sql incorrect I also noticed that the size of the field is quite large when using INTEGER (number(38)). describe logging_event; Name        Null?   Type SEQUENCE_NUMBER NOT NULL    NUMBER(20) TIMESTAMP     NOT NULL  NUMBER(20) RENDERED_MESSAGE

Re: Oracle.sql incorrect

James Stauffer wrote: 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. It has been my experience with Oracle that "INTEGER" doesn't mean integer. That is, "INTEGER" is mapped to NUMBER (without adornments). A NUMBER w

Re: Oracle.sql incorrect

Ceki Gülcü wrote: At 02:47 PM 5/12/2004, James Stauffer wrote: It appears the only thing wrong with the trigger is that it needs "/" on the line right after it ends. What's with the "/" voodoo? :-) "/" is used in sqlplus to execute all the lines in the current buffer. Using certain commands i

RE: Oracle.sql incorrect

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

RE: Oracle.sql incorrect

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

RE: Oracle.sql incorrect

AIL PROTECTED]>mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 7:33 AM To: 'Log4J Developers List' Subject: RE: Oracle.sql incorrect 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

Re: Oracle.sql incorrect

James, After comparing with http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/mapping.html#996857 section: 8.9.7 JDBC Types Mapped to Database-specific SQL Types my suggestion would be: BIGINT -> NUMBER(20) OK TEXT -> VARCHAR2(4000) OK SMALLINT -> NUMBER(5), should stay as SMALLINT? INT ->

RE: Oracle.sql incorrect

Title: RE: Oracle.sql incorrect The warning can probably now be removed also. :-) --- Begin file -- This SQL script creates the required tables by org.apache.log4j.db.DBAppender and -- org.apache.log4j.db.DBReceiver. -- -- It is intended for Oracle databases

RE: Oracle.sql incorrect

gt;mailto:[EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 7:33 AM To: 'Log4J Developers List' Subject: RE: Oracle.sql incorrect 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 -

RE: Oracle.sql incorrect

Title: RE: Oracle.sql incorrect It appears the only thing wrong with the trigger is that it needs "/" on the line right after it ends. Also, for me it has been helpful to have the drop commands in the file.  Do we want to included them in a comment? --drop TRIGGER logging_event_i

RE: Oracle.sql incorrect

0 AMTo: 'Log4J Developers List'Subject: Oracle.sql incorrect My changes where: Prefix comment lines with "--".  "#" didn't parse. BIGINT -> NUMBER(20) TEXT -> VARCHAR2(4000) SMALLINT -> NUMBER(5) INT -> NUMBER(10) VARCHAR -> VARCHAR2 I also had to cha

DO NOT REPLY [Bug 28908] - Oracle.sql incorrect

gzilla/show_bug.cgi?id=28908 Oracle.sql incorrect --- Additional Comments From [EMAIL PROTECTED] 2004-05-12 12:26 --- Created an attachment (id=11521) Updated diff with white space changes removed - To unsubscribe, e-mail:

Oracle.sql incorrect

Title: Oracle.sql incorrect My changes where: Prefix comment lines with "--".  "#" didn't parse. BIGINT -> NUMBER(20) TEXT -> VARCHAR2(4000) SMALLINT -> NUMBER(5) INT -> NUMBER(10) VARCHAR -> VARCHAR2 I also had to change the trigger to use a declar

DO NOT REPLY [Bug 28908] - Oracle.sql incorrect

gzilla/show_bug.cgi?id=28908 Oracle.sql incorrect [EMAIL PROTECTED] changed: What|Removed |Added Status|NEW |ASSIGNED Priority

DO NOT REPLY [Bug 28908] - Oracle.sql incorrect

gzilla/show_bug.cgi?id=28908 Oracle.sql incorrect --- Additional Comments From [EMAIL PROTECTED] 2004-05-11 22:40 --- Diff's can be hard to read, but is this basically changing all 'int' columns to INTEGER(10) and BIGINTS to INTEGER(20)? If this is the case, then I would +

DO NOT REPLY [Bug 28908] - Oracle.sql incorrect

gzilla/show_bug.cgi?id=28908 Oracle.sql incorrect [EMAIL PROTECTED] changed: What|Removed |Added Severity|Major |Normal --- Additional Comments From

DO NOT REPLY [Bug 28908] - Oracle.sql incorrect

gzilla/show_bug.cgi?id=28908 Oracle.sql incorrect --- Additional Comments From [EMAIL PROTECTED] 2004-05-11 18:07 --- Created an attachment (id=11514) src/java/org/apache/log4j/db/dialect/oracle.sql update to work with Orac

DO NOT REPLY [Bug 28908] New: - Oracle.sql incorrect

gzilla/show_bug.cgi?id=28908 Oracle.sql incorrect Summary: Oracle.sql incorrect Product: Log4j Version: 1.3alpha Platform: Other OS/Version: Other Status: NEW Severity: Major Priority: Other Component: Ap