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

Reply via email to