JBoss and Petstore using Sybase Datasource

[syedaf]

Hi,

I am using JBOSS to run Petstore with Sybase as the datasource. My sybase-ds.xml is properly configured. However, when deploying the entity beans, I get this error:

org.jboss.deployment.DeploymentException: Error while creating table LineItemEJB; - nested throwable: (com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near 'BINARY'.
)
......

Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near 'BINARY'

Please help!

Thanks,
Arshad

[weston.price]

This is a JDBC level excpetion denoting that you have a problem with your SQL.

Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near 'BINARY'

Please note:

http://www.jboss.com/index.html?module=bb&op=viewtopic&t=73505

You either need to verify your SQL or post this to the JDBC forums.