jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Klimetschek (JIRA)" <j...@apache.org>
Subject [jira] Commented: (JCR-889) Add bundle support for PostgreSQL
Date Tue, 19 Jun 2007 15:27:27 GMT

    [ https://issues.apache.org/jira/browse/JCR-889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12506207
] 

Alexander Klimetschek commented on JCR-889:
-------------------------------------------

We have used that with Jackrabbit 1.3 and a PostgeSQL 8.2 and can confirm that it works, using
the PM for workspaces and versions.

As Postgres 8.2 has useful new features, we improved the implementation and schema for 8.2.
It has another index and the new 8.2 "RETURNING" feature, that allows to reduce the 2 statements
going through the index to 1.

The two changes are a different schema and a different PostgreSQLNameIndex class. The PostgreSQLPersistenceManager
class needs no changes.

> Add bundle support for PostgreSQL
> ---------------------------------
>
>                 Key: JCR-889
>                 URL: https://issues.apache.org/jira/browse/JCR-889
>             Project: Jackrabbit
>          Issue Type: New Feature
>          Components: core
>            Reporter: Miguel Angel Jiménez Sampedro
>            Assignee: Jukka Zitting
>            Priority: Minor
>             Fix For: 1.4
>
>         Attachments: postgresql.ddl, postgresql.ddl, PostgreSQLNameIndex.java, PostgreSQLPersistenceManager.java
>
>
> The class DbNameIndex does not work with this RDBMS since the RETURN_GENERATED_KEYS JDBC
feature is not implemented in current PostgreSQL drivers.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message