A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Arduino in Action
this week in the
A special promo:
Enter your blog post or vote on a blogger to be featured in an upcoming Journal
Create Table is not allowed inside transaction Exception while executing syabse procedure
Joined: Jan 13, 2009
Feb 08, 2011 21:54:18
I have some problem at hand while using "Sybase Procedure".
I am suppose to do something like this:
1) Start a transaction from
code (by means of con.setAutocommit(false))
2) Call X Procedure
3) Call Y Procedure
4) Commit/Rollback Transaction.
Now problem is that Procedure Y was ever been developed, and it is "creating temp. table".
because of which i am getting exception that "Create Table is not allowed inside transaction".
Is anyone came across this problem, and is anyone aware of the solution for this problem.
Note: 1) Using "ddl in tran" to true is not an option for me
2) Above sequence of statement is important.
Your help is greatly appreciated.
, If you need more info. i will let you know.
Joined: Apr 14, 2004
Feb 09, 2011 02:10:49
DDL is not transactional, hence the error. So you can't do what you are trying to do (on any database, not just Sybase).
Perhaps you could explain why you need the temporary table? Maybe there is a way round this.
Joined: Jan 13, 2009
Feb 14, 2011 05:38:43
sorry for late reply.
was really busy with code delivery
anyways DBA just realised that we could write a small procedure to serve our purpose.
and we are no longer using the procedure having temp. tables.
I agree. Here's the link:
subject: Create Table is not allowed inside transaction Exception while executing syabse procedure
How to update or insert 1 million record to table B based on table A faster?
java.lang.OutOfMemoryError on very long time consuming usecase
Set Chained OFF error while executing from my Bean
Problem retrieving output from stored procedured
Global temporary table
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013