and see if this resolves the problem.
@sybase.com> wrote in message news:480e2854$1@forums-1-dub
> Hi Karthick,
> This sounds familiar and I think the problem is resolved. You never
> posted the
> exact jConnect version or provide jdbc details of your code like
> string, etc.
> I can't recall the original problem but it sounds familiar. Try this and
> see if it works.
> If not post a sample of the test so we can see what the code looks like.
> <Karthick> wrote in message news:firstname.lastname@example.org...
> We noticed if a stored procedure(in unchained mode) creating
> #temp tables is called inside a transaction scope, the
> transaction is failing to rollback the transactions. Instead
> it commits all the transaction.
> However, the same procedure when called from ISQL connection
> from a transaction scope errors out Error 277 < Number (277)
> Severity (16) There was a transaction active when exiting
> the stored procedure 'testcheckhash'. The temporary table
> '#tabletimeperiod' was dropped in this transaction either
> explicitly or implicitly. This transaction has been aborted
> to prevent database corruption.>
> Other required details:
> Database : Sybase ASE 12.5.3
> DB Server: Solaris
> Client : windows
> Java version : j2sdk1.4.2_05
> ISQL Code:
> begin tran
> insert into sometable values (10)
> exec testcheckhash
> commit tran
> --<Procedure code>
> create procedure testcheckhash
> CREATE TABLE #tabletimeperiod (timeperiod
> DROP TABLE #tabletimeperiod
> EXEC sp_procxmode 'dbo. testcheckhash','unchained'
> Same code when I execute from Java using jconn2.jar(Jconnect
> 5), I am getting no error instead the insert done on
> "sometable" doesnot get rolled back in the event of
> failure in the procedure.
> Can you let me know if any one else encountered this
> behavior and resolved it.
> Thanks in Advance,