[
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
