-----Original Message-----
From: Stefan Guggisberg [mailto:[EMAIL PROTECTED]
Sent: Friday, January 26, 2007 3:38 AM
To: [email protected]
Subject: Re: Database Connection Timeouts Using
SimpleDbPersistenceManager
hi brian,
mysql is known to drop idle connections. i haven't heard anything
regarding mssql automatically dropping idle connections. is the
connection obtained from a connection pool?
anyway, as thomas already mentioned, the current version of jackrabbit
should automatically try to recover from a connection loss.
could you please send us your configuration
(repository.xml/workspace.xml) and the jackrabbit version you're using?
cheers
stefan
================================
Hi Stefan,
I've copied my repository.xml and workspace.xml at the bottom of this
email. As I mentioned in my reply to Thomas, I was using Jackrabbit
1.1.1.
I also updated my application to Jackrabbit 1.2.1; I will be testing it
for database connection timeouts later today.
Thanks,
Brian
<?xml version="1.0"?>
<Repository>
<!--
virtual file system where the repository stores global state
(e.g. registered namespaces, custom node types, etc.)
-->
<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
<param name="path" value="${rep.home}/repo"/>
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="url"
value="jdbc:sqlserver://server:1433;databaseName=projectDb"/>
<param name="schema" value="mssql"/>
<param name="user" value="username"/>
<param name="password" value="password"/>
<param name="schemaObjectPrefix" value="rep_"/>
</FileSystem>
<!--
security configuration
-->
<Security appName="Jackrabbit">
<!--
access manager:
class: FQN of class implementing the AccessManager interface
-->
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
<!-- <param name="config" value="${rep.home}/access.xml"/>
-->
</AccessManager>
<LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
<!-- anonymous user name ('anonymous' is the default value)
-->
<param name="anonymousId" value="anonymous"/>
<!--
default user name to be used instead of the anonymous user
when no login credentials are provided (unset by default)
-->
<!-- <param name="defaultUserId" value="superuser"/> -->
</LoginModule>
</Security>
<!--
location of workspaces root directory and name of default
workspace
-->
<Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default"/>
<!--
workspace configuration template:
used to create the initial workspace if there's no workspace yet
-->
<Workspace name="${wsp.name}">
<!--
virtual file system of the workspace:
class: FQN of class implementing the FileSystem interface
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
<param name="path" value="${wsp.home}"/>
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="url"
value="jdbc:sqlserver://server:1433;databaseName=projectDb"/>
<param name="schema" value="mssql"/>
<param name="user" value="username"/>
<param name="password" value="password"/>
<param name="schemaObjectPrefix" value="wsk_"/>
</FileSystem>
<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager
interface
-->
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="url"
value="jdbc:sqlserver://server:1433;databaseName=projectDb"/>
<param name="schema" value="mssql"/>
<param name="user" value="username"/>
<param name="password" value="password"/>
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
<param name="externalBLOBs" value="false"/>
</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"/>
</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.db.DbFileSystem">
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="url"
value="jdbc:sqlserver://server:1433;databaseName=projectDb"/>
<param name="schema" value="mssql"/>
<param name="user" value="username"/>
<param name="password" value="password"/>
<param name="schemaObjectPrefix" value="ver_"/>
</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.state.db.SimpleDbPersistenceManager">
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="url"
value="jdbc:sqlserver://server:1433;databaseName=projectDb"/>
<param name="schema" value="mssql"/>
<param name="user" value="username"/>
<param name="password" value="password"/>
<param name="externalBLOBs" value="false"/>
<param name="schemaObjectPrefix"
value="version_"/>
</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}/repo/index"/>
</SearchIndex>
</Repository>
<?xml version="1.0" encoding="UTF-8"?>
<Workspace name="default">
<!--
virtual file system of the workspace:
class: FQN of class implementing the FileSystem interface
-->
<FileSystem
class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
<param name="path" value="${wsp.home}"/>
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="url"
value="jdbc:sqlserver://server:1433;databaseName=projectDb"/>
<param name="schema" value="mssql"/>
<param name="user" value="username"/>
<param name="password" value="password"/>
<param name="schemaObjectPrefix" value="wsk_"/>
</FileSystem>
<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager
interface
-->
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<param name="url"
value="jdbc:sqlserver://server:1433;databaseName=projectDb"/>
<param name="schema" value="mssql"/>
<param name="user" value="username"/>
<param name="password" value="password"/>
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
<param name="externalBLOBs" value="false"/>
</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"/>
</SearchIndex>
</Workspace>
