Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-5245

JBossMQ services: table creation fails with Sybase Adaptive Server Anywhere (ASA)

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • None
    • JBossAS-4.2.2.GA
    • JMS (JBossMQ)
    • None
    • 0
    • 0% 0%

    Description

      the database is Sybase Adaptive Server Anywhere (ASA). The JDBC driver jConnect for JDBC 3.0 v6.0x

      2008-02-14 18:25:01,640 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Could not create table with SQL: CREATE TABLE dbo.JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER NULL, TXOP CHAR(1) NOT NULL, MESSAGEBLOB IMAGE NOT NULL, PRIMARY KEY (MESSAGEID, DESTINATION) ) LOCK DATAROWS
      com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -131: Syntax error near 'LOCK' on line 1
      at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
      at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
      at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
      at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
      at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
      at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(Unknown Source)
      at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
      at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown Source)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.createSchema(PersistenceManager.java:280)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1796)

      Note that those issues do NOT occur when these services are connected to Adaptive Server Enterprise (ASE)

      Note2: internal reference Issue #162081

      Attachments

        Activity

          People

            rhn-support-miclark Mike Clark
            luc.texier Luc Texier (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: