issue with web.persistSession Server 6.10 on Windows server 2022 / SQL Server 2019

ppet3 days ago

Hi to all

i tried to add to the traccar.xml the following line

<entry key='web.persistSession'>true</entry>

restart the service starts and stops with the error in the log file:

ERROR: Main method error - Column, parameter, or variable #12: Cannot find data type blob. - SQLServerException (... < WebServer:226 < Main:127 < *:95 < WindowsService:184 < ...)

same results on the backup server with the same version and on an older 6.6 version

Is it supported?
is it an issue when database is SQL Server?

thanks

Anton Tananaev3 days ago

Very possible that this feature is not supported for SQL Server. I don't think we tested with anything other than MySQL.

ppet2 days ago

Hi Anton
thank you for your anwser even if this not what i wanted to hear

it is a bit strange to me
SQL server equivalent to BLOB is varbinary(n)
table keystore columns is of this type in the SQL Server Traccar database