You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "premkumar (JIRA)" <ji...@apache.org> on 2009/07/04 13:37:48 UTC
[jira] Created: (JCR-2187) Jackrabbit Datastore issue
Jackrabbit Datastore issue
--------------------------
Key: JCR-2187
URL: https://issues.apache.org/jira/browse/JCR-2187
Project: Jackrabbit Content Repository
Issue Type: Bug
Affects Versions: 1.5.6
Environment: windows xp, oracle
Reporter: premkumar
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.
[jira] Updated: (JCR-2187) Jackrabbit Datastore issue
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Mueller updated JCR-2187:
--------------------------------
Component/s: jackrabbit-core
Assignee: Thomas Mueller
> 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: 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.
[jira] Resolved: (JCR-2187) Jackrabbit Datastore issue
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Mueller resolved JCR-2187.
---------------------------------
Resolution: Cannot Reproduce
> 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: 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.
[jira] Closed: (JCR-2187) Jackrabbit Datastore issue
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Mueller closed JCR-2187.
-------------------------------
> 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.
[jira] Issue Comment Edited: (JCR-2187) Jackrabbit Datastore issue
Posted by "premkumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729649#action_12729649 ]
premkumar edited comment on JCR-2187 at 7/10/09 7:30 AM:
---------------------------------------------------------
Thanks Thomas, that works fine. Actually there was a confusion between Dev & Staging. I changed JDBC driver to Oracle 10, now its working perfectly.
I'm little confused with datastore and persistence manager.. If we are using datastore for storing files in DB means what for persistence manager. I'm not able to get exact difference . Can you just explain me.
Thanks a lot once again.
was (Author: premkumar):
Thanks Thomas, that works fine. Actually there was a confusion between Dev & Staging. I changed JDBC driver to Oracle 10, now its working perfectly.
I'm little confused with datastore and persistence manager.. If we are using datastore for storing files in DB means what for persistence manager. I'm not able to get exact difference . Can you just tell me explain me.
Thanks a lot once again.
> 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.
[jira] Issue Comment Edited: (JCR-2187) Jackrabbit Datastore issue
Posted by "premkumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12728602#action_12728602 ]
premkumar edited comment on JCR-2187 at 7/8/09 3:37 AM:
--------------------------------------------------------
Attached repository.xml that I'am using for datastore and default workspace.xml that is autogenerated by using TransientRepository().
Actually I requirement is to change default local "filesystem store" to "DB store" . All the input stream(blob) should get store in the DB and when I get or search it should come from DB.
I'am using <DataStore> configuration for storing data in DB. I'am not getting any exception while storing but InputStream(BLOB) not getting stored when it exceeds 2000 lengh..
was (Author: premkumar):
repository.xml that I'am using for datastore
> Jackrabbit Datastore issue
> --------------------------
>
> Key: JCR-2187
> URL: https://issues.apache.org/jira/browse/JCR-2187
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Affects Versions: 1.5.6
> Environment: windows xp, oracle
> Reporter: premkumar
> Attachments: 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.
[jira] Updated: (JCR-2187) Jackrabbit Datastore issue
Posted by "premkumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
premkumar updated JCR-2187:
---------------------------
Attachment: Jackrabbit_9i_log.txt
By the way, I'm using Oracle 9i. So, when i change the persistence manager to Oracle9PresistenceManager, I'm getting error,
Attached log for your reference (Jackrabbit_9i_log.txt).
> 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.
[jira] Commented: (JCR-2187) Jackrabbit Datastore issue
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (JCR-2187) Jackrabbit Datastore issue
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729654#action_12729654 ]
Thomas Mueller commented on JCR-2187:
-------------------------------------
For more information, see:
http://wiki.apache.org/jackrabbit/PersistenceManagerFAQ
http://wiki.apache.org/jackrabbit/DataStore
> 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.
[jira] Commented: (JCR-2187) Jackrabbit Datastore issue
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12728638#action_12728638 ]
Thomas Mueller commented on JCR-2187:
-------------------------------------
In the configuration, could you change
<param name="copyWhenReading" value="false"/>
to
<param name="copyWhenReading" value="true"/>
Could you also check the log files for error messages and exception stack traces? If you don't find anything, could you post a simple, standalone test case that reproduces the problem? It would be great if the test case does not have any dependencies except the Jackrabbit jar files (that is, a simple Java class uses the JCR API and is run using a static main method). Please include any initialization code in the Java class, so that it does not depend on an existing repository.
By the way I wouldn't use <param name="minRecordLength" value="8"/>, instead use the default or a higher value, such as 1024.
> Jackrabbit Datastore issue
> --------------------------
>
> Key: JCR-2187
> URL: https://issues.apache.org/jira/browse/JCR-2187
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Affects Versions: 1.5.6
> Environment: windows xp, oracle
> Reporter: premkumar
> Attachments: 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.
[jira] Updated: (JCR-2187) Jackrabbit Datastore issue
Posted by "premkumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
premkumar updated JCR-2187:
---------------------------
Attachment: repository.xml
repository.xml that I'am using for datastore
> Jackrabbit Datastore issue
> --------------------------
>
> Key: JCR-2187
> URL: https://issues.apache.org/jira/browse/JCR-2187
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Affects Versions: 1.5.6
> Environment: windows xp, oracle
> Reporter: premkumar
> Attachments: 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.
[jira] Commented: (JCR-2187) Jackrabbit Datastore issue
Posted by "premkumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729649#action_12729649 ]
premkumar commented on JCR-2187:
--------------------------------
Thanks Thomas, that works fine. Actually there was a confusion between Dev & Staging. I changed JDBC driver to Oracle 10, now its working perfectly.
I'm little confused with datastore and persistence manager.. If we are using datastore for storing files in DB means what for persistence manager. I'm not able to get exact difference . Can you just tell me explain me.
Thanks a lot once again.
> 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.
[jira] Commented: (JCR-2187) Jackrabbit Datastore issue
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12727501#action_12727501 ]
Thomas Mueller commented on JCR-2187:
-------------------------------------
What is the exact configuration (repository.xml and workspace.xml files) you have used, what is the exact exception message and stack trace?
> Jackrabbit Datastore issue
> --------------------------
>
> Key: JCR-2187
> URL: https://issues.apache.org/jira/browse/JCR-2187
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Affects Versions: 1.5.6
> Environment: windows xp, oracle
> Reporter: premkumar
>
> 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.
[jira] Updated: (JCR-2187) Jackrabbit Datastore issue
Posted by "premkumar (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
premkumar updated JCR-2187:
---------------------------
Attachment: Jackrabbit_log.txt
Thanks for your imme reply Thomas :)
I have attached a file which contains captured log.
I changed in repository.xml as you told, still I'm getting same problem.
> 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_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.