Those are just the data loading entries, nothing to do with the database meta
data.
To tell it not to add missing tables, etc just set the add-missing attribute to
false.
-David
Mathius Allo wrote:
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.
