Uuppss! Thanks a lot :-)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jasha Joachimsthal Sent: Wednesday, September 17, 2008 12:07 PM To: Hippo CMS development public mailinglist Subject: RE: [HippoCMS-dev] HCA manager - package.jdo There seems to be a typo in hca.jpox.identifiercase=LowwerCase ^^ Jahsa > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Biba > Sent: woensdag 17 september 2008 12:05 > To: 'Hippo CMS development public mailinglist' > Subject: RE: [HippoCMS-dev] HCA manager - package.jdo > > 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 > > ******************************************** 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
