seed data for primary cattagory table

[Pal Infocom Technologies-2]

please can anybody tell me where is seed data for the table (entity)
productCategory in product application  is located.

thanks for help....

[Ray Barlow]

You'll find most demo data (if not all) in the ecommerce data directory,
alternatively you should be able to search for "Demo*.xml" to find demo
data files and then again you can also do a text search for
"productCategory" or even the product category Id you know exists in the
demo data to narrow it down more.

Ray

amit charaya wrote:
> please can anybody tell me where is seed data for the table (entity)
> productCategory in product application  is located.
>
> thanks for help....
>
>  

[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.

[David E Jones]

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.

[Mathius Allo]

Hi David,
   
  Thanks for your feedback. I don't see those sql error anymore.
   
  Regards,
  Mathius

 
David E Jones <[hidden email]> wrote:
 
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?
>
> >  
>  
>  
>   -->
>
> 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.

       
---------------------------------
Fussy? Opinionated? Impossible to please? Perfect.  Join Yahoo!'s user panel and lay it on us.