I was testing migrating an old CF5 application to OpenBD. I have my
<cfapplication> settings as:
<cfapplication>
<clientstorage>COLDFUSION</clientstorage>
<enabled>true</enabled>
<sessiontimeout>#CreateTimeSpan(0,0,20,0)#</sessiontimeout>
<applicationtimeout>#CreateTimeSpan(2,0,0,0)#</
applicationtimeout>
<j2eesession>false</j2eesession>
<cf5clientdata>true</cf5clientdata>
</cfapplication>
The issue is that I am getting multiple inserts in the DB client
storage for each CFID, as in:
3:56515046 HITCOUNT=1#LASTVISIT={ts '2008-11-04
12:56:18'}#TIMECREATED={ts '2008-11-04
12:56:18'}#URLTOKEN=CFID=3&CFTOKEN=56515046#CFTOKEN=56515046#CFID=3#
11/4/2008 12:56:18 PM
3:56515046 HITCOUNT=1#LASTVISIT={ts '2008-11-04
12:56:14'}#TIMECREATED={ts '2008-11-04
12:56:13'}#URLTOKEN=CFID=3&CFTOKEN=56515046#CFTOKEN=56515046#CFID=3#
11/4/2008 12:56:14 PM
2:89718243 HITCOUNT=1#LASTVISIT={ts '2008-11-04
12:46:05'}#TIMECREATED={ts '2008-11-04
12:46:05'}#URLTOKEN=CFID=2&CFTOKEN=89718243#CFTOKEN=89718243#CFID=2#
11/4/2008 12:46:05 PM
1:38498401 HITCOUNT=1#LASTVISIT={ts '2008-11-04
12:45:43'}#TIMECREATED={ts '2008-11-04
12:45:43'}#URLTOKEN=CFID=1&CFTOKEN=38498401#CFTOKEN=38498401#CFID=1#
11/4/2008 12:45:43 PM
0:87711687 HITCOUNT=1#LASTVISIT={ts '2008-11-04
12:40:07'}#TIMECREATED={ts '2008-11-04
12:40:07'}#URLTOKEN=CFID=0&CFTOKEN=87711687#CFTOKEN=87711687#CFID=0#
11/4/2008 12:40:07 PM
0:87711687 HITCOUNT=1#LASTVISIT={ts '2008-11-04
12:40:06'}#TIMECREATED={ts '2008-11-04
12:40:06'}#URLTOKEN=CFID=0&CFTOKEN=87711687#CFTOKEN=87711687#CFID=0#
11/4/2008 12:40:06 PM
The bluedragon.log file reports:
04/11/08 12:45.43: Error updating CLIENT data for 1-38498401:
java.sql.SQLException: [Microsoft][SQL Native Client]Function sequence
error
04/11/08 12:46.05: Error updating CLIENT data for 2-89718243:
java.sql.SQLException: [Microsoft][SQL Native Client]Function sequence
error
04/11/08 12:56.14: Error updating CLIENT data for 3-56515046:
java.sql.SQLException: [Microsoft][SQL Native Client]Function sequence
error
04/11/08 12:56.18: Error updating CLIENT data for 3-56515046:
java.sql.SQLException: [Microsoft][SQL Native Client]Function sequence
error
04/11/08 13:06.01: Error updating CLIENT data for 3-56515046:
java.sql.SQLException: [Microsoft][SQL Native Client]Function sequence
error
04/11/08 13:06.40: Error updating CLIENT data for 3-56515046:
java.sql.SQLException: [Microsoft][SQL Native Client]Function sequence
error
What I would expect to see is a single record for each cfid:cftoken
pair which gets updated for each HITCOUNT and LASTVISIT.
I believe I'm running the 10-21 release but am not sure because the
product version says: 04/11/08 12:14.04: -] Product Version:
7,0,1,$Date: 2008/07/21 19:14:03 $.
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official blog @ http://blog.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
