[JCR-3338] CreateDeepFolder causes SQLServerException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 2.4.2
• Component/s: jackrabbit-core
• Labels: createDeepFolder database features mssql
• Environment: Windows 7 x64, MSSQL 2008r2, Tomcat 7.0.27, Java 1.6.0_32
• Assignee: Unassigned
• Reporter: Hendry Betts III
• Created: 12/Jun/12 13:35
• Updated: 06/May/13 11:13
• Resolved: 12/Jun/12 16:25

Description

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.