> 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
> connection
> 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.

> -Paul

> <Karthick> wrote in message news:480de23f.532c.1681692777@sybase.com...
> 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
> as
>    Begin
>            CREATE TABLE #tabletimeperiod (timeperiod
> VARCHAR(12))
>            DROP TABLE #tabletimeperiod
>     End
> go
> 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,
> Karthick