https://issues.apache.org/bugzilla/show_bug.cgi?id=38052
Trooprex <troop...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|FIXED |
--- Comment #4 from Trooprex <troop...@gmail.com> 2012-02-16 09:56:28 UTC ---
How do we get this Valve working for Oracle.
1. Oracle doesn't have Auto_Increment, instead they have sequences.
2. Oracle cannot directly create a table as access. It had to be "access".
(Anyways I worked it around with tableName = "accesslogs" in the server.xml)
I had to strip down the table struct to this
CREATE TABLE accesslogs (
id VARCHAR(255),
remoteHost CHAR(15),
userName CHAR(15),
timestamp TIMESTAMP,
virtualHost VARCHAR(64),
method VARCHAR(8),
query VARCHAR(255),
status SMALLINT,
bytes INT,
referer VARCHAR(128),
userAgent VARCHAR(128)
);
Can this valve provide fix for the default table struct?
Also, the valve fails to log in the Oracle DB if I use the following pattern
pattern="Combined Log Format: %{X-Forwarded-For}i %a %h %q %v %D %T %l %u %t %r
%s %b %{User-Agent}i %{Referer}i"
It works well for pattern="combined"
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@tomcat.apache.org
For additional commands, e-mail: dev-h...@tomcat.apache.org
