jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hendry Betts III (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (JCR-3338) CreateDeepFolder causes SQLServerException
Date Tue, 12 Jun 2012 16:24:43 GMT

    [ 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

> 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


View raw message