[jboss-jira] [JBoss JIRA] Resolved: (JBAS-5245) JBossMQ services: table creation fails with Sybase Adaptive Server Anywhere (ASA)

[Mike Clark (JIRA)]

     [ https://jira.jboss.org/browse/JBAS-5245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mike Clark resolved JBAS-5245.
------------------------------

    Resolution: Done


No activity, closing.

> JBossMQ services: table creation fails with Sybase Adaptive Server Anywhere (ASA)
> ---------------------------------------------------------------------------------
>
>                 Key: JBAS-5245
>                 URL: https://jira.jboss.org/browse/JBAS-5245
>             Project: JBoss Application Server
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: JMS (JBossMQ)
>    Affects Versions: JBossAS-4.2.2.GA
>            Reporter: Luc Texier
>            Assignee: Mike Clark
>
> 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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira