Sybase datasource: problem with temp table in stored proc

[ntjp]

I have the following issue:
my jrxml report calls a Sybase stored procedure which itself creates (and drops) some temporary table before returning the result dataset.

eg:
CREATE PROCEDURE mystoredproc
BEGIN
CREATE TABLE #MYRESULTS(COL1 INT)

INSERT INTO #MYRESULTS VALUES(1)

SELECT COL1 FROM #MYRESULTS

DROP TABLE #MYRESULTS

END

the stored procs works fine in ireport but when run from JasperServer, I'm getting the following error:
The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.
It seems like the problem is that the datasource wraps the stored proc call into a transaction.
The same problem can be reproduced from a DB front-end tool by explicitely wrapping the stored-proc call within a transaction:
begin transaction
exec mystoredproc
commit transaction

Hence my question is:

how to prevent in JasperServer the stored proc call of my sybase data-source from being wrapped into a transaction ?

 

Note: I'm using jtds 1.2.7 as database driver and my connection string is plain vanilla (jdbc:jtds:sybase://myserver:myport/mydatabase)

 

Regards

kb

 

[ntjp]

for whatever reason looks like wrapping the DB connection inside a JNDI pool solves the issue.

kb