why dont you give us the SQL statement so we can tell you whats wrong...(please leave out any Sybase specific constructs)
handing us bits at a time will only exacerbate the problem you are experiencing and delay a solution
did you follow the syntax for a sybase UNION?
Martin
______________________________________________
Verzicht und Vertraulichkeitanmerkung
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
> To: users_at_glassfish.java.net
> Subject: Re: Support for Sybase as JMS broker message persistence ...
> From: forums_at_java.net
> Date: Wed, 13 Mar 2013 03:58:36 -0500
>
> Sybase is not supported by Glassfish. If you'll create new database schema
> for Sybase in properties file (like here [1] -sorry, this isn't in english),
> you will have problem with imq broker implementation. For example with class
> com.sun.messaging.jmq.jmsserver.persist.jdbc.DestinationDAOImpl where is
> defined select hereby: selectDstsByBrokerSQL = new StringBuffer(128) 154
> .append( "SELECT " ) 155 .append( DESTINATION_COLUMN ) 156 .append( " FROM "
> ).append( tableName ) 157 .append( " WHERE " ) 158 .append( ID_COLUMN ) 159
> .append( " IN (SELECT " ).append( ID_COLUMN ) 160 .append( " FROM " ).append(
> tableName ) 161 .append( " WHERE " ).append( IS_LOCAL_COLUMN ).append( " = 0"
> ) 162 .append( " UNION SELECT dstTbl." ).append( ID_COLUMN ) 163 .append( "
> FROM " ).append( tableName ).append( " dstTbl, " ) 164 .append(
> dbMgr.getTableName( StoreSessionDAO.TABLE_NAME_PREFIX ) ) 165 .append( "
> sesTbl WHERE sesTbl." ) 166 .append( StoreSessionDAO.BROKER_ID_COLUMN
> ).append( " = ?" ) 167 .append( " AND sesTbl." ).append(
> StoreSessionDAO.ID_COLUMN ) 168 .append( " = dstTbl." ).append(
> STORE_SESSION_ID_COLUMN ) 169 .append( ")" ) 170 .toString(); and it grows up
> problem in Sybase: " Incorrect syntax near the keyword 'UNION'"
>
> [1] http://blog.prodejna.biz/2013/03/glassfish-jms-broker-perzistujici.html
>
> --
>
> [Message sent by forum member 'javacentrum']
>
> View Post: http://forums.java.net/node/886242
>
>