Working revisions and JDBC Stores

[Paul Emms <pa...@calleo.com>]

Hi,

Firstly does anyone know what the plans are for working revisions? In the
current JDBCDescriptorStore there appears to be some code to implement this,
but there are no corresponding methods in NodeRevisionDescriptors like
getWorkingVersion() etc. I couldn't find any mention of this in the mail
archive - can someone tell me what are the plans for this functionality and
how I might go about implementing it ?

Secondly, the current JDBCContentStore/JDBCDescriptorsStore don't close
connections properly after opening them (at least with Oracle). I get a "too
many open cursors error" - putting statement.close() as a soon as a
statement isn't needed solves the problem.

Regards,
Paul

***********************************************************************
Calleo UK Limited          Phone   +44 207 645 9400
Paul Emms                  Direct  +44 207 264 2061
Information Analyst        Fax     +44 207 264 2064
Suite 881, Lloyd's
One Lime Street            E-Mail  paul.emms@calleo.com
London                     www.calleo.com
EC3M 7HA
***********************************************************************
Privileged/Confidential Information may be contained in this message.  If
you are not the addressee indicated in this message (or responsible for
delivery of the message to such person), you may not copy or deliver this
message to anyone. In such case, you should destroy this message and kindly
notify the sender by reply email. Please advise immediately if you or your
employer does not consent to Internet email for messages of this kind.
Opinions, conclusions and other information in this message that do not
relate to the official business of my firm shall be understood as neither
given nor endorsed by it.






Knowledge by Experience

Re: Working revisions and JDBC Stores

[Remy Maucherat <re...@apache.org>]

> Hi,
>
> Firstly does anyone know what the plans are for working revisions? In the
> current JDBCDescriptorStore there appears to be some code to implement
this,
> but there are no corresponding methods in NodeRevisionDescriptors like
> getWorkingVersion() etc. I couldn't find any mention of this in the mail
> archive - can someone tell me what are the plans for this functionality
and
> how I might go about implementing it ?

It may be needed to implement one particular feature of Delta V.

> Secondly, the current JDBCContentStore/JDBCDescriptorsStore don't close
> connections properly after opening them (at least with Oracle). I get a
"too
> many open cursors error" - putting statement.close() as a soon as a
> statement isn't needed solves the problem.

I just read the code of the descriptors store. There are indeed many close
calls missing (that needs to be fixed).
I don't believe there are any in the content store, though.

Remy