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
