AutoCommit Option in JDBC Attributes or Operations

An error message displays in Unwired WorkSpace if Auto Commit is not selected. For example, create a temporary table named “tempstores”in this stored procedure:

CREATE PROCEDURE dbo.ase_sp
AS 
BEGIN
	create table tempstores (temp_row_id integer, temp_id integer )
	insert tempstores select 1, 1 
    insert tempstores select 2, 2 
    insert tempstores select 3, 3 
    select temp_row_id, temp_id from tempstores group by temp_row_id
    drop table tempstores
END

If this stored procedure is used as a data source to model an MBO (attributes and operations), when you preview an operation, this error message displays:

The 'CREATE TABLE' command is not allowed within a multi-statement transaction
in the 'tempdb' database.