Page 2 of 2

Re: Setting up broadleaf development environment without maven

Posted: Tue Nov 16, 2010 6:54 pm
by springgao
I originally deployed broadleafadmin with this data source,
<bean id="webDS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="org.hsqldb.jdbcDriver" />
<property name="url" value="jdbc:hsqldb:hsql://localhost/broadleaf;ifexists=true" />
<property name="username" value="sa" />
<property name="password" value="" />
</bean>
After deployed successfully, I visit this application by http://localhost:8080/broadleafadmin/ and log on this admin/blc_admin, it prompt the following error:
Error: [FaultEvent fault=[RPC Fault faultString="javax.persistence.PersistenceException : org.hibernate.exception.SQLGrammarException: could not execute query" faultCode="Server.Processing" faultDetail="null"] messageId="9AC8D62D-4196-C67E-E301-181AB6B8702C" type="fault" bubbles=false cancelable=true eventPhase=2]

Now it has been not important for me because I have deployed it with postgres DB successfully.

Re: Setting up broadleaf development environment without maven

Posted: Tue Nov 16, 2010 7:24 pm
by springgao
I originally deployed broadleafadmin with this data source,
<bean id="webDS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="org.hsqldb.jdbcDriver" />
<property name="url" value="jdbc:hsqldb:hsql://localhost/broadleaf;ifexists=true" />
<property name="username" value="sa" />
<property name="password" value="" />
</bean>
After deployed successfully, I visit this application by http://localhost:8080/broadleafadmin/ and log on with admin/blc_admin, it prompt the following error:

Error: [FaultEvent fault=[RPC Fault faultString="javax.persistence.PersistenceException : org.hibernate.exception.SQLGrammarException: could not execute query" faultCode="Server.Processing" faultDetail="null"] messageId="9AC8D62D-4196-C67E-E301-181AB6B8702C" type="fault" bubbles=false cancelable=true eventPhase=2]

Now it has been not important for me since I have deployed it with postgres DB successfully.

As for documentation, some main and frequently-used API should be introduced, for example, what are their main function, what their parameters and return values mean.
It is better to explain them with corresponding commerce business.
I also can’t understand some business definitions, for example, what are Cross Sale Products, Up Sale Products, SKUs and so on.

Besides, some DB table names and some of their properties are not understood to me, e..g.
BLC_RATING_SUMMARY, DIMENSION_UNIT_OF_MEASURE, BLC_PRODUCT_CROSS_SALE and so on. What are they exactly mean?

And I also have a question, if prodct1 has 3 properties, p1, p2 and p3, but product2 has other 3 properties, p4, p5 and p6 different from product1’s. On this condition, how do I add them into broadleaf?

Re: Setting up broadleaf development environment without maven

Posted: Tue Nov 16, 2010 7:26 pm
by springgao
I originally deployed broadleafadmin with this data source,
<bean id="webDS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="org.hsqldb.jdbcDriver" />
<property name="url" value="jdbc:hsqldb:hsql://localhost/broadleaf;ifexists=true" />
<property name="username" value="sa" />
<property name="password" value="" />
</bean>
After deployed successfully, I visit this application by http://localhost:8080/broadleafadmin/ and log on with admin/blc_admin, it prompt the following error:

Error: [FaultEvent fault=[RPC Fault faultString="javax.persistence.PersistenceException : org.hibernate.exception.SQLGrammarException: could not execute query" faultCode="Server.Processing" faultDetail="null"] messageId="9AC8D62D-4196-C67E-E301-181AB6B8702C" type="fault" bubbles=false cancelable=true eventPhase=2]

Now it has been not important for me since I have deployed it with postgres DB successfully.

As for documentation, some main and frequently-used API should be introduced, for example, what are their main function, what their parameters and return values mean.
It is better to explain them with corresponding commerce business.
I also can’t understand some business definitions, for example, what are Cross Sale Products, Up Sale Products, SKUs and so on.

Besides, some DB table names and some of their properties are not understood to me, e..g.
BLC_RATING_SUMMARY, DIMENSION_UNIT_OF_MEASURE, BLC_PRODUCT_CROSS_SALE and so on. What are they exactly mean?

And I also have a question, if prodct1 has 3 properties, p1, p2 and p3, but product2 has other 3 properties, p4, p5 and p6 different from product1’s. On this condition, how do I add them into broadleaf?

Re: Setting up broadleaf development environment without maven

Posted: Tue Nov 16, 2010 8:20 pm
by springgao
I originally deployed broadleafadmin with this data source,
<bean id="webDS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="org.hsqldb.jdbcDriver" />
<property name="url" value="jdbc:hsqldb:hsql://localhost/broadleaf;ifexists=true" />
<property name="username" value="sa" />
<property name="password" value="" />
</bean>
After deployed successfully, I visit this application by http://localhost:8080/broadleafadmin/ and log on with admin/blc_admin, it prompt the following error:

Error: [FaultEvent fault=[RPC Fault faultString="javax.persistence.PersistenceException : org.hibernate.exception.SQLGrammarException: could not execute query" faultCode="Server.Processing" faultDetail="null"] messageId="9AC8D62D-4196-C67E-E301-181AB6B8702C" type="fault" bubbles=false cancelable=true eventPhase=2]

Now it has been not important for me since I have deployed it with postgres DB successfully.

As for documentation, some main and frequently-used API should be introduced, for example, what are their main function, what their parameters and return values mean.
It is better to explain them with corresponding commerce business.
I also can’t understand some business definitions, for example, what are Cross Sale Products, Up Sale Products, SKUs and so on.

Besides, some DB table names and some of their properties are not understood to me, e..g.
BLC_RATING_SUMMARY, DIMENSION_UNIT_OF_MEASURE, BLC_PRODUCT_CROSS_SALE and so on. What are they exactly mean?

And I also have a question, if prodct1 has 3 properties, p1, p2 and p3, but product2 has other 3 properties, p4, p5 and p6 different from product1’s. On this condition, how do I add them into broadleaf?

Re: Setting up broadleaf development environment without maven

Posted: Tue Nov 16, 2010 10:47 pm
by springgao
I originally deployed broadleafadmin with this data source,
<bean id="webDS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="org.hsqldb.jdbcDriver" />
<property name="url" value="jdbc:hsqldb:hsql://localhost/broadleaf;ifexists=true" />
<property name="username" value="sa" />
<property name="password" value="" />
</bean>
After deployed successfully, I visit this application by http://localhost:8080/broadleafadmin/ and log on with admin/blc_admin, it prompt the following error:
Error: [FaultEvent fault=[RPC Fault faultString="javax.persistence.PersistenceException : org.hibernate.exception.SQLGrammarException: could not execute query" faultCode="Server.Processing" faultDetail="null"] messageId="9AC8D62D-4196-C67E-E301-181AB6B8702C" type="fault" bubbles=false cancelable=true eventPhase=2]
Now it has been not important for me since I have deployed it with postgres DB successfully.

As for documentation, some main and frequently-used API should be introduced, for example, what are their main function, what their parameters and return values mean.
It is better to explain them with corresponding commerce business.
I also can’t understand some business definitions, for example, what are Cross Sale Products, Up Sale Products, SKUs and so on.

Besides, some DB table names and some of their properties are not understood to me, e..g.
BLC_RATING_SUMMARY, DIMENSION_UNIT_OF_MEASURE, BLC_PRODUCT_CROSS_SALE and so on. What are they exactly mean?

And I also have a question, if prodct1 has 3 properties, p1, p2 and p3, but product2 has other 3 properties, p4, p5 and p6 different from product1’s. On this condition, how do I add them into broadleaf?

Re: Setting up broadleaf development environment without maven

Posted: Wed Nov 17, 2010 9:57 am
by jefffischer
Yep - I agree. We've been very bad about finding the time to include proper Java docs for API documentation. It's definitely on our list of important things to address. I also think the API documentation for the entities would help with understanding the purpose of various tables and columns, since the entities inside the domain model reference directly to these tables and their properties reference directly to the columns.

As for your product question, this concept of polymorphic products is definitely something we support. At it's heart, Broadleaf Commerce is a framework built on top of Hibernate and Spring. As such, Broadleaf Commerce benefits directly from features provided by these technologies, and in this case, since Hibernate supports polymorphic entities, so do we. Take the following example:

1) You're an online merchant that sells books and music
2) You would like a separate entity for each with unique properties, even though they are both essentially products

To achieve this in Broadleaf, you simply need to create a new entity extension for each - a new Book class that extends ProductImpl and has its own unique properties and a Music class that also extends ProductImpl and has its own unique properties. With these entities in place, Hibernate will return all products (either Books or Music) that fit the given criteria. For example, a query to returns all active products in a category would return both Books and Music, if that category happened to have both types of products associated. Broadleaf won't mind these multiple types as long as they both extend ProductImpl. In this way, Broadleaf Commerce is satisfied, but when you need to do something specific with a Book or Music, you can cast the Product instance to your more refined class. Please refer to the Broadleaf Commerce documentation for the steps required to add a new entity extension: http://www.broadleafcommerce.org/conflu ... g+Entities.