jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hemanta Gupta (JIRA)" <j...@apache.org>
Subject [jira] Updated: (JCR-942) Thoughts on supporting JNDI based Oracle file system/persistence manager implementations
Date Fri, 25 May 2007 05:01:16 GMT

     [ https://issues.apache.org/jira/browse/JCR-942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Hemanta Gupta updated JCR-942:
------------------------------

    Attachment: OracleJNDIFileSystem.java

Attaching modified file system implementation which uses a data-source and a native connection
extractor (see usages of getNativeConnection()).

> Thoughts on supporting JNDI based Oracle file system/persistence manager implementations
> ----------------------------------------------------------------------------------------
>
>                 Key: JCR-942
>                 URL: https://issues.apache.org/jira/browse/JCR-942
>             Project: Jackrabbit
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 1.3
>         Environment: Oracle 10g
>            Reporter: Hemanta Gupta
>            Priority: Minor
>         Attachments: OracleJNDIFileSystem.java
>
>
> This may not be relevant for too many people, but I faced a situation where I couldn't
use the stock Oracle file system and persistence manager implementations since we couldn't
place the clear text DB password in repository.xml (for security reasons).
> I tried adapting the classes to use a data-source instead, but this didn't work out immediately
because of the Oracle specific blob handling being performed by these classes. They expect
the connection to be the original native connection returned by the driver, so in the case
of wrapped connections returned by managed data-sources, a ClassCastException is thrown by
oracle.sql.BLOB.createTemporary().
> I finally got things working thanks to the fact that both application servers we support
(JBoss and WebLogic) allow extraction of the native connection from a wrapped managed connection.
Spring's NativeJdbcExtractor interface proved very helpful here; I simply used the right implementation
for extracting the native connection and using it wherever I thought it was required (modified
code to be attached later).
> So to sum up, would it be possible for JR to provide this kind of functionality out-of-the-box?
To be specific, could you provide JNDI based Oracle file system and persistence manager implementations
where we can plug in some kind of native connection extractor, and have the implementations
internally use the native connection for Oracle specific stuff?

-- 
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