Author: ate
Date: Thu Dec 21 07:00:20 2006
New Revision: 489379
URL: http://svn.apache.org/viewvc?view=rev&rev=489379
Log:
Fixing Out of Range exceptions for user statistics elapsed_time column.
Tomcat serializes (by default) existing sessions when the server goes down and
only on startup again the session expired interceptor will be notified.
That means the elapsed_time value for that session (in milliseconds) can easily
overflow the INTEGER.MAX_VALUE range and I've encountered this already several
times.
Modified:
portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml
portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql
Modified: portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml
URL:
http://svn.apache.org/viewvc/portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml?view=diff&rev=489379&r1=489378&r2=489379
==============================================================================
--- portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml (original)
+++ portals/jetspeed-2/trunk/etc/schema/phase1-schema.xml Thu Dec 21 07:00:20
2006
@@ -101,7 +101,7 @@
<column name='PAGE' type='VARCHAR' size="80"/>
<column name='PORTLET' type='VARCHAR' size="255"/>
<column name='STATUS' type='INTEGER'/>
- <column name='ELAPSED_TIME' type='INTEGER'/>
+ <column name='ELAPSED_TIME' type='BIGINT'/>
</table>
<table name='PAGE_STATISTICS'>
@@ -110,7 +110,7 @@
<column name='TIME_STAMP' type='TIMESTAMP'/>
<column name='PAGE' type='VARCHAR' size="80"/>
<column name='STATUS' type='INTEGER'/>
- <column name='ELAPSED_TIME' type='INTEGER'/>
+ <column name='ELAPSED_TIME' type='BIGINT'/>
</table>
<table name='USER_STATISTICS'>
@@ -118,7 +118,7 @@
<column name='USER_NAME' type='VARCHAR' size="80"/>
<column name='TIME_STAMP' type='TIMESTAMP'/>
<column name='STATUS' type='INTEGER'/>
- <column name='ELAPSED_TIME' type='INTEGER'/>
+ <column name='ELAPSED_TIME' type='BIGINT'/>
</table>
</database>
Modified: portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql
URL:
http://svn.apache.org/viewvc/portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql?view=diff&rev=489379&r1=489378&r2=489379
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/derby/schema/phase1-schema.sql Thu Dec 21
07:00:20 2006
@@ -95,7 +95,7 @@
PAGE VARCHAR(80),
PORTLET VARCHAR(255),
STATUS INTEGER,
- ELAPSED_TIME INTEGER);
+ ELAPSED_TIME BIGINT);
-----------------------------------------------------------------------------
-- PAGE_STATISTICS
@@ -108,7 +108,7 @@
TIME_STAMP TIMESTAMP,
PAGE VARCHAR(80),
STATUS INTEGER,
- ELAPSED_TIME INTEGER);
+ ELAPSED_TIME BIGINT);
-----------------------------------------------------------------------------
-- USER_STATISTICS
@@ -120,5 +120,5 @@
USER_NAME VARCHAR(80),
TIME_STAMP TIMESTAMP,
STATUS INTEGER,
- ELAPSED_TIME INTEGER);
+ ELAPSED_TIME BIGINT);
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
