Bug 979528 - EnterpriseDB (PostgresPlus) 9.2: DBInitializerException: Could not create the DB schema of the workspace 'system'.
Summary: EnterpriseDB (PostgresPlus) 9.2: DBInitializerException: Could not create the...
Keywords:
Status: CLOSED UPSTREAM
Alias: None
Product: JBoss Enterprise Portal Platform 6
Classification: JBoss
Component: Portal
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
urgent
medium
Target Milestone: DR01
: 6.1.1
Assignee: Nobody
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-06-28 18:05 UTC by Tomas Kyjovsky
Modified: 2025-02-10 03:28 UTC (History)
4 users (show)

Fixed In Version:
Clone Of:
Environment:
PostgresPlus 9.2 (EnterpriseDB)
Last Closed: 2025-02-10 03:28:02 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)
DBInitializerException (9.21 KB, text/plain)
2013-06-28 18:05 UTC, Tomas Kyjovsky 		no flags Details
View All

Description Tomas Kyjovsky 2013-06-28 18:05:38 UTC 
Created attachment 766688 [details]
DBInitializerException

Description of problem:

SQL problem when initializing JCR tables.

org.exoplatform.services.jcr.impl.util.jdbc.DBInitializerException: Could not create the DB schema of the workspace 'system'. Reason: ERROR: syntax error at or near "generated"


Steps to Reproduce:
1. configure JPP-6.1 ER01 with PostgresPlus 9.2 (including manually setting of hibernate.dialect for IDM and JCR datasources)
2. start portal
Comment 1 Tomas Kyjovsky 2013-06-28 18:09:12 UTC 
Related Jenkins build: https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/EPP/view/6.1/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_postgresplus92/22/
Comment 3 Tomas Kyjovsky 2013-07-02 11:52:47 UTC 
The same problem occurs with PostgreSQL driver: postgresql-9.2-1002.jdbc4.jar.
Comment 4 Tomas Kyjovsky 2013-07-02 13:10:10 UTC 
CORRECTION: I forgot to change jdbc URLs of datasources from jdbc:edb:// to jdbc:postgresql:// along with the driver jar. JPP+EDB is now working OK when PostgreSQL-9.2 driver is used (with jdbc:postgresql:// URL prefix).
Comment 5 Thomas Heute 2013-11-06 16:50:03 UTC 
Is it actually still a bug ? Or wrong config ?
Comment 6 Dominik Pospisil 2013-11-13 14:21:11 UTC 
Verified (GA + 0day patch)
Comment 10 Red Hat Bugzilla 2025-02-10 03:28:02 UTC 
This product has been discontinued or is no longer tracked in Red Hat Bugzilla.
Note You need to log in before you can comment on or make changes to this bug.