|
| 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 | |
| |
| |
|
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
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|