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
|  
Report Content as Inappropriate

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.
Ram

<properties>
        <amp.genericCore>true</amp.genericCore>
        <amp.fullSource>false</amp.fullSource>
        <dao.framework>hibernate</dao.framework>
                <hibernate.dialect>org.hibernate.dialect.SybaseDialect</hibernate.dialect>       
        <db.name>db</db.name>
        <web.framework>spring</web.framework>
        <appfuse.version>3.5.0</appfuse.version>
        <java.version>1.8</java.version>

        <jdbc.groupId>sybase</jdbc.groupId>
        <jdbc.artifactId>jconn3</jdbc.artifactId>
        <jdbc.version>6.0.1</jdbc.version>
        <jdbc.driverClassName>com.sybase.jdbc3.jdbc.SybDriver</jdbc.driverClassName>
        <jdbc.url>
               
<![CDATA[jdbc:sybase:Tds:x:n/d?SQLINITSTRING=set quoted_identifier off]]>

        </jdbc.url>

        <jdbc.username>user</jdbc.username>
        <jdbc.password>pw</jdbc.password>
</properties>

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]
Loading...