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
