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]