Broadleaf Commerce Discussion Forums

Dear Manager,

I could run the Site of Broadleaf Commerce. However i am getting the error while running the Admin.

Could you please send me the configuration changes for Admin. I am using MS Sql server 2014 and Tomcat7?

The error is.

[artifact:mvn] com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost/broadleaf, port 1433 has
failed. Error: "null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host
and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

Error creating bean with name 'blPersistenceUnitManager':Injection of resource dependencies failed;
nested exception is org.springframework.beans.factory.BeanCreationException:

I made following changes.

1. In admin/../web.xml

<resource-ref>
<res-ref-name>jdbc/web</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

2. In tomcat context.xml

<Resource name="jdbc/web" auth="Container" type="javax.sql.DataSource"
maxActive="30" maxIdle="60" maxWait="10000"
username="V\vg" password=""
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
connectionProperties="useUnicode=true;characterEncoding=utf8;"
url="jdbc:sqlserver://localhost/broadleaf"
/>

3. In common-shared.properties file

blPU.hibernate.dialect="org.hibernate.dialect.SQLServer2012Dialect
blSecurePU.hibernate.dialect="org.hibernate.dialect.SQLServer2012Dialect
blCMSStorage.hibernate.dialect="org.hibernate.dialect.SQLServer2012Dialect


Also the entry present in 'core/../applicationContext.xml' below is different than the merge configuration in
http://www.broadleafcommerce.com/docs/c ... figuration

<bean class="org.broadleafcommerce.common.extensibility.context.merge.LateStageMergeBeanPostProcessor">
<property name="collectionRef" value="mySamplePaymentProcessors"/>
<property name="targetRef" value="blDialectProcessors"/>
</bean>

Kind Regards,
Varun Gosain
Ph: +91 8685 863 694