SC Store session in Database is not Working


I tried storing the session to a database in the production (online) environment based on your blog but failed. (…s-on-database/)

I hope scriptcase would have a more detailed tutorial on this like a complete example with apps and mysql scripts.

"Utilizing database session ( production:

Utilizing the Scriptcase on production, it is necessary to have in your database a form to keep all sessions of the publish application.

Bellow a script of a Create on MySQL:

CREATE TABLE sc_tbsess (
sess_id varchar(32) NOT NULL default ?,
sess_last_access varchar(32) default NULL,
sess_data text,
PRIMARY KEY (sess_id)

Connection(PROD): Accomplished connection on production name

Form Name: Inform the name of the form where you will keep all the session information

Scheme Name: Inform the name of the Schema from database ( Postgres, SQLServer etc)

  • Indicates the session utilized on the Application.

Session Register on DataBase."

Were you able to get the session data to be stored in the database? In our case we are using Oracle (which may add to the difficulty of getting the feature to work). Overall, our experience has been very similar to yours: the little documentation available for this feature is not current or insufficient.