Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-8302

some tests hanging on Sybase 16 due to issues with temporary tables

XMLWordPrintable

      Hibernate: 
            insert 
            into
                #PERSON
                select
                    insertorde0_.ID as ID 
                from
                    PERSON insertorde0_
        12:43:06,576  WARN SqlExceptionHelper:129 - SQL Error: 208, SQLState: 42000
        12:43:06,577 ERROR SqlExceptionHelper:131 - #PERSON not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
    

    this occurs in some tests running on sybase 16, while it works fine on sybase 15.7
    affected tests include at least:

    • InsertOrderingWithJoinedTableInheritance
    • FilterInheritanceTest

    The hang occurs because this exception is not properly handled in the tests, leaving some sessions open because the code which closes sessions is not executed then.

          gbadner@redhat.com Gail Badner (Inactive)
          jmartisk@redhat.com Jan Martiska
          Votes:
          0 Vote for this issue
          Watchers:
          2 Start watching this issue

            Created:
            Updated:
            Resolved: