Datastore in windows with microsoft sql server hangs !!

[JOSE FELIX HERNANDEZ BARRIO]

Hi all,


I'm using win 2008 with microsoft sql server and a datastore
when i insert large files (bigger than 50kb only !!) in the repository the
server hangs, with 0% cpu usage but the call doesn't return.


any tip ?
my repository.xml

<Repository>
    <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
        <param name="path" value="${rep.home}/repository"/>
    </FileSystem>

    <DataStore class="org.apache.jackrabbit.core.data.FileDataStore">
        <param name="minRecordLength" value="1000"/>
    </DataStore>

    <Security appName="Jackrabbit">
        <SecurityManager
class="org.apache.jackrabbit.core.DefaultSecurityManager"
workspaceName="security">
            <UserManager
class="org.apache.jackrabbit.core.security.user.UserManagerImpl"/>
        </SecurityManager>

        <AccessManager
class="org.apache.jackrabbit.core.security.DefaultAccessManager"/>
        <LoginModule
class="org.apache.jackrabbit.core.security.authentication.DefaultLoginModule"/>

    </Security>

    <Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default"/>
    <Workspace name="${wsp.name}">
        <FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name="path" value="${wsp.home}"/>
        </FileSystem>

        <PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager">
              <param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
              <param name="url" value="jdbc:sqlserver://10.0.129.47
;databaseName=...."/>
              <param name="schema" value="mssql"/>
              <param name="schemaObjectPrefix" value="jcr_${wsp.name}_"/>
              <param name="externalBLOBs" value="false"/>
          <param name="tableSpace" value=""/>
          <param name="bundleCacheSize" value="8"/>
          </PersistenceManager>
        <!--
            Search index and the file system it uses.
            class: FQN of class implementing the QueryHandler interface
        -->
        <SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
            <param name="path" value="${wsp.home}/index"/>
            <param name="supportHighlighting" value="true"/>
        </SearchIndex>
    </Workspace>

    <!--
        Configures the versioning
    -->
    <Versioning rootPath="${rep.home}/version">
        <!--
            Configures the filesystem to use for versioning for the
respective
            persistence manager
        -->
        <FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name="path" value="${rep.home}/version" />
        </FileSystem>

        <!--
            Configures the persistence manager to be used for persisting
version state.
            Please note that the current versioning implementation is based
on
            a 'normal' persistence manager, but this could change in future
            implementations.
        -->
        <PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager">
              <param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
              <param name="url" value="jdbc:sqlserver://10.0.129.47
;databaseName=..."/>
              <param name="schema" value="mssql"/>
              <param name="schemaObjectPrefix" value="version_"/>
              <param name="externalBLOBs" value="false"/>
          <param name="tableSpace" value=""/>
          <param name="bundleCacheSize" value="8"/>
          </PersistenceManager>

    </Versioning>

    <!--
        Search index for content that is shared repository wide
        (/jcr:system tree, contains mainly versions)
    -->
    <SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
        <param name="path" value="${rep.home}/repository/index"/>
        <param name="supportHighlighting" value="true"/>
    </SearchIndex>
</Repository>

-- 
Jose Hernandez
675599600
Isthari
http://www.isthari.com