Error was: java.sql.SQLException: Duplicate column name

[Mathius Allo]

  Hi All,
   
  I have commented out the following line under localmysql datasource but 
everytime I run my application, it seems it always try to re-create those 
existing tables. How to avoid this scenario?
   
  <!--
  <read-data reader-name="seed"/>
  <read-data reader-name="demo"/>
  <read-data reader-name="ext"/>
  -->
   
  17391[       DatabaseUtil.java:821:INFO ] - non-nullable column      [true]*
17391[       DatabaseUtil.java:858:INFO ] Getting Table Info From Database
90110[       DatabaseUtil.java:993:INFO ] Getting Column Info From Database
97156[       DatabaseUtil.java:1145:ERROR] Error getting column meta data for 
Error was:java.sql.SQLException: Can't create/write to file 
'C:\WINDOWS\TEMP\#sql_a18_0.MYI' (Errcode: 13). Not checking columns.
97156[       DatabaseUtil.java:335:WARN ] Field [acctgTransId] of entity 
[AcctgTrans] is missing its corresponding column [ACCTG_TRANS_ID] (and it is a 
PRIMARY KEY FIELD)
97203[       DatabaseUtil.java:1708:INFO ] [addColumn] sql=ALTER TABLE 
ACCTG_TRANS ADD ACCTG_TRANS_ID VARCHAR(20) CHARACTER SET latin1 COLLATE 
latin1_general_cs
97235[       DatabaseUtil.java:1736:INFO ] [addColumn] sql failed, trying 
sql2=ALTER TABLE ACCTG_TRANS ADD COLUMN ACCTG_TRANS_ID VARCHAR(20) CHARACTER 
SET latin1 COLLATE latin1_general_cs
98625[       DatabaseUtil.java:344:ERROR] Could not add column [ACCTG_TRANS_ID] 
to table [ACCTG_TRANS]: SQL Exception while executing the following:
ALTER TABLE ACCTG_TRANS ADD ACCTG_TRANS_ID VARCHAR(20) CHARACTER SET latin1 
COLLATE latin1_general_cs
Error was: java.sql.SQLException: Duplicate column name 'ACCTG_TRANS_ID'
  

       
---------------------------------
You snooze, you lose. Get messages ASAP with AutoCheck
 in the all-new Yahoo! Mail Beta.