Hello,
I'm really new to Spring (actually, to all the tecnologies involved in the project) and I have many doubts about the system. I need to change the default HQSQL database to a MySQL one with my data, trying to match the data model with my data.
I haven´t done any changes on the site, so I don't expect to work itself but at least a first preview of the index.
Yesterday, when I ran the Tomcat server, I got this error:
INFO: foreign keys: []
04-may-2011 16:02:30 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: indexes: []
04-may-2011 16:02:30 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: schema update complete
[ INFO] 16:02:33 RuntimeEnvironmentPropertiesConfigurer - Loading properties file from class path resource [config/bc/production.properties]
[ INFO] 16:02:33 RuntimeEnvironmentPropertiesConfigurer - Loading properties file from class path resource [config/bc/common.properties]
[DEBUG] 16:02:43 MergeXmlWebApplicationContext - Unable to locate LifecycleProcessor with name 'lifecycleProcessor': using default [org.springframework.context.support.DefaultLifecycleProcessor@19546ee]
04-may-2011 16:02:43 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'bl'
[ INFO] 16:02:43 SearchServiceCompassImpl - Rebuilding product index
[ERROR] 16:02:44 JobRunShell - Job DEFAULT.indexCreationJob threw an unhandled Exception:
org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'rebuildProductIndex' on target class [class $Proxy78] failed; nested exception is javax.persistence.PersistenceException: org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.broadleafcommerce.catalog.domain.ProductImpl.isMachineSortable
So I updated the database, changing all the values to TRUE in the IS_MACHINE_SORTABLE field. And it worked seamless, and I could ran the server and load the web on a browser.
So now, I have some questions: ¿What is this Product attribute for? ¿Why it doen't work, if there is a null value? There isn't a not null constraint on the HQSQL script. I'm sure I'm missing something else as I don't know neither Quartz nor Hibernate.
Thanks for all your help in advance
This forum is in readonly mode and serves as an archive of old information. All posting, registration and commenting abilities have been turned off. To get help, the Broadleaf team reguarly monitors the broadleaf-commerce tag on Stack Overflow so please ask your questions there.