Hi,
I have some strange findings if I try to active session/client storage in a
database:
I have setup a datasource ‘efactum_clientscope’ in server administrator:
Under Lucee 5.1.0.34 it is possible to set the Client Storage in server
administrator to efactum_clientscope. But when I tried to set the Session
Storage to ‘efactum_clientscope’ I got the error: Datasource is not setup
for storage. But it is and Client Storage worked.
Now I tried to enter this via application.cfm:
Then it is contrary to the definition via Server Administrator. The
configuration above produced no error, but also produced no entries in the
database. If I set "clientmanagement=“yes”
clientstorage=“efactum_clientscope” lucee tries to setup the database
(which already exists) and sends the following message:
Lucee 5.1.0.34 Error (database)
Message
Detail Der clob-Datentyp für die Spalte, den Parameter oder die Variable
Nr. ‘4’ wurde nicht gefunden.
SQL CREATE TABLE dbo.cf_client_data (expires varchar(64) NOT NULL, cfid
varchar(64) NOT NULL, name varchar(255) NOT NULL, data clob NOT NULL)
I’m using MS SQLServer 11.0.6020.0.
I tried to switch the datasource typ in lucee: Microsoft SQL Server (JDBC4
- Vendor Microsoft) or jTDS (MSQL and Sybase) = same problem. The
datasource typ makes no difference.
Any ideas?
Greetings
Michael
I’ve created an issue in the issue-tracker:
[LDEV-1131] - Lucee Montag, 2. Januar 2017 17:51:50 UTC+1 schrieb Michael Vornkahl:
Hi,
I have some strange findings if I try to active session/client storage in
a database:
I have setup a datasource ‘efactum_clientscope’ in server administrator:
Under Lucee 5.1.0.34 it is possible to set the Client Storage in server
administrator to efactum_clientscope. But when I tried to set the Session
Storage to ‘efactum_clientscope’ I got the error: Datasource is not setup
for storage. But it is and Client Storage worked.
Now I tried to enter this via application.cfm:
Then it is contrary to the definition via Server Administrator. The
configuration above produced no error, but also produced no entries in the
database. If I set "clientmanagement=“yes”
clientstorage=“efactum_clientscope” lucee tries to setup the database
(which already exists) and sends the following message:
Lucee 5.1.0.34 Error (database)
Message
Detail Der clob-Datentyp für die Spalte, den Parameter oder die Variable
Nr. ‘4’ wurde nicht gefunden.
SQL CREATE TABLE dbo.cf_client_data (expires varchar(64) NOT NULL, cfid
varchar(64) NOT NULL, name varchar(255) NOT NULL, data clob NOT NULL)
I’m using MS SQLServer 11.0.6020.0.
I tried to switch the datasource typ in lucee: Microsoft SQL Server
(JDBC4 - Vendor Microsoft) or jTDS (MSQL and Sybase) = same problem. The
datasource typ makes no difference.
Any ideas?
Greetings
Michael
Hi Michael… I noticed the same thing and raised ticket
https://luceeserver.atlassian.net/browse/LDEV-1089
Simon