[JBPAPP-3030] CLONE -HHH-3685 - Sybase - SchemaExport cannot create stored procedures in chained transaction mode - JBoss Issue Tracker

XML

Word

Printable

Type: Bug
Status: Resolved (View Workflow)
Priority: Major
Resolution: Won't Fix
Affects Version/s: EAP 5.0.0.CR1, EAP 5.0.0.BETA, EAP 5.0.0.CR2, EAP 5.0.0.CR3, EAP 5.0.0.CR4 (FCS and BETA2), EAP 5.0.0.CR5, EAP 5.0.0
Fix Version/s: TBD
Component/s: Hibernate
Labels:
None

Affects:

Release Notes
Workaround:

Workaround Exists
Workaround Description:

Hide

A workaround is to add a <database-object> tag containing the command to change the stored procedure to chained mode. This tag needs to follow the tag that defines the new stored procedure.

For example, adding the following after the definition of paramHandling in the mapping for SybaseCustomSQLTest will change the paramHandling stored procedure so that it can be used in a transaction.

<database-object>
<create>
sp_procxmode paramHandling, 'chained'
</create>
<drop/>
</database-object>

Show
A workaround is to add a <database-object> tag containing the command to change the stored procedure to chained mode. This tag needs to follow the tag that defines the new stored procedure. For example, adding the following after the definition of paramHandling in the mapping for SybaseCustomSQLTest will change the paramHandling stored procedure so that it can be used in a transaction. <database-object> <create> sp_procxmode paramHandling, 'chained' </create> <drop/> </database-object>
Release Notes Docs Status:
Not Required

cloned to

JBPAPP-5551 Document - CLONE -HHH-3685 - Sybase - SchemaExport cannot create stored procedures in chained transaction mode