[ 
https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729571#action_12729571
 ] 

Thomas Mueller commented on JCR-2187:
-------------------------------------

Hi,

The way I read the log file, this problem is not related to the data store at 
all.

> I'm using Oracle 9i.

No, it looks like you use Oracle 10g:

> Database: Oracle / Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

But you do seem to use the Oracle 9i driver:

> Driver: Oracle JDBC driver / 9.2.0.1.0
> Unsupported driver version detected: Oracle JDBC driver v9.2.0.1.0

I would use the Oracle 10 driver with an Oracle 10 database.

Maybe this is additionally an Oracle identifier length limitation problem. 
Could drop all tables in the database (in this schema), and you try using a 
shorter prefix. Just be be sure, I would only uppercase characters. So instead 
of:

<param name="schemaObjectPrefix" value="CMS_rep_fs_"/> ...
<param name="schemaObjectPrefix" value="CMS_wor_fs_${wsp.name}_"/> ...
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
<param name="schemaObjectPrefix" value="version_"/>

I would try with:

<param name="schemaObjectPrefix" value="FS_"/> ...
<param name="schemaObjectPrefix" value="FS_${wsp.name}_"/> ...
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
<param name="schemaObjectPrefix" value="VERSION_"/>



> Jackrabbit Datastore issue
> --------------------------
>
>                 Key: JCR-2187
>                 URL: https://issues.apache.org/jira/browse/JCR-2187
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: jackrabbit-core
>    Affects Versions: 1.5.6
>         Environment: windows xp, oracle
>            Reporter: premkumar
>            Assignee: Thomas Mueller
>         Attachments: Jackrabbit_9i_log.txt, Jackrabbit_log.txt, repository.xml
>
>
> When I use datastore in jackrabbit for storing file stream, Im getting null 
> value in DB for BLOB which is having more than 2000 length.

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

Reply via email to