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

[Luc Texier (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBAS-5245?page=comments#action_12400447 ] 
            
Luc Texier commented on JBAS-5245:
----------------------------------

Just to make sure everyone gets the point.

EAP 4.2 is shipped with JBossMQ

EAP 4.3 is shipped with JBoss Messaging which provides another set of descriptor examples which seem to work fine with ASA.

> JBossMQ services: table creation fails with Sybase Adaptive Server Anywhere (ASA)
> ---------------------------------------------------------------------------------
>
>                 Key: JBAS-5245
>                 URL: http://jira.jboss.com/jira/browse/JBAS-5245
>             Project: JBoss Application Server
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: JMS service
>    Affects Versions: JBossAS-4.2.2.GA
>            Reporter: Luc Texier
>         Assigned To: 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: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira