Well on further looking around even if I manually create teh tables it
doesn't work.
The version tables being created have a schema are set differently.
I see in the class
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager the
following code
if (getStorageModel() == SM_BINARY_KEYS) {
bundleInsertSQL = "insert into " + schemaObjectPrefix + "BUNDLE
(BUNDLE_DATA, NODE_ID) values (?, ?)";
.....
} else {
bundleInsertSQL = "insert into " + schemaObjectPrefix + "BUNDLE
(BUNDLE_DATA, NODE_ID_HI, NODE_ID_LO) values (?, ?, ?)";
......
}
The tables i have seem to have to have the schema for getStorageModel() !=
SM_BINARY_KEYS
Thing is getStroageModel() returns SM_BINARY_KEYS so it is always equal.
Where is the Version ddl sql stored. Do I have to use a different
persistence model for versions?
On 1/24/08, Jason Tesser <[EMAIL PROTECTED]> wrote:
>
> I am using
>
> <PersistenceManager class="
> org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager">
>
> <param name="bundleCacheSize" value="8"/>
> <param name="consistencyCheck" value="false"/>
> <param name="consistencyFix" value="false"/>
> <param name="driver" value=" javax.naming.InitialContext"/>
> <param name="url" value="java:comp/env/jdbc/LiferayPool"/>
> <param name="schema" value="postgresql"/>
> <param name="schemaObjectPrefix" value="jr_ws_"/>
> <param name="errorHandling" value=""/>
> <param name="blockOnConnectionLoss" value="false"/>
> </PersistenceManager>
>
> and for versions
>
> <PersistenceManager class="
> org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager">
>
> <param name="bundleCacheSize" value="8"/>
> <param name="consistencyCheck" value="false"/>
> <param name="consistencyFix" value="false"/>
> <param name="driver" value=" javax.naming.InitialContext"/>
> <param name="url" value="java:comp/env/jdbc/LiferayPool"/>
> <param name="schema" value="postgresql"/>
> <param name="schemaObjectPrefix" value="jr_ver_"/>
> <param name="errorHandling" value=""/>
> <param name="blockOnConnectionLoss" value="false"/>
> </PersistenceManager>
>
>
> it is creating 4 tables but apparently not the ones it needs. It is
> creating the tables with the jr_ver_ prefix but none with jr_ws. I tried to
> make the scema prefixes the same different nothing seems to work. I
> noticed that there is postgresql.ddl which should create the Node table
> and a few others. This is not happening. I thought it should happen
> automatically. any ideas?
>
>
>
> --
> 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
--
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
