Error log
[INFO] task-segment: [jetty:run-war] [INFO] ------------------------------------------------------------------------ [INFO] Preparing jetty:run-war Downloading: http://repo1.maven.org/maven2/com/enterprisedt/edtFTPj/2.1.0/edtFTP j-2.1.0.pom [INFO] Unable to find resource 'com.enterprisedt:edtFTPj:pom:2.1.0' in repositor y central (http://repo1.maven.org/maven2) [INFO] [aspectj:compile {execution: default}] [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}] [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}] [INFO] [resources:resources {execution: default-resources}] [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 64 resources [INFO] Copying 2 resources [INFO] Copying 99 resources [INFO] Copying 276 resources [INFO] Copying 276 resources [INFO] [compiler:compile {execution: default-compile}] [INFO] Compiling 2 source files to D:\Eclipse Projects\cypruss00\target\classes [INFO] [resources:testResources {execution: default-testResources}] [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 18 resources [INFO] Copying 11 resources [INFO] Preparing hibernate3:hbm2ddl [WARNING] Removing: hbm2ddl from forked lifecycle, to prevent recursive invocati on. [INFO] [aspectj:compile {execution: default}] [INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}] [INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}] [INFO] [resources:resources {execution: default-resources}] [INFO] Using 'UTF-8' encoding to copy filtered resources. [INFO] Copying 64 resources [INFO] Copying 2 resources [INFO] Copying 99 resources [INFO] Copying 276 resources [INFO] Copying 276 resources [INFO] Copying 276 resources [INFO] Copying 276 resources [INFO] [hibernate3:hbm2ddl {execution: default}] [INFO] Configuration XML file loaded: file:/D:/Eclipse%20Projects/cypruss00/src/ main/resources/hibernate.cfg.xml [INFO] Configuration XML file loaded: file:/D:/Eclipse%20Projects/cypruss00/src/ main/resources/hibernate.cfg.xml [INFO] Configuration Properties file loaded: D:\Eclipse Projects\cypruss00\targe t\classes\jdbc.properties create table AppFileManagerGroup (id bigint not null auto_increment, afmDesc var char(255), afmName varchar(255), afmTitle varchar(255), details1 varchar(255), d etails2 varchar(255), details3 varchar(255), remark varchar(255), singleUploadLi mit bigint, status varchar(255), upladType varchar(255), uploadDate datetime, up loadLimit bigint, uploadedBy varchar(255), primary key (id)) ENGINE=InnoDB; create table FileData (id bigint not null auto_increment, fileData longblob, fil eID bigint, fileName varchar(255), primary key (id)) ENGINE=InnoDB; create table FileManager (id bigint not null auto_increment, details1 varchar(25 5), details2 varchar(255), details3 varchar(255), fdesc varchar(255), fgroup var char(255), filesize float, filetype varchar(255), fname varchar(255), isdirector y varchar(255), link varchar(255), parentid bigint, remark varchar(255), status varchar(255), uploadDate datetime, uploadedBy varchar(255), uploadtype varchar(2 55), usergroup varchar(255), primary key (id)) ENGINE=InnoDB; create table ReportColumn (id bigint not null auto_increment, columnDatatype var char(255), dataStyleId bigint, displaySequence integer, displayflag integer, emp tyRow integer, extraField1 varchar(255), extraField2 varchar(255), extraField3 v archar(255), groupFlag integer, groupQurey varchar(255), groupType integer, head erStyleId bigint, remark varchar(255), reportId bigint, reportName varchar(255), reportNameKey varchar(255), reportTitle varchar(255), total integer, updateDate datetime, width integer, primary key (id)) ENGINE=InnoDB; create table ReportColumnGroup (id bigint not null auto_increment, columnId bigi nt, emptyRow integer, extraField1 varchar(255), groupQurey varchar(255), groupTi tleStyleId bigint, groupType integer, groupfooterStyleId bigint, remark varchar( 255), reportId bigint, title varchar(255), primary key (id)) ENGINE=InnoDB; create table ReportInfo (id bigint not null auto_increment, crosstabColumns varc har(800), crosstabRows varchar(800), crosstabStatus varchar(1), defaultStyleGrou pid bigint not null, extraField1 varchar(255), extraField2 varchar(255), extraFi eld3 varchar(255), initialLoading integer, jrxmlTemplate varchar(255), orientati on integer, pagesize integer, pdfTemplate varchar(200), query varchar(1000), rep ortFramework varchar(100), reportfooter varchar(300), reportheader varchar(300), reportname varchar(100) not null, reportsubtitle varchar(200), reportsummery va rchar(400), reporttitle varchar(200), rtfTemplate varchar(200), tableinfo varcha r(200), updateDate datetime, xlsTemplate varchar(200), primary key (id), unique (reportname)) ENGINE=InnoDB; create table ReportParameter (id bigint not null auto_increment, javascript varc har(255), paramAction varchar(255), paramData varchar(255), parameterDatatype va rchar(255), parameterName varchar(255), parameterType varchar(255), required int eger, primary key (id), unique (parameterName)) ENGINE=InnoDB; create table ReportParameterMap (reportId bigint not null, parameterId bigint no t null, primary key (reportId, parameterId)) ENGINE=InnoDB; create table ReportStyle (id bigint not null auto_increment, bgcolr varchar(255) , extraField1 varchar(255), fontsize float not null, fonttype varchar(255), grou pId bigint, name varchar(255), textcolur varchar(255), primary key (id)) ENGINE= InnoDB; create table ReportStyleGroup (id bigint not null auto_increment, name varchar(2 55), relatedId bigint, remark varchar(255), primary key (id)) ENGINE=InnoDB; create table Variables (id bigint not null auto_increment, var_group varchar(255 ), var_key varchar(255), var_value varchar(255), primary key (id)) ENGINE=InnoDB ; create table app_user (id bigint not null auto_increment, account_expired bit no t null, account_locked bit not null, address varchar(150), city varchar(50), cou ntry varchar(100), postal_code varchar(15), province varchar(100), credentials_e xpired bit not null, email varchar(255) not null unique, account_enabled bit, fi rst_name varchar(50) not null, last_name varchar(50) not null, password varchar( 255) not null, password_hint varchar(255), phone_number varchar(255), username v archar(50) not null unique, version integer, website varchar(255), primary key ( id)) ENGINE=InnoDB; create table role (id bigint not null auto_increment, description varchar(64), n ame varchar(20), primary key (id)) ENGINE=InnoDB; create table user_role (user_id bigint not null, role_id bigint not null, primar y key (user_id, role_id)) ENGINE=InnoDB; alter table ReportColumn add index FK122BB1CACDF47920 (id), add constraint FK122 BB1CACDF47920 foreign key (id) references ReportInfo (id); alter table ReportColumnGroup add index FKF74BE2D5CDF47920 (id), add constraint FKF74BE2D5CDF47920 foreign key (id) references ReportInfo (id); alter table ReportParameterMap add index FKC60FA4679E9E2536 (parameterId), add c onstraint FKC60FA4679E9E2536 foreign key (parameterId) references ReportParamete r (id); alter table ReportParameterMap add index FKC60FA467B4805154 (reportId), add cons traint FKC60FA467B4805154 foreign key (reportId) references ReportInfo (id); alter table user_role add index FK143BF46A4AB10C3D (role_id), add constraint FK1 43BF46A4AB10C3D foreign key (role_id) references role (id); alter table user_role add index FK143BF46AEFDBD01D (user_id), add constraint FK1 43BF46AEFDBD01D foreign key (user_id) references app_user (id); [WARNING] 20 errors occurred while performing <hbm2ddl>. [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'appfilemanagergroup' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'filedata' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'filemanager' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'reportcolumn' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'reportcolumngroup' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'reportinfo' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'reportparameter' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'reportparametermap' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'reportstyle' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'reportstylegroup' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'variables' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'app_user' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'role' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Tab le 'user_role' already exists [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Dup licate key name 'FK122BB1CACDF47920' [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Dup licate key name 'FKF74BE2D5CDF47920' [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Dup licate key name 'FKC60FA4679E9E2536' [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Dup licate key name 'FKC60FA467B4805154' [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Dup licate key name 'FK143BF46A4AB10C3D' [ERROR] Error #1: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Dup licate key name 'FK143BF46AEFDBD01D' [INFO] [compiler:testCompile {execution: default-testCompile}] [INFO] Nothing to compile - all classes are up to date [INFO] [dbunit:operation {execution: test-compile}] 94 [main] INFO org.dbunit.database.DatabaseDataSet - database name=MySQL database version=5.1.51-community database major version=5 database minor version=1 jdbc driver name=MySQL-AB JDBC Driver jdbc driver version=mysql-connector-java-5.1.10 ( Revision: ${svn.Revisi on} ) jdbc driver major version=5 jdbc driver minor version=1 94 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTab leMetaData. Corrected table name: oldValue=FileData newValue=filedata 109 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=ReportColumn newValue=reportcolumn 109 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=ReportColumnGroup newValue=reportcol umngroup 109 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=ReportParameter newValue=reportparam eter 109 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=ReportInfo newValue=reportinfo 109 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=ReportStyleGroup newValue=reportstyl egroup 109 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=ReportStyle newValue=reportstyle 125 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=AppFileManagerGroup newValue=appfile managergroup 125 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=FileManager newValue=filemanager 125 [main] INFO org.dbunit.util.SQLHelper - class org.dbunit.database.DatabaseTa bleMetaData. Corrected table name: oldValue=Variables newValue=variables [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Error executing database operation: CLEAN_INSERT Embedded error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Colum n 'id' specified twice [INFO] ------------------------------------------------------------------------ [INFO] Trace org.apache.maven.lifecycle.LifecycleExecutionException: Error executing database operation: CLEAN_INSERT at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(Defa ultLifecycleExecutor.java:719) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLi fecycle(DefaultLifecycleExecutor.java:556) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.forkProjectLifecy cle(DefaultLifecycleExecutor.java:1205) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.forkLifecycle(Def aultLifecycleExecutor.java:1038) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(Defa ultLifecycleExecutor.java:643) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandalone Goal(DefaultLifecycleExecutor.java:569) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(Defau ltLifecycleExecutor.java:539) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHan dleFailures(DefaultLifecycleExecutor.java:387) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegmen ts(DefaultLifecycleExecutor.java:348) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLi fecycleExecutor.java:180) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:328) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138) at org.apache.maven.cli.MavenCli.main(MavenCli.java:362) at org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:6 0) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430) at org.codehaus.classworlds.Launcher.main(Launcher.java:375) Caused by: org.apache.maven.plugin.MojoExecutionException: Error executing datab ase operation: CLEAN_INSERT at org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:109 ) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPlugi nManager.java:490) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(Defa ultLifecycleExecutor.java:694) ... 21 more Caused by: org.dbunit.DatabaseUnitException: com.mysql.jdbc.exceptions.jdbc4.MyS QLSyntaxErrorException: Column 'id' specified twice at org.dbunit.ant.Operation.execute(Operation.java:199) at org.codehaus.mojo.dbunit.OperationMojo.execute(OperationMojo.java:100 ) ... 23 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Column 'id ' specified twice at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct orAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC onstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:2077) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1356) at org.dbunit.database.statement.SimplePreparedStatement.addBatch(Simple PreparedStatement.java:80) at org.dbunit.database.statement.AutomaticPreparedBatchStatement.addBatc h(AutomaticPreparedBatchStatement.java:70) at org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOper ation.java:195) at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.ja va:79) at org.dbunit.operation.TransactionOperation.execute(TransactionOperatio n.java:78) at org.dbunit.ant.Operation.execute(Operation.java:195) ... 24 more [INFO] ------------------------------------------------------------------------ [INFO] Total time: 13 seconds [INFO] Finished at: Sun Nov 07 09:34:20 IST 2010 [INFO] Final Memory: 42M/63M [INFO] ------------------------------------------------------------------------ -- View this message in context: http://appfuse.547863.n4.nabble.com/Error-while-adding-new-model-tp3030580p3030582.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net For additional commands, e-mail: users-h...@appfuse.dev.java.net