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)

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: JBossAS-4.2.2.GA
    • Fix Version/s: None
    • Component/s: JMS (JBossMQ)
    • Labels:
      None

      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                miclark Mike Clark
                Reporter:
                luc.texier Luc Texier
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: