Basically the problem is that the ddl for Postgres creates the schema
create table ${schemaObjectPrefix}BUNDLE (NODE_ID_HI bigint not null,
NODE_ID_LO bigint not null, BUNDLE_DATA bytea not null, PRIMARY KEY
(NODE_ID_HI, NODE_ID_LO))
create table ${schemaObjectPrefix}REFS (NODE_ID_HI bigint not null,
NODE_ID_LO bigint not null, REFS_DATA bytea not null, PRIMARY KEY
(NODE_ID_HI, NODE_ID_LO))
create table ${schemaObjectPrefix}BINVAL (BINVAL_ID varchar(64) not null,
BINVAL_DATA bytea not null)
create unique index ${schemaObjectPrefix}BINVAL_IDX on
${schemaObjectPrefix}BINVAL (BINVAL_ID)
create table ${schemaObjectPrefix}NAMES (ID SERIAL PRIMARY KEY, NAME
varchar(255) not null)
The problem is the in the
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager
it cannot ever call the sql for this kind of SQL See code below
public int getStorageModel() {
return SM_BINARY_KEYS;
}
String sql;
if (getStorageModel() == SM_BINARY_KEYS) {
sql = "select NODE_ID, BUNDLE_DATA from " +
schemaObjectPrefix + "BUNDLE";
} else {
sql = "select NODE_ID_HI, NODE_ID_LO, BUNDLE_DATA from " +
schemaObjectPrefix + "BUNDLE";
}
The else condition will never get hit. This happens all over this class.
Secondly their is a problem in the DbNameIndex as it has the following
rs = stmt.getGeneratedKeys();
That method is not implemented in even the latest pgjdbcdriver So it will
never work with PostgreSQL
On 1/25/08, Thomas Mueller <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> The tables should be created automatically. You should not create them
> manually.
> Are there any stack traces in the log file?
> Could you post them please?
>
> Regards,
> Thomas
>
--
Jason S. Tesser
Lead Programmer
www.dotmarketing.com
www.dotcms.org
Dotmarketing, Inc.
3059 Grand Avenue
Suite 440
Miami, FL 33133
T: 305.858.1422 x279
F: 786.594.5288
