Code: Select all
[ERROR] 22:06:54 SchemaUpdate - HHH000388: Unsuccessful: create table BLC_ADDITIONAL_OFFER_INFO (BLC_ORDER_ORDER_ID bigint not null, OFFER_INFO_ID bigint not null, OFFER_ID bigint not null, primary key (BLC_ORDER_ORDER_ID, OFFER_ID)) ENGINE=InnoDB
[ERROR] 22:06:54 SchemaUpdate - ERROR: syntax error at or near "ENGINE"
In my local development environment it creates the database tables properly and runs on PostgreSQL just fine.
Here is the Hibernate config in the common-shared.properties from the core module:
Code: Select all
blPU.hibernate.hbm2ddl.auto=create
blPU.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
blPU.hibernate.show_sql=false
blPU.hibernate.cache.use_second_level_cache=false
blPU.hibernate.cache.use_query_cache=false
blPU.hibernate.hbm2ddl.import_files=null
# Settings for the CMS storage persistence unit
blCMSStorage.hibernate.hbm2ddl.auto=create
blCMSStorage.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
blCMSStorage.hibernate.show_sql=false
blCMSStorage.hibernate.cache.use_second_level_cache=false
blCMSStorage.hibernate.cache.use_query_cache=false
blCMSStorage.hibernate.hbm2ddl.import_files=null
# Settings for the secure persistence unit
blSecurePU.hibernate.hbm2ddl.auto=create
blSecurePU.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
blSecurePU.hibernate.show_sql=false
blSecurePU.hibernate.cache.use_second_level_cache=false
blSecurePU.hibernate.cache.use_query_cache=false
blSecurePU.hibernate.hbm2ddl.import_files=null
Hibernate config in the development-shared.properties:
Code: Select all
blPU.hibernate.hbm2ddl.import_files=/config/bc/sql/load_admin_permissions.sql,/config/bc/sql/load_admin_roles.sql,/config/bc/sql/load_admin_menu.sql,/sql/load_admin_users.sql,/sql/load_code_tables.sql,/sql/load_table_sequences.sql,/sql/load_content_structure.sql,/sql/load_catalog_data.sql,/sql/load_catalog_pricesplit_data.sql,/sql/load_content_data.sql,/sql/load_content_structure_i18n.sql,/sql/load_content_data_i18n.sql,/sql/load_catalog_i18n_data_FR.sql,/sql/load_catalog_i18n_data_ES.sql,/sql/load_sitemap_data.sql
blPU.hibernate.hbm2ddl.auto=create
blCMSStorage.hibernate.hbm2ddl.auto=create
blSecurePU.hibernate.hbm2ddl.auto=create
Local Tomcat JNDI config:
Code: Select all
<Resource name="jdbc/web" auth="Container"
type="javax.sql.DataSource" driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://127.0.0.1:5432/broadleaf"
username="***" password="***" maxActive="20" maxIdle="10"
maxWait="-1"/>
<Resource name="jdbc/secure" auth="Container"
type="javax.sql.DataSource" driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://127.0.0.1:5432/***"
username="***" password="***" maxActive="20" maxIdle="10"
maxWait="-1"/>
<Resource name="jdbc/storage" auth="Container"
type="javax.sql.DataSource" driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://127.0.0.1:5432/broadleaf"
username="***" password="***" maxActive="20" maxIdle="10"
maxWait="-1"/>Tomcat JNDI config on server:
Code: Select all
<Resource name="jdbc/web" auth="Container"
type="javax.sql.DataSource" driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://127.0.0.1:5432/broadleaf"
username="***" password="***" maxActive="20" maxIdle="10"
maxWait="-1"/>
<Resource name="jdbc/secure" auth="Container"
type="javax.sql.DataSource" driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://127.0.0.1:5432/broadleaf"
username="***" password="***" maxActive="20" maxIdle="10"
maxWait="-1"/>
<Resource name="jdbc/storage" auth="Container"
type="javax.sql.DataSource" driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://127.0.0.1:5432/broadleaf"
username="***" password="***" maxActive="20" maxIdle="10"
maxWait="-1"/>I really don't see any differences between the two. Any thoughts on why this is happening?
