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