Need help with Sybase configuration to resolve “Incorrect Syntax”

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Need help with Sybase configuration to resolve “Incorrect Syntax”

Ram A
It appears that I am missing some dbunit/hibernate configuration as the statements
generated have sytax errors.

I have created my app using the command on Appfuse QuickStart page.
Updated the pom.xml to connect to Sybase database with the following properties.

Thanks for your help.


<![CDATA[jdbc:sybase:Tds:x:n/d?SQLINITSTRING=set quoted_identifier off]]>



Error with the command: mvn clean install
    drop table user_role;
[ERROR] HHH000389: Unsuccessful: drop table user_role
[ERROR] Incorrect syntax near ';'.

    create table app_user (
        id numeric(19,0) identity not null,
        primary key (id)
[ERROR] HHH000389: Unsuccessful: create table app_user …
[ERROR] Incorrect syntax near ';'.

Error with the command: mvn jetty:run
[ERROR] Failed to execute goal org.codehaus.mojo:dbunit-maven-plugin:1.0-beta-3:operation (test-compile) on project wp: Error executing database operation: CLEAN_INSERT: The method com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getDatabaseMajorVersion() has not been completed and should not be called. -> [Help 1]