Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-1546

HHH-3685 - Sybase - SchemaExport cannot create stored procedures in chained transaction mode

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 4.2.0.GA_CP05, 4.3.0.GA_CP03, 4.2.0.GA_CP06, 4.3.0.GA_CP04
    • 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 Text:
      Hide
      <para>When using Sybase, <literal>SchemaExport</literal> cannot be used to create stored procedures while in chained transaction mode. The suggested workaround for this case is to add the following code after the new stored procedure definition:</para><programlisting language="XML">&lt;database-object&gt;
         &lt;create&gt;sp_procxmode paramHandling, &apos;chained&apos;&lt;/create&gt;
         &lt;drop/&gt;
      &lt;/database-object&gt;</programlisting>
      Show
      <para>When using Sybase, <literal>SchemaExport</literal> cannot be used to create stored procedures while in chained transaction mode. The suggested workaround for this case is to add the following code after the new stored procedure definition:</para><programlisting language="XML">&lt;database-object&gt;    &lt;create&gt;sp_procxmode paramHandling, &apos;chained&apos;&lt;/create&gt;    &lt;drop/&gt; &lt;/database-object&gt;</programlisting>
    • Release Notes Docs Status:
      Not Required

      Gliffy Diagrams

        Attachments

          Activity

            People

            • Assignee:
              gbadner Gail Badner
              Reporter:
              gbadner Gail Badner
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: