You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Hendry Betts III (JIRA)" <ji...@apache.org> on 2012/06/12 15:35:42 UTC
[jira] [Created] (JCR-3338) CreateDeepFolder causes
SQLServerException
Hendry Betts III created JCR-3338:
-------------------------------------
Summary: CreateDeepFolder causes SQLServerException
Key: JCR-3338
URL: https://issues.apache.org/jira/browse/JCR-3338
Project: Jackrabbit Content Repository
Issue Type: Bug
Components: jackrabbit-core
Affects Versions: 2.4.2
Environment: Windows 7 x64, MSSQL 2008r2, Tomcat 7.0.27, Java 1.6.0_32
Reporter: Hendry Betts III
When configuring Jackrabbit to use MSSQL as it's filestore, datastore, persistence store and journal store (per the h2 configuration at http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-core/src/test/resources/org/apache/jackrabbit/core/cluster/repository-h2.xml?view=co&content-type=text/plain), the following error occurs:
com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
at the createDeepFolder method in the DatabaseFileSystem class.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (JCR-3338) CreateDeepFolder causes
SQLServerException
Posted by "Hendry Betts III (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hendry Betts III updated JCR-3338:
----------------------------------
Attachment: repository_correct.xml
the corrected (properly configured) repository xml for an MSSQL backed clustered jackrabbit environment
> CreateDeepFolder causes SQLServerException
> ------------------------------------------
>
> Key: JCR-3338
> URL: https://issues.apache.org/jira/browse/JCR-3338
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-core
> Affects Versions: 2.4.2
> Environment: Windows 7 x64, MSSQL 2008r2, Tomcat 7.0.27, Java 1.6.0_32
> Reporter: Hendry Betts III
> Labels: createDeepFolder, database, features, mssql
> Attachments: jackrabbit-out.txt, repository.xml, repository_correct.xml
>
>
> When configuring Jackrabbit to use MSSQL as it's filestore, datastore, persistence store and journal store (per the h2 configuration at http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-core/src/test/resources/org/apache/jackrabbit/core/cluster/repository-h2.xml?view=co&content-type=text/plain), the following error occurs:
> com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
> at the createDeepFolder method in the DatabaseFileSystem class.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (JCR-3338) CreateDeepFolder causes
SQLServerException
Posted by "Hendry Betts III (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hendry Betts III updated JCR-3338:
----------------------------------
Attachment: jackrabbit-out.txt
repository.xml
repository config file (repository.xml) and system out stacktrace (jackrabbit-out.txt)
> CreateDeepFolder causes SQLServerException
> ------------------------------------------
>
> Key: JCR-3338
> URL: https://issues.apache.org/jira/browse/JCR-3338
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-core
> Affects Versions: 2.4.2
> Environment: Windows 7 x64, MSSQL 2008r2, Tomcat 7.0.27, Java 1.6.0_32
> Reporter: Hendry Betts III
> Labels: createDeepFolder, database, features, mssql
> Attachments: jackrabbit-out.txt, repository.xml
>
>
> When configuring Jackrabbit to use MSSQL as it's filestore, datastore, persistence store and journal store (per the h2 configuration at http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-core/src/test/resources/org/apache/jackrabbit/core/cluster/repository-h2.xml?view=co&content-type=text/plain), the following error occurs:
> com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
> at the createDeepFolder method in the DatabaseFileSystem class.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (JCR-3338) CreateDeepFolder causes
SQLServerException
Posted by "Hendry Betts III (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13293736#comment-13293736 ]
Hendry Betts III commented on JCR-3338:
---------------------------------------
Found solution. See attached repository_correct.xml -- The actual issue is in a dependency on the JDBC connector to define the database type. In later MSSQL JNDI drivers, the type of database is *NOT* required so the string does not contain the "mssql" that the configurations are looking for. Using the latest Microsoft JNDI driver your url is jdbc:sqlserver://SERVER:PORT;DatabaseName=DBNAME -- therefore it is *MANDATORY* that you use the +schema+ parameter in your FileSystem and PersistenceManager stanzas, and the +databaseType+ parameter in the DataStore and Journal stanzas.
> CreateDeepFolder causes SQLServerException
> ------------------------------------------
>
> Key: JCR-3338
> URL: https://issues.apache.org/jira/browse/JCR-3338
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-core
> Affects Versions: 2.4.2
> Environment: Windows 7 x64, MSSQL 2008r2, Tomcat 7.0.27, Java 1.6.0_32
> Reporter: Hendry Betts III
> Labels: createDeepFolder, database, features, mssql
> Attachments: jackrabbit-out.txt, repository.xml, repository_correct.xml
>
>
> When configuring Jackrabbit to use MSSQL as it's filestore, datastore, persistence store and journal store (per the h2 configuration at http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-core/src/test/resources/org/apache/jackrabbit/core/cluster/repository-h2.xml?view=co&content-type=text/plain), the following error occurs:
> com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
> at the createDeepFolder method in the DatabaseFileSystem class.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (JCR-3338) CreateDeepFolder causes
SQLServerException
Posted by "Hendry Betts III (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13293620#comment-13293620 ]
Hendry Betts III commented on JCR-3338:
---------------------------------------
And before anyone asks, I have replaced the core.persistence.bundle.MSSqlPersistenceManager with core.persistence.pool.MSSqlPersistenceManager -- the same SQL error occurs
> CreateDeepFolder causes SQLServerException
> ------------------------------------------
>
> Key: JCR-3338
> URL: https://issues.apache.org/jira/browse/JCR-3338
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-core
> Affects Versions: 2.4.2
> Environment: Windows 7 x64, MSSQL 2008r2, Tomcat 7.0.27, Java 1.6.0_32
> Reporter: Hendry Betts III
> Labels: createDeepFolder, database, features, mssql
> Attachments: jackrabbit-out.txt, repository.xml
>
>
> When configuring Jackrabbit to use MSSQL as it's filestore, datastore, persistence store and journal store (per the h2 configuration at http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-core/src/test/resources/org/apache/jackrabbit/core/cluster/repository-h2.xml?view=co&content-type=text/plain), the following error occurs:
> com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
> at the createDeepFolder method in the DatabaseFileSystem class.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (JCR-3338) CreateDeepFolder causes
SQLServerException
Posted by "Hendry Betts III (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hendry Betts III resolved JCR-3338.
-----------------------------------
Resolution: Not A Problem
The issue is more about documentation than configurations. See previous notes.
> CreateDeepFolder causes SQLServerException
> ------------------------------------------
>
> Key: JCR-3338
> URL: https://issues.apache.org/jira/browse/JCR-3338
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-core
> Affects Versions: 2.4.2
> Environment: Windows 7 x64, MSSQL 2008r2, Tomcat 7.0.27, Java 1.6.0_32
> Reporter: Hendry Betts III
> Labels: createDeepFolder, database, features, mssql
> Attachments: jackrabbit-out.txt, repository.xml, repository_correct.xml
>
>
> When configuring Jackrabbit to use MSSQL as it's filestore, datastore, persistence store and journal store (per the h2 configuration at http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-core/src/test/resources/org/apache/jackrabbit/core/cluster/repository-h2.xml?view=co&content-type=text/plain), the following error occurs:
> com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.
> at the createDeepFolder method in the DatabaseFileSystem class.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira