Hi Juan,
Has the client data table been created correctly in the database at
least? Which MS SQL jdbc driver are you using?
Andy
[EMAIL PROTECTED] wrote:
> 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 !!
-~----------~----~----~----~------~----~------~--~---
