Hello... I am trying to get the BL Starter Project (viewtopic.php?f=7&t=400) running locally against Postgres. I have been able to get the M2 demo app running against it, but I cannot get the latest BL Starter Project with M4 to use the Postgres Dialect. I have replaced every mention of HSQL I could find in the application context xml files, but BL still seems to want to use the wrong dialect. What has changed in M4 that I may be missing or don't see?? I have even added the lastest Postgres Drive to my pom, but I still get errors.
Thanks for any help you may be able to give me.
~Ron
// Console Output
[ INFO] 14:03:57 InjectedDataSourceConnectionProvider - Using provided datasource
[ INFO] 14:03:57 SettingsFactory - Database ->
name : PostgreSQL
version : 8.3.8
major : 8
minor : 3
[ INFO] 14:03:57 SettingsFactory - Driver ->
name : PostgreSQL Native Driver
version : PostgreSQL 8.2 JDBC3 with SSL (build 505)
major : 8
minor : 2
[ INFO] 14:03:57 Dialect - Using dialect: org.hibernate.dialect.HSQLDialect
[ INFO] 14:03:57 JdbcSupportLoader - Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
// My webDS
<bean id="webDS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="org.postgresql.Driver" />
<property name="url" value="jdbc:postgresql://127.0.0.1/phoenix_ecom" />
<property name="username" value="pw" />
<property name="password" value="pw" />
</bean>
// persistence-admin.xml
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/ ... ce_2_0.xsd"
version="2.0">
<persistence-unit name="blPU" transaction-type="RESOURCE_LOCAL">
<non-jta-data-source>jdbc/web</non-jta-data-source>
<exclude-unlisted-classes/>
<properties>
<property name="hibernate.hbm2ddl.auto" value="create-drop"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
<property name="hibernate.show_sql" value="false"/>
</properties>
</persistence-unit>
<persistence-unit name="blSecurePU" transaction-type="RESOURCE_LOCAL">
<non-jta-data-source>jdbc/webSecure</non-jta-data-source>
<exclude-unlisted-classes/>
<properties>
<property name="hibernate.hbm2ddl.auto" value="update"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
<property name="hibernate.show_sql" value="false"/>
</properties>
</persistence-unit>
</persistence>
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.