hi javier,
i committed the postgresql.ddl (with some minor modifications) and
i also fixed the SimpleDbPersistenceManager.checkSchema() issue
that you reported. see svn r331546.
thanks again for your contributions!
i am looking forward hearing more from you :)
cheers
stefan
On 11/4/05, Javier Bermejo <[EMAIL PROTECTED]> wrote:
> Hi Stefan,
>
> I have tested Jackrabbit tests after doing the following modifications:
> - src/main/java/org/apache/jackrabbit/core/state/db/postgresql.ddl
> -
> src/main/java/org/apache/jackrabbit/core/state/db/SimpleDbPersistenceManager.java
> (the patch I attach you yesterday)
> - applications/test/workspaces/test/workspace.xml. In this file I have
> replaced the persistence manager with the next lines:
>
> <PersistenceManager
> class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
> <param name="driver" value="org.postgresql.Driver"/>
> <param name="url"
> value="jdbc:postgresql://localhost/jackrabbit"/>
> <param name="user" value="user"/>
> <param name="password" value="pass"/>
> <param name="schema" value="postgresql"/>
> <param name="schemaObjectPrefix" value="${wsp.name}_"/>
> <param name="externalBLOBs" value="false"/>
> </PersistenceManager>
>
> Also, you need to include the postgresql (and mysqlconnector) driver
> dependency in maven (project.xml)
> <dependency>
> <groupId>postgresql</groupId>
> <artifactId>postgresql</artifactId>
> <version>7.4.1-jdbc3</version>
> </dependency>
> <dependency>
> <groupId>mysql</groupId>
> <artifactId>mysql-connector-java</artifactId>
> <version>3.0.10-stable-bin</version>
> </dependency>
>
>
> And this is the result of "maven test" command:
> test:single:
> [junit] Running org.apache.jackrabbit.init.TestAll
> [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 4,705 sec
>
>
> [junit] Running org.apache.jackrabbit.test.api.query.TestAll
> [junit] Tests run: 82, Failures: 0, Errors: 0, Time elapsed: 8,697 sec
> [junit] Running org.apache.jackrabbit.test.api.nodetype.TestAll
> [junit] Tests run: 99, Failures: 1, Errors: 0, Time elapsed: 30,932 sec
> [junit] [ERROR] TEST org.apache.jackrabbit.test.api.nodetype.TestAll
> FAILED
> [junit] Running org.apache.jackrabbit.test.api.util.TestAll
> [junit] Tests run: 0, Failures: 0, Errors: 0, Time elapsed: 0,294 sec
> [junit] Running org.apache.jackrabbit.test.api.lock.TestAll
> [junit] Tests run: 21, Failures: 0, Errors: 0, Time elapsed: 5,512 sec
> [junit] Running org.apache.jackrabbit.test.api.version.TestAll
> [junit] Tests run: 211, Failures: 0, Errors: 0, Time elapsed: 44,165 sec
> [junit] Running org.apache.jackrabbit.test.api.observation.TestAll
> [junit] Tests run: 40, Failures: 0, Errors: 0, Time elapsed: 9,984 sec
> [junit] Running org.apache.jackrabbit.test.api.TestAll
> [junit] Tests run: 583, Failures: 0, Errors: 0, Time elapsed: 25,185 sec
> [junit] Running org.apache.jackrabbit.name.TestAll
> [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 0,341 sec
> [junit] Running org.apache.jackrabbit.core.state.TestAll
> [junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3,643 sec
> [junit] Running org.apache.jackrabbit.core.config.TestAll
> [junit] Tests run: 9, Failures: 0, Errors: 0, Time elapsed: 0,901 sec
> [junit] Running org.apache.jackrabbit.core.query.TestAll
> [junit] Tests run: 70, Failures: 0, Errors: 0, Time elapsed: 11,748 sec
> [junit] Running org.apache.jackrabbit.core.nodetype.xml.TestAll
> [junit] Tests run: 32, Failures: 0, Errors: 0, Time elapsed: 1,064 sec
> [junit] Running org.apache.jackrabbit.core.observation.TestAll
> [junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 4,158 sec
> [junit] Running org.apache.jackrabbit.core.TestAll
> [junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 4,587 sec
> BUILD SUCCESSFUL
> --------------------------------
>
> The
> target/test-reports/TEST-org.apache.jackrabbit.test.api.nodetype.TestAll.txt
> contains:
>
> --------------------------------
> Testsuite: org.apache.jackrabbit.test.api.nodetype.TestAll
> Tests run: 99, Failures: 1, Errors: 0, Time elapsed: 30,932 sec
>
> Testcase:
> testIsMandatory(org.apache.jackrabbit.test.api.nodetype.PropertyDefTest):
> FAILED
> Node
> /jcr:system/jcr:versionStorage/16/b5/bf/16b5bf7f-9ce6-4646-91ef-06a826181441/1.0/jcr:frozenNode/versionab
> leNodeName1 does not contain value for mandatory property: jcr:frozenUuid
> junit.framework.AssertionFailedError: Node
> /jcr:system/jcr:versionStorage/16/b5/bf/16b5bf7f-9ce6-4646-91ef-06a
> 826181441/1.0/jcr:frozenNode/versionableNodeName1 does not contain value
> for mandatory property: jcr:frozenUui
> d
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.checkMandatoryConstraint(PropertyDefTest.ja
> va:392)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.traverse(PropertyDefTest.java:366)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.traverse(PropertyDefTest.java:373)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.traverse(PropertyDefTest.java:373)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.traverse(PropertyDefTest.java:373)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.traverse(PropertyDefTest.java:373)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.traverse(PropertyDefTest.java:373)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.traverse(PropertyDefTest.java:373)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.traverse(PropertyDefTest.java:373)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.traverse(PropertyDefTest.java:373)
> at
> org.apache.jackrabbit.test.api.nodetype.PropertyDefTest.testIsMandatory(PropertyDefTest.java:175)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at
> org.apache.jackrabbit.test.AbstractJCRTest.run(AbstractJCRTest.java:401)
> --------------------------------
>
> After that, I have tested replacing the postgresql schema and driver
> with mysql connector obtaining the same results and the same failure
> test (so, it is not caused by using postgresql).
>
> Now I'm going to continue with tests in our CMS implementation using
> Jackrabbit and feedback will be reported.
>
> I hope this info could help you.
>
> Best regards
> Javier Bermejo
>
> Stefan Guggisberg wrote:
>
> >hi javier
> >
> >On 11/4/05, Javier Bermejo <[EMAIL PROTECTED]> wrote:
> >
> >
> >> Hi Stefan,
> >>
> >> Currently I can say that simpledbpersistence is much faster than
> >>orm-persistence module. I'm having some troubles with referencing nodes (it
> >>seems it doesn't work fine, but I need to realize more tests to check it
> >>correctly).
> >>
> >>
> >
> >do those problems occur with the SimpleDbPersistenceManager?
> >i'd be very surprised...
> >
> >
> >
> >> I hope in a few days or one week to post here some performance results
> >>about times for creating nodes, sharing them (using references), versioning
> >>and so on.
> >>
> >>
> >
> >that would be very appreciated, thanks.
> >
> >
> >
> >>In a short future we will need to implement a cache system over
> >>simpledb and times will change (does anyone try to implement it?).
> >>
> >>
> >
> >chaching ItemState objects retrieved from the PersistenceManager is already
> >handled by the SharedItemStateManager using a ItemStateReferenceCache.
> >
> >caching in the PM is IMO unnecessary and even counterproductive as it
> >consumes memory that could be more efficiently used by
> >SharedItemStateManager.
> >
> >
> >
> >> I attach you the postgresql.ddl, but I'm not an expert on it, so, somebody
> >>would review it. The main change is to change the BLOB data type to BYTEA
> >>(http://www.postgresql.org/docs/7.2/interactive/datatype-binary.html)
> >>
> >>
> >
> >thanks a lot! i'll commit it asap.
> >
> >cheers
> >stefan
> >
> >
> >
>
>
