com.sybase.jdbc2.jdbc.SybSQLException when using persistent sessions

Technote (FAQ)
Problem
Could not create database table: "sessions" com.sybase.jdbc2.jdbc.SybSQLException: The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'xxx' database.
Cause
This only occurs when using multi-row sessions. When using single-row sessions, the problem is not seen.

Also, when using multi-row sessions, the session is not persisted to the database, but it is with single-row sessions.
Solution
This problem can be fixed by issuing the Sybase SQL commands for each database <db>, where a session table is located:

>use master

>go

>sp_dboption <db>, "ddl in tran", true

>go

<message>

>use <db>

>go

>checkpoint

>go











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, Administrative Console (all non-scripting)
Operating system(s): Solaris
Software version: 3.5.1
Reference #: 1175355
IBM Group: Software Group
Modified date: 2004-07-27