Hi Jasha, I have these lines in my build.properties file:
# Schema creation hca.jpox.autocreatetables=true hca.jpox.autocreateschema=true hca.jpox.autocreatecolumns=true hca.jpox.autocreateconstraints=true # Validation hca.jpox.validateTables=false hca.jpox.validateColumns=false hca.jpox.validateConstraints=false # Misc hca.jpox.identifiercase=LowwerCase # Isolation levels hca.jpox.transactionIsolation=READ_COMMITTED hca.jpox.poid.transactionIsolation=READ_COMMITTED Still, I have to do everything manually in my database :-/ But, what about package.jdo files? Thanks for fast response, Biba -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jasha Joachimsthal Sent: Wednesday, September 17, 2008 12:00 PM To: Hippo CMS development public mailinglist; Hippo Helpdesk Subject: RE: [HippoCMS-dev] HCA manager - package.jdo Hi Biba, We've added a few new columns in the latest HCA release. Is hca.jpox.autocreatecolumns set to true? Also hca.jpox.validateColumns should be false when using MySQL. Regards, Jasha Joachimsthal [EMAIL PROTECTED] - [EMAIL PROTECTED] www.onehippo.com Amsterdam - Hippo B.V. Oosteinde 11 1017 WT Amsterdam +31(0)20-5224466 San Francisco - Hippo USA Inc. 101 H Street, suite Q Petaluma CA 94952-3329 +1 (707) 773-4646 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Biba > Sent: woensdag 17 september 2008 11:54 > To: 'Hippo CMS development public mailinglist'; Hippo Helpdesk > Subject: [HippoCMS-dev] HCA manager - package.jdo > > Hello Hippo, > > > > Several problems have occurred with using HCA and mysql :-/. > > I am using hippo-community-apps-core-2.02.01.jar. > > > > 1. package.jdo files defines some fields like: > > <field name="repositoryurl" persistence-modifier="persistent"> > > <column length="1000" jdbc-type="VARCHAR"/> > > </field> > > This length causes mysql to make column of type 'text' which > has length 65535. Because of that I get an error: > > > > org.jpox.store.rdbms.exceptions.WrongPrecisionException: > Wrong precision for column hca_interests.property_value : was > 65535 (according to the JDBC > driver) but should be 255 (based on the MetaData definition). > > > > I have fixed this temporarily by changing package.jdo file like: > > <field name="repositoryurl" persistence-modifier="persistent"> > > <column length="65535" jdbc-type="VARCHAR"/> > > </field> > > Maybe I could this too: > > <field name="repositoryurl" persistence-modifier="persistent"> > > <column jdbc-type="LONGVARCHAR"/> > > </field> > > > > > > My question is how could I fix this problem permanently? > > > > 2. I got error for missing columns in three tables, but I > can't find > those fields in jar(?!). I have added them to my tables, and > the error disappeared, but why I have to do that? Error: > > org.jpox.store.rdbms.exceptions.MissingColumnException: > Required columns missing from table "hca_notifiers" : > interest_comparison_type, author. > Perhaps your MetaData is incorrect, or you havent enabled > "org.jpox.autoCreateColumns". > > org.jpox.store.rdbms.exceptions.MissingColumnException: > Required columns missing from table "hca_interest_properties" > : csv_field. Perhaps your MetaData is incorrect, or you > havent enabled "org.jpox.autoCreateColumns". > > org.jpox.store.rdbms.exceptions.MissingColumnException: > Required columns missing from table "hca_interest_categories" > : display_interests_in_mail. > Perhaps your MetaData is incorrect, or you havent enabled > "org.jpox.autoCreateColumns". > > > > 3. I have also had problem because of jdo2 default length > of 256. But I > added > > <prop key="org.jpox.rdbms.stringDefaultLength">255</prop>, so > I fixed that. > > > > Could anyone give me some idea what should I do with > mentioned package.jdo files? > > > > Thanks in advance, > > Biba > > __________________________________________________________ > > Biljana Boskovic > Software Developer > Levi9 Global Sourcing > * +381 (0)64 8509308 > * E-mail: [EMAIL PROTECTED] > * Mail : Zorana Djindjica 9, 18000 Nis, Serbia and Montenegro > http://www.levi9.com/ > > > > ******************************************** > Hippocms-dev: Hippo CMS development public mailinglist > > Searchable archives can be found at: > MarkMail: http://hippocms-dev.markmail.org > Nabble: http://www.nabble.com/Hippo-CMS-f26633.html > > ******************************************** Hippocms-dev: Hippo CMS development public mailinglist Searchable archives can be found at: MarkMail: http://hippocms-dev.markmail.org Nabble: http://www.nabble.com/Hippo-CMS-f26633.html ******************************************** Hippocms-dev: Hippo CMS development public mailinglist Searchable archives can be found at: MarkMail: http://hippocms-dev.markmail.org Nabble: http://www.nabble.com/Hippo-CMS-f26633.html
