Broadleaf Commerce Discussion Forums

Hi guys,

I'm new to broadleaf and i am trying to make it run in eclipse. I have created a maven project and have followed the steps as given in the following url:http://wiki.broadleafcommerce.org/confluence/display/BLC16/Instructions+for+Eclipse
After all the files were imported i edited the build.xml file so that my maven.home points to my maven directory and then i ran a maven install on my parent pom.xml. Dint face any issues till there however, when i did an ant build on the build.xml of the site-war file it started processing till it hung up and gave me the following:
[artifact:mvn] [INFO] Started Jetty Server
[artifact:mvn] 2012-06-15 11:39:59.309:INFO::Started SelectChannelConnector@0.0.0.0:8080
[artifact:mvn] [INFO] Starting scanner at interval of 10 seconds.
Need some help here guys.

Thanks

Hi aldrino24,

what do you exactly mean when you say "it hung up"? The messages you posted indicate that the server started successfully and is now waiting for connections. I would expect that you can now open your browser and point it to http://localhost:8080/mycompany to open the skeleton shop.

Regards,
Alex

Hi Alex,

When i go to this link : http://localhost:8080/mycompany. It gives me an Error 500
HTTP ERROR 500
Problem accessing /mycompany/. Reason:

Unable to retrieve id range for org.broadleafcommerce.profile.core.domain.Customer

Caused by:
java.lang.RuntimeException: Unable to retrieve id range for org.broadleafcommerce.profile.core.domain.Customer
......(some more lines)
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
......(some more lines)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
......(some more lines)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: BLC_ID_GENERATION
......(some more lines)

I am new to Hibernate and Spring so i cant really figure out what the problem could possibly be.

Jepp - that problem is somewhat familiar to me. Please try the workaround I described in this thread: http://forum.broadleafcommerce.org/viewtopic.php?f=15&t=561&sid=dede1201f491d5e42c1d8e9b8784ef50

That seems to happen sometimes when a new project is being created using Eclipse. The database then is not correctly initialized when starting the server, i.e. there are no tables in it. So you get that SQLGrammarException you see somewhere in your stacktrace. Not everyone encounters this problem. For example for me it's reproducable but my colleauge (using a very similar environment with the same software versions as I do) doesn't have it. I didn't research that any further because the workaround worked for me and now I can safely use Eclipse for development without any trouble.

Regards,
Alex

Thanx mate. Worked really well for me.

Regards,
Aldrin

I am also getting this error, what was the workaround for this.