Hi,
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
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.